Import inventory quantity adjustments into QuickBooks POS

Import inventory quantity adjustments into QuickBooks POS.
  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 inventory items quantity adjustments directly in QuickBooks Point of Sale
QuickBooks POS Field Format Description
Associate Str 40 The employee making the adjustment transaction
Comments Str 2000 Description of the transaction
Inventory Adjustment Source Enum How the adjustment was made. Values Manual, PhysicalInventory, Assembly
QuickBooks Flag Enum Status of export to QB Desktop. Values NotPosted, Completed, Error, UnbilledPurchases
Reason Str 8 Reason for the adjustment; Reasons - Cycle Count (Cycl Cnt), Vendor Change (Vend Chg), Price Line (Prc Line), End of Season (Seas End), Annual (Annual), Shrinkage (Shrink), Stolen (Stolen), Damaged (Damaged), New Item (New Item)
Store Number Int The store number (1 - 10 stores)
Txn Date Date Date of the Inventory Adjustment
Txn State Enum Whether the adjustment is complete or held  Values - Normal, Held
Workstation Int Workstation from where the transaction was posted
Item Name Str Name of the inventory item
Item Inventory Department Str Department for the inventory item
New Quantity Quan The new quantity for the inventory item
Serial Number Str 25 The inventory items serial number
Unit of Measure Str 20 The single or base unit for the item, adjustments are alway made against the base unit

Add Feedback