Page History: Inventory Qty Import

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, 09 Aug 2011 14:58

Table of Contents [Hide/Show]

   General Description
   Filters/Fields
      Mapping File
      Sample Import File

General Description¶

Default Menu Location: Transaction >> Importers/Exporters >> Item Control >> Inventory Qty Import

Screen Name: IMPORTQTYIMP

Function: Add or replace stock inventory quantities.

Average Cost will be updated according to the value in the spreadsheet. Inventory Cost Tiers are not updated; they must be added using the Cost Tier Import.

Inventory Qty Import - Click for full size

Filters/Fields¶

Item File Name: File being imported

Default Owner: Owner of the inventory

Default Whse: Warehouse where inventory is stored

Default Heldfor: Inventory is being held for

Transaction Date: The date transaction is made

Add to OnHand: Inventory quantity is being added to "On Hand" quantity

Replace OnHand: Inventory quantity is being replaced with "On Hand" quantity

Mapping File¶

Mapping File (Import with Import/Export Mapping Tool)

Sample Import File¶

Sample Import File