Import purchase orders into QuickBooks POS

Follow the steps in this article to import purchase orders in batch from Excel or text files into QuickBooks Point of Sale using Zed Axis.
  1. Open your QuickBooks Point of Sale company file and connect Zed Axis to it
  2. Click on the Import tab and browse to the location of the Excel or text file that you wish to import
  3. Add a mapping and map the columns in your import file to the corresponding fields in QuickBooks Point of Sale
  4. Click import and Zed Axis will create the purchase orders directly in QuickBooks Point of Sale
 


Import PO into QBPOS
 
Description of the fields on a purchase order you can import:
 
QuickBooks POS FieldFormatDescription
AssociateStr 40The employee making the purchase order transaction
Cancel DateDateDate after which after delivery may be refused
DiscountAmtThe amount of discount available on the transaction
Discount PercentFloatThe percentage discount available on the transaction
FeeAmtFee such as special handling fee
InstructionsStr2000Instructions to the Vendor regarding the order
Purchase Order NumberStr20Reference number for the purchase order (should be unique)
Purchase Order Status DescStrStatus for the order ie (Open, Closed or Custom, can be defined in QBPOS company pref)
Ship To Store NumberIntStore to which the item should be shipped (1-10)
Start Ship DateDateEstimated shipping date for the order
Store NumberIntThe number of the store values (1 -10) (multi store QBPOS only)
Terms DiscountFloatThe discount percentage
Terms Discount DaysIntNumber of days after which payment must be received to obtain discount
Terms Net DaysIntDays after invoice that payment is due
Txn DateDateDate of the purchase order
Vendor NameStr Mandatory Name of the vendor
ALUStr 20Item alternate lookup code, to match using this field please select the option in the more options settings
AttributeStr 12Item characteristic ie color, pattern, material etc.
CostAmt.Cost of the item purchased
Item NameStrMandatory Name of the item
Item Inventory DepartmentStrMandatory Department for item
Desc2StrSecondary description for the item
Extended CostAmtExtended amount of the line item ie Quanity x Cost
QtyQuanQuantity of the item purchased
SizeStr 12Size of the item
Unit Of MeasureStr 20Unit of measure for the item
UPCStr 18Items unique UPC/EAN/ISBN identifier

Add Feedback