cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
theresa_alras
Level 1

Import Supplier Credits all at once

 
1 Comment 1
Fiat Lux - ASIA
Level 15

Import Supplier Credits all at once

Prepare the Vendor Credits data with the following template

RefNumberAPAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples ######### 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples ######### 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples ######### 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office FurnitueNew Chairs300.18           
185 Green's Taxi Service ######### 1 Main Street   San DiegoCA12345    Transportation 125.13           
201 Federal Express ######### PO Box 1800   DallasTX23456    Delivery Chargestracking number PR7 1HX25.15           
201 Federal Express ######### PO Box 1800   DallasTX23456    Delivery Chargestracking number 1235885.3           
201 Federal Express ######### PO Box 1800   DallasTX23456    Delivery Chargestracking number 1238765.12           

 

then utilize the trial version of a importer tool 

https://transactionpro.grsm.io/qbo