A client has reported the following behaviour.
The client takes deposits on orders, these are entered as unapplied cash. Later, when the delivery is made, the invoice and balance payment are entered.
When printing a report 'calculate as of' in order to match a total to the GL, the balance on the report changes from day to day because unapplied cash that has been matched to an invoice dated AFTER the 'calculate as of' date is being removed from the report, despite having a date earlier than the 'calculate as of'

Should this be happening?

Any way around this other than telling them NOT to match invoices and final payments to original unapplied cash?

Hi Tony,

What version of Adagio Receivables is in use? I cannot duplicate the same scenario with the current shipping version 6.8B (20040507). I post an unapplied cash amount for a customer, then post an invoice (unmatched) with a larger amount and a later date. Lastly, I post a cash payment for the remainder of the invoice, applied to both the deposit and the invoice.

When I preview the Aged Trial Balance, calculated as of a date after the deposit but prior to the invoice and 2nd payment, the deposit amount detail prints on the report as expected.

Are the processing steps for the transactions being done differently than what I mentioned above? Are they using an older release (some work has been done to the transaction reports recently)?
-----
If you are referring to printing the ATB report with a Calculate As Of date after all 3 transactions, then it appears the deposit transaction is getting lumped in with the final payment. I will say that another DOS AR program does the exact same thing, but this might not be what's 'supposed' to happen - I don't know about this.

They have not said anything since the 20040507 update, but they were using the most up-to-date version to that point.

I have examples of the reports showing (or rather not showing) the problem cash transactions.

I will try reprinting the same examples now that the update is installed.

Ok, I have tried it in the latest release and the problem still occurs.

Hi Tony,

We will email you to get more info so we can duplicate the problem.

Regards,
Softrak Tech Support

Hello Tony,

Thank you for the clear example.

The Aged Trial Balance does match the model it was based on for this example.

However, I will add this to the wishlist for Receivables for a future release.