Maintenance

This will value your inventory at less than $0.00.

 

Situation

  1. You attempt to reverse or delete a purchase order.


  2. The average cost at this point in time of an item on the purchase order is lower than when the purchase was recorded.


  3. There are few enough items remaining in your inventory that, with the average cost reduction, reversing or deleting the purchase order will make the total inventory value of the item less than $0.00.


When you reverse a purchase order, you actually create a new purchase order with opposite amounts. If the new total inventory value of the item on the reversed purchase order is higher than its current total inventory value, the total inventory value of the item would be negative. However, MYOB AccountEdge doesn't allow negative total inventory value when there is a positive (or zero) inventory quantity for the item.

Solution

Follow this procedure to reverse or delete the purchase order:

  1. Use the Index to Reports window to display the Items List Summary report. In the Total Value column of the report, find the total inventory value of the item whose purchase order you want to reverse.


  2. Display the purchase order you want to reverse in the Purchases window. To do this, open the Purchases window and click the Journal button. In the Transaction Journal window, enter a date range that includes the transaction you want to reverse in the Dated From and to fields. In the scrolling list, locate the transaction you want to reverse and click its zoom arrow. The transaction appears in the Purchases window.


  3. Determine the original amount of the purchase of the item. The purchase amount for a line item appears in the Total field for that line item.


  4. Calculate the difference between the item's original purchase amount (from step 3) and the item's current total inventory value (from step 1).


  5. Use the Adjust Inventory window to enter an inventoried adjustment transaction for the item to increase its total inventory value by the amount you calculated in step 4. Be sure to enter 0 in the Quantity field. Enter the adjustment as a positive number in the Amount field. Use a cost of sales account in the Account field. Click Record.


  6. Display the purchases transaction you want to reverse in the Purchases window in the same manner as you used in step 2.


  7. If you marked the `Data File Records CANNOT Be Changed; Saved Entries Must Be Reversed' selection in the Preferences window, choose Reverse Purchase from the Edit menu to prepare a reversing transaction; then click Record Reversal.


    If you did not mark the `Data File Records CANNOT Be Changed; Saved Entries Must Be Reversed' selection in the Preferences window, choose Delete Purchase from the Edit menu to delete the transaction.
  1. Display a new Items List (Summary) Report. Be sure the quantity and total inventory value of the item you adjusted are correct. If they aren't correct, you can record another inventory adjustment transaction to correct them.


    You might want to enter a new purchases transaction with correct information to replace the one you've reversed or deleted, especially if the purchase order contained several line items that didn't require inventory adjustments.

Related topics