Pls present to the user group:
We have a practice of invoicing our customers for inventory that we manufactured that has not moved after 120 days. In most cases, the inventory does not move from its location in the warehouse, we simply invoice the customer.
What is the best way to exclude the value of the ware that has been invoiced from our inventory value reports? Note: In some cases, we may have 50,000 bottles that have been invoiced and 50,000 bottles that have not, therefore, zeroing out the costs is not an option.
We need to continue to maintain visibility in MRP but exclude from inventory cost reports.
Jack
:::::
o.k. Peggers, This is 8.6e progress 8.3a
As a little foot note, The customers that usually order the ware either give us a sales order with a due date that is much earlier than they actually plan to take it. The other way is the customer gives us a paper forecast as to what product they want and how and when they want it, but then they don't pick it up for three to five months. After 120 days, our accounting dept issues a misc. invoice for the customer to bill them for the ware whether or not they actually ask for it's delivery. The whole problem is, is if we put the inventory to a non nettable location and the sales order is not yet received for the ware, MRP won't see the inventory, but when the S.O. comes in, then MRP will atempt to plan for it, because it sees the new demand. the whole bottom line is that shipping and manufacturing want to be able to see it, but Accounting does not.
dave.
We have a practice of invoicing our customers for inventory that we manufactured that has not moved after 120 days. In most cases, the inventory does not move from its location in the warehouse, we simply invoice the customer.
What is the best way to exclude the value of the ware that has been invoiced from our inventory value reports? Note: In some cases, we may have 50,000 bottles that have been invoiced and 50,000 bottles that have not, therefore, zeroing out the costs is not an option.
We need to continue to maintain visibility in MRP but exclude from inventory cost reports.
Jack
:::::
o.k. Peggers, This is 8.6e progress 8.3a
As a little foot note, The customers that usually order the ware either give us a sales order with a due date that is much earlier than they actually plan to take it. The other way is the customer gives us a paper forecast as to what product they want and how and when they want it, but then they don't pick it up for three to five months. After 120 days, our accounting dept issues a misc. invoice for the customer to bill them for the ware whether or not they actually ask for it's delivery. The whole problem is, is if we put the inventory to a non nettable location and the sales order is not yet received for the ware, MRP won't see the inventory, but when the S.O. comes in, then MRP will atempt to plan for it, because it sees the new demand. the whole bottom line is that shipping and manufacturing want to be able to see it, but Accounting does not.
dave.