Talk to Sales: 877-683-3280

Hours

Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST

Product support & help

Need help signing in?

accounts3-spectr

Question

How to import sales invoice with multiple class

Forum|Forum|6 years ago
September 29, 2020
1 reply
3 views

No text available

QuickBooks Online - International

Fiat Lux - ASIA

Level 14

You may prepare multi line Invoice data with the following template and different classes

RefNumber

Customer

TxnDate

DueDate

ShipDate

ShipMethodName

TrackingNum

SalesTerm

Location

Class

BillAddrLine1

BillAddrLine2

BillAddrLine3

BillAddrLine4

BillAddrCity

BillAddrState

BillAddrPostalCode

BillAddrCountry

ShipAddrLine1

ShipAddrLine2

ShipAddrLine3

ShipAddrLine4

ShipAddrCity

ShipAddrState

ShipAddrPostalCode

ShipAddrCountry

PrivateNote

Msg

BillEmail

BillEmailCc

BillEmailBcc

Currency

ExchangeRate

Deposit

ToBePrinted

ToBeEmailed

AllowIPNPayment

AllowOnlineCreditCardPayment

AllowOnlineACHPayment

ShipAmt

ShipItem

DiscountAmt

DiscountRate

TaxRate

TaxAmt

DiscountTaxable

LineServiceDate

LineItem

LineDesc

LineQty

LineUnitPrice

LineAmount

LineClass

LineTaxable

101

Janice Johnson

01/10/2020

01/12/2020

Ground

Net 30

110 Main Street

Suite 2000

Dallas

TX

99875

110 Main Street

Suite 2000

Dallas

TX

99875

Special Handling

Thank you for your order!

0

N

Y

N

N

Y

12

Shipping

0.02

Y

MP3 Player

Blue MP3 Player

2

55

TAX

101

Janice Johnson

01/10/2020

01/12/2020

Ground

Net 30

110 Main Street

Suite 2000

Dallas

TX

99875

110 Main Street

Suite 2000

Dallas

TX

99875

Special Handling

Thank you for your order!

0

N

Y

N

N

Y

12

Shipping

0.02

Y

Leather Case

Leather Case

2

10

TAX

101

Janice Johnson

01/10/2020

01/12/2020

Ground

Net 30

110 Main Street

Suite 2000

Dallas

TX

99875

110 Main Street

Suite 2000

Dallas

TX

99875

Special Handling

Thank you for your order!

0

N

Y

N

N

Y

12

Shipping

0.02

Y

Gift Cards

Gift Cards

2

5

TAX

102

Leonard Walker Inc

01/10/2020

Net 30

9 Winding Road

Winchester

NY

12345

9 Winding Road

Winchester

NY

12345

Thank you for your order!

0

Y

N

N

N

Y

Y

Handhelds

Portable Game Player

1

100

TAX

102

Leonard Walker Inc

01/10/2020

Net 30

9 Winding Road

Winchester

NY

12345

9 Winding Road

Winchester

NY

12345

Thank you for your order!

0

Y

N

N

N

Y

Y

Software

1 Year Warranty

1

25

TAX

then utilize the trial period of TPImporter

https://transactionpro.grsm.io/qbo