Best course of action depends on how many transactions are not in sync. A couple, try the DFDM route. Personally, I would go with the purge utility, then make a JE to force the GL balance to agree with the report as of the date you do it (today). Also spend time with client reviewing the importance of paying attention when posting receipts or payables and what to do when quantities don't agree.
Doesn't it seem like YESTERDAY when Diane Coffman headed up a session about Purchases Clearing (Vegas Summit in 2014) that MANY resellers asked for an easier way to clean up this report? Maybe Sage was operating under VEGAS RULES and everything stayed there?????
------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------
Original Message:
Sent: 09-12-2022 11:32
From: Michelle Forsey
Subject: Purchase Clearing Report
If you go into PO_PurchaseOrderDetail you can modify the qty recv'd, ordered or invoiced so they all match and it will remove them from the report. Of course, this would be considered "falsifying records" So when my clients would do it, I would recommend they also modify the comment field to indicate it was modified (also good if they have to go back and try and figure out what the heck happened. Most of the time we would export the detail records, modify those that needed it (including adding a comment or UDF field to say what the original was) and then re-import back in. I also recommended that they keep a copy of both the original and modified Excel spreadsheets in case of an audit.
------------------------------
Michelle Forsey
M4C Consulting
------------------------------