Import inventory cost adjustments into QuickBooks POS

You can import inventory cost adjustments into QuickBooks POS from text or Excel files using Zed Axis. Follow these steps:

Open your QuickBooks Point of Sale company file and connect Zed Axis to it
Click on the Import tab and browse to the location of the Excel or text file that you wish to import
Add a mapping and map the columns in your import file to the corresponding fields in QuickBooks Point of Sale
Click import and Zed Axis will create the inventory items cost adjustments directly in QuickBooks Point of Sale

QuickBooks POS Field	Type	Description
Associate	Str 40	The name of the employee making the inventory cost adjustment
Comments	Str 300	The description for the cost adjustment
Inventory Adjustment Source	Enum	The action that made the adjustment (Manual, PhysicalInventory, or Assembly)
QuickBooks Flag	Enum	Whether data has been export to QuickBooks (NotPosted, Completed, Error or UnbilledPurchases)
Reason	Str 8	Pre-defined reason for the adjustment (Cycl Cnt, Vend Chg, Prc Line, Seas End, Annual, Shrink, Stolen, Damaged, or New Item)
Store Number	int	The number of the store making the adjustment
Ref Number	Str	A reference number for the cost adjustment used by Axis to group rows together on the same transaction does not appear in QB POS user interface
Txn Date	Date	Date of the adjustment
Work Station	Int	The workstation number making the adjustment
Item Name	Str	Name of the inventory item being adjusted
Item Inventory Department	Str	Department name for the item
New Cost	Amount	New cost for the item being adjusted
Unit Of Measure	Str 20	Unit of measure for the item

Article ID: 251, Created: 7/9/2014 at 7:18 AM, Modified: 12/4/2019 at 5:28 AM