Solution to an Inventory Dilemma

Recent tips have been geared toward general topics about Sage 100 Contractor.  This one is just for the accountants and bookkeepers out there.

Users of the Inventory module know that the system will not let the quantity on hand for any inventory item go below zero.  Recently, a client called with the following scenario:

• They found that a payable invoice for two inventory items had been entered erroneously on Monday through the use of menu 12-4 Purchase Order Receipts. 
• Tuesday, an inventory allocation had been entered and shipped to move one of these inventory items to a job. 
• Wednesday, it was discovered that the second inventory item entered on Monday had not been received and was instead backordered.  When the error in the entry of the invoice on Monday was discovered, the client tried to void and re-enter the invoice correctly.  However, the system would not permit the client to void Monday’s erroneous entry because there was not sufficient inventory quantity on hand of the one item to absorb the quantity that would be subtracted from inventory with the voiding of that invoice – it would have caused the quantity on hand for that item to go below zero.
• When they called for help on Thursday, I suggested the following steps to correct the erroneously entered invoice:
• Copy the erroneous AP Invoice record that was entered on Monday in menu 4-2.
• Paste the copied invoice to a new record in 4-2 and modify the entry to the way it should have been entered with the item that was received and not the item that was backordered.
• Save this new 4-2 AP Invoice record.
• This will increase the quantity on hand for the first inventory items involved in the correction and the Tuesday inventory allocation.
• Then go find the erroneously entered AP Invoice and void it.  This takes the backordered item out of inventory and adjusts the quantity on hand of the item actually received on Monday and partially shipped out on Tuesday to the correct amount.
• The order in which these entries are recorded is a little counter intuitive, but when you follow it through, checking the recorded inventory quantities on hand at each step, you can see how it works.

For more help with inventory issues, don’t hesitate to call your friendly Certified Consultant!