Warehouse Master Effects when an item is Sold

The Warehouse Master File (Task 19 in the Inventory module) contains information that prints on the End of Month Status by Location report (WHSEOM – found in the Inventory module, Task 10, Sub-task 2).  The following is a summary of changes in the pertinent fields that occur in the Warehouse Master when an order for an item is generated and subsequently invoiced.  The WHSEOM report will reflect the changes in the record, dependent on the status of the order.

Warehouse Master File record before an order is entered:

01. Item #         105-2 Paper    8.5 x 11 CREAM PAPER

02. Warehouse #    01                  

03. Qty on hand    10                       

04. Committed      2                      

08. Last sale      11/07/03                 

09. EOM Qty        10                        

10. MTD Qty sold   5                        

11. MTD Sales $    195.00                     

12. MTD Cost $     125.00                        

28. YTD Qty sold   144                

29. YTD Sales $    5616.00

30. YTD Cost $     3600.00

Warehouse Master File record after an order is entered but not yet invoiced   Note:  for the example, assume that a quantity of one was ordered.  The quantity Committed is increased by the quantity specified on the open order, NO other fields were affected.  Any calculations based on the quantity Committed be reflected on the WHSEOM report. 

01. Item #         105-2 Paper    8.5 x 11 CREAM PAPER

02. Warehouse #    01                     

03. Qty on hand    10                                 

04. Committed      3                              

08. Last sale      11/07/03                          

09. EOM Qty        10                          

10. MTD Qty sold   5                           

11. MTD Sales $    195.00                        

12. MTD Cost $     125.00                        

28. YTD Qty sold   144

29. YTD Sales $    5616.00

30. YTD Cost $     3600.00

Warehouse Master File record after the order is invoiced.  The Qty on Hand and Qty Committed decrease by the quantity specified on the order.  The MTD Qty sold and YTD Qty sold increase by the quantity specified on the order.  The MTD Sales and YTD Sales increase by the price the item sold.  MTD Cost and YTD Cost increase by the cost the item carried in the Item Master file.  The Last Sale Date is changed to reflect the date the item was last invoice.

01. Item #         105-2 Paper    8.5 x 11 CREAM PAPER

02. Warehouse #    01

03. Qty on hand    09                               

04. Committed      2                           

08. Last sale      11/15/03                  

09. EOM Qty        11                           

10. MTD Qty sold   6                           

11. MTD Sales $    234.00                  

12. MTD Cost $     150.00                 

28. YTD Qty sold   145                          

29. YTD Sales $    5655.00

30. YTD Cost $     3625.00