When we print an accounts receivable aging, the detailed aging report includes all invoices and the related payments that have not been reconciled as of the report run date. It does not seem to be possible in SAP B1 2005A to reconcile any payment that includes a partial payment. This makes the report very confusing. Combined with the lack of invoice dates, this makes the report useless for us.
I attempted to create a simple query and a Crystal report that will at least give us this information as of the current date without columns for number of days past due, but have not been able to get all the relevant data included. Invoices and Credit Memos are no problem, but I can't figure out how to combine Journal Entries and Payments on Account correctly.
I have found a few queries posted in these forums that promised to work, but they really don't (either they work for a different version of B1 or have syntax or logic issues).
We really need a detailed receivables aging report that we can run as of any prior date that gives us Document Date, Document Number, and Document Open Balance and the total must match the G/L Control Account as of the selected date.
We've been searching for a way to get the information needed for months. If anyone can help, PLEASE reply. Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.