PO Payables Clearing Audit List report to have an option to print only Receipts that are still pending. Also to be able to sort and list down if the Receipt with corresponding Invoices Number that are partially invoiced.
by: AFON S. | over a year ago | Reports / BI
Comments
This is a great idea. It would save us hours of work trying to figure out which reciepts are still outstanding.
At CP Moore we have written a nice utility to do this. Our utility produces a list of general ledger transactions that cannot be matched by PO Receipt number range of financial periods.
It also works to match the shipment and invoice transactions by shipment number generated by order entry.
If anybody is interested please contact me at CP Moore stuart@cpmoore.com
There definitely needs to be a basic report included in the PO module that will give you a list like the AP Aged Payables that you can use to match against your PO Payable control account.
This report is a definite necessity. All po receipt LINES that are not invoiced, as well as the po returns not credited need to be on a standard report. I have been able to search via the finder in po invoice entry, filtering the data to compile a list of open receipts, however unable to create a report extracting from the database the open/not completed lines on a receipt. Our inventory comes in from many different suppliers, billed through one vendor, so there are alot of receipts that individual lines are cleared (depending on when the vendor invoices the particular product from their supplier). The ideal report would include filters for vendor numbers and date ranges. Our reseller has attempted to create the report, but has run into issues with not capturing all of the uninvoiced/uncredited lines. I think the tie in between the header & detail tables may be part of the problem (?).
PLEASE do this!!!!!!!!
This is a definiate need. This list just gets longer and longer even though many of the transactions are easily matched.
This is essential!
Agree 100% - This would make it easier to reconcile the accrued expense account.
This idea has been here a long time - probably 2 + years.
It's highly useful and goes along withe other ideas concerning reconciliation support.
The cumulative votes across these similar ideas are high.
How about it Sage?
13 Aug 2014
90 Votes for this idea as at 12th April 2022.
Guess the seed was planted but didn't grow.