Did Receipt of Invoice Before Receipt of Goods. Reversed It (ID:21404) But Item Qtys Not Reversed.

SUGGESTED

Using MAS 200 (Sage 100) 

PO was created for an inventory order.

Order was delivered to the warehouse.  Invoice was emailed to accounting.

There was a delay in warehouse and receipt of goods was not done before the receipt of invoice was processed.  Now warehouse cannot do the receipt of goods. 

Did a reversal of the receipt of invoice entry posting (KB 21401) but that did not change the On PO quantities for the items on the PO.

How can we change the "On PO" item quantities?  Don't see anything anywere on how to do this?

  • 0

    Was the invoice processed using ROI entry, not ROG entry?

    An invoice entered through ROG entry will end up posting the inventory receipt too.  Check the inventory transaction history for the items invoiced, and I expect you'll see they were received.

    Also look on the PO lines (lower grid) for the Qty Received and Qty Invoiced.

  • 0 in reply to Kevin M

    The AP Invoice was entered using Receipt of Invoice entry.
    The warehouse only does the Receipt of Goods (verify they received the correct item amounts) using the packing slip from AP vendor.  Then accounting does the Receipt of Invoice entry after receiving the actual AP invoice.  This is the first time the ROI was done before the ROG - was a mistake.  I can resolve the issue except for the On PO item quantity is wrong (still shows the item qty for line items on PO.)  Owners want that corrected.

  • 0 in reply to Kevin M

    The Qty Received for every line item is 0 (lower grid), which is the problem.

    Also for Qty Invoiced - zero.

    There was no ROG done for the PO.

    Is there a way to enter the Qty Received/Invoiced through DFDM utility?  I would try that now IF that would let me enter the qty and not mess up anything else.  I have a mirror of the server on another PC I could use to try that.

  • 0 in reply to Armadillo

    RoI can be done before RoG, no problem.  Why can't the warehouse do the RoG?

  • 0 in reply to Armadillo
    SUGGESTED

    If the Qty Received is Zero (0) for each line then just do a ROG.  The system doesn't care if you do ROI or ROG first.  Print out the Open Purchase Order report for just that purchase order and see how many are showing as received and how many are showing as invoiced.

  • 0 in reply to BigLouie

    On Open PO Report:
    Zeros on all received and invoiced fields.  The PO Status is "Complete."

    I previously did a "reverse a Receipt of Invoice Entry posting" thinking it would back out the ROI so they could do the ROG.  It did reverse the debit and credit amounts on the GL accounts but Purchasing still could not do a receipt of goods for that PO.

    The purchasing manager told me when they do the ROG they don't enter the AP invoice number (leaves it blank).  When accounting receives the invoice (enters Inv # then the ROI is done.  Have been doing it that way for 18 years.

    I can create a new PO so they can do the ROG to get the items into inventory but it would still leave those original amounts in "On PO" field (which bothers the owner.)  is there any way to fix that?  I appreciate your input.