How to clear Misc Charges on Purchases Clearing Report

SOLVED

Working with Sage 100c Advanced v2019 and need to clean up Purchase Clearing Report where some PO's on report have Misc Charges on them, they go back years.  

Example:

Qty Ordered = 7.00

Qty Received = 0.00 (Can't receive Qty on a Charge)

Qty Invoiced = 7.00

Extended Purchases Clearing Amount = (7.00 x Unit Cost) = Negative Amount

How do I get these Misc Charges off the report?

  • 0
    SUGGESTED

    Hi Kenny98 –

    I believe you are referring to miscellaneous items, not charges. You can & should receive quantities for misc items. So that would be the thing to do to get them off of your purchases clearing report.

    Miscellaneous charges do not have quantities at all and won’t show up on the clearing report.

  • +1 in reply to Helium
    verified answer

    Yes, I meant Misc Items.  I had the staff change how they process assets, freight, repair work, and other non-inventory items going forward.  Since these were old PO's from years ago, I ended up creating import job to populate the Qty Rec to match Qty Invoiced and then had staff member delete them one-by-one to get rid of them.  GL affects were handled by CFO years ago.