Import transfer slips into QuickBooks POS

If you need to move inventory items between QuickBooks Point of Sales store then you would use a Transfer Slip.  It is possible using Zed Axis import utility to take inter store transfer data held in a spreadsheet or text file and import that into QuickBooks Point of Sales.

  1. Open Zed Axis and connect to your QuickBooks Point of Sale company file
  2. Browse to the Excel or text file that contains the Transfer Slip data that you wish to import.
  3. Create a mapping between the columns in your import file and the fields in QuickBooks POS.
  4. Finally click import and Zed Axis will import those directly in.

QuickBooks POS fieldTypeDescription
AssociateStr 40The employee entering the transfer slip
CarrierStr 15Shipping company used to transfer the inventory
Comments2000 charsDescription of the transaction
FreightAmountPriced charged by the shipping carrier
FromStoreNumberIntStore number the items are being transferred from
SlipETADateEstimate time of arrival as destination store
ToStoreNumberIntStore number the items are being transferred to
TxnDateDateDate of the transaction
TxnStateEnumIndicates if the transaction is complete (Normal) or is a held (Held) document
WorkstationIntWorkstation number the transaction was made from
ItemNameStrName (desc) or the Item being transferred
ALUStrAlternate Lookup for the Item being transferred
ItemInventoryDepartmentStrDepartment for the item
QtyQtyQuantity of the item being transferred
SerialNumberStr 25Serial Number for the item being transferred
UnitOfMeasureStr 20Unit of Measure for the item
UPCStr 50Univeral Product Code for the item being transferred



 

Add Feedback