Sage 100

Anyone ever create a purchases clearing report that could be run by date? I don't think the data is there to make this happen. Can someone confirm or deny? Client is currently on 2016.

I believe we did this in Sage Intelligence for a client. The report had to look at all of the history similar to a trial balance in the other modules so we had to pick an ""oldest"" cutoff date and hard code it in the report in addition to the ending date that the user was prompted for. There was some cleanup required on the older PO's but I'm pretty sure they still use the report on a monthly basis.

There is no such thing, but what I have done in order to do so is to create a UDF that flows from PO Receipt History Detail and AP Invoice History Detail for the PO Line Key for each item, so that you can build a custom Crystal Report.

I found this and confirmed that it is still being used by the client, maybe it will get you what you're looking for.

Aren't there date Selections on the standard P/O Purch Clearing Reports (e.g., Order Date, Receipt Date)? Also, what about editing the standard report and incorporating a Date Parameter?