Physical Inventory Post Work File

Use the Physical Inventory Post Work File routine to update quantities of each item with the physical count that reflect the verified quantities of the items.  The post will update the system on-hand quantity to match the physical count quantity.  Generally, it is important to choose the same ranges here as were chosen when the count sheets were printed.

Notes:

• The Physical Inventory Post report rounds values to two decimal places.  

• Item costs used in the variance calculations are pulled from different fields depending on how the Inventory Parameters Cost Based On option is set.  The Cost Based On options are 0=Average cost, 1=Standard cost, 2=Last cost, 4=Average(LIFO), or 5=Average(FIFO).  It is important to note that item costs are not updated during this routine, only quantities.

• The Post Work File printout will list all items that are updated.  It looks similar to the Physical Inventory Variance Report.

• For more information about running reports, see Print View.

• For more information about the buttons on the toolbar, see the Reporting Toolbar.

Directions:

To see directions for...

• Opening the Physical Inventory Post Work File Routine, click More.

   

  1.  Click Physical Inventory Menu from the Menu Bar.

  2.  Click Physical Inventory Post Work File.

   

  Physical Inventory Post Work File Window Example:

  

   

• Choosing the Selections at the Prompt Window, click More.

   

  Physical Inventory Post Instructions Prompts Tips:   To see more information about a field, click the hyperlink for the field name. Physical Inventory Post Parameters can saved and loaded.  For information, see Reporting Toolbar.
  Item	To specify a range of Items to include in the Physical Inventory Post, click to select the lower range/beginning Item.  To specify the ending range, click to select the upper range Item. Notes:   To include all items in the Physical Inventory Post, leave the lower and upper range blank for All.   Or, to only include a specific item, enter the Item as the lower range. To search for an Item, click in the lower or upper range and then press [Ctrl + f].
  Location	To specify a range of Locations to include in the Physical Inventory Post, click to select the lower/beginning Location.  To specify the ending range, click to select the upper range Location. Note:  To include all locations in the Physical Inventory Post, leave the lower and upper range blank for All. Or, to only include a specific location, click to select the specific location as the lower range.
  Bin	To specify a range of Bins to include in the Physical Inventory Post, enter the lower/beginning Bin.  To specify the ending range, enter the upper range Bin. Note:  To include all bins in the Physical Inventory Post, leave the lower and upper range blank for All.   Or, to only include a specific Bin, enter the Bin as the lower range.
  Cycle Code	To specify a range of Cycle Codes to include in the Physical Inventory Post, enter the lower/beginning Cycle Code.  To specify the ending range, enter the upper range Cycle Code. Note:  To include all codes in the Physical Inventory Post, leave the lower and upper range blank for All.   Or, to only include a specific Cycle Code, enter the code as the lower range.
  Product Category	To specify a range of Product Categories to include in the Physical Inventory Post, click to select the lower/beginning Product Category.  To specify the ending range, click to select the upper range Product Category. Note:  To include all product categories in the Physical Inventory Post, leave the lower and upper range blank for All. Or, to only include a specific product category, click to select the specific product category as the lower range.
  	To begin the routine and print to the Windows® default printer, click Print, or press [ENTER].
  	To run the routine and print to the Print View window, click here.
  	To escape from the print routine, click Cancel.

   

• Report Sample(s), click More.

   

  To see an example of the report, click Physical Inventory Post Work File Printout Sample.