Purchases Clearing Report Mission

I am on a mission to shrink our PC report, branching off of this post I made previously, https://communityhub.sage.com/us/sage100/f/unique-business-challenges/211318/drop-ship-po-s-in-purchases-clearing.  After speaking with AP they stated some of our vendors that we pay with credit cards, do not send invoices, so a ROI is never preformed, therefor the PO sits in the PC account showing qty ord = qty rec but qty invoiced stays at 0.  Any ideas or suggestions on how to handle this?  First thought is purchasing must get some kind of confirmation of the order that they could send to AP and then enter the ROI off of the confirmation (if they send one).

  • 0

    When paying with a credit card what I always do is to enter an invoice for the vendor in PO Receipt of Invoice and then do an Invoice Transfer in AP from the Vendor to the Credit Card company. If they don't send me an invoice I just use the PO number as invoice number, however you should always get a receipt for a credit card charge.

  • 0 in reply to BigLouie

    What BigLouie said, exactly.

    To clean up the history perhaps do zero $ ROI's for everything you know was paid by CC, then GL fixes posted separately (because the ROI DTR's should post to the purchasing variance account, which is not likely how the CC payment was processed).

  • 0 in reply to Kevin M

    On day two of cleaning the PC report, I tried doing a ROI for a PO that had qty ord 200 -qty rec 188- qty inv 200 and on the ROI I invoiced a -12 with a $0 amount.   I am not familiar with the GL/ACCT back end, would this cause any issues?  I am thinking I could fix everything in the ROI instead of having to do a ROG and then worry about inventory.  All these old po's we do not owe anything to our vendor's and nothing needs to be taken out or put in inventory.