Sage 100

100 advanced v4.5 - invoice has a November date. Cash receipt was entered with a 10/17 deposit date. The client says this invoice was pre-paid so they ""after the fact"" entered a cash receipt. At 10/31 one would expect the cash receipt to show as a negative on the AR aging, but it does not. GL doesn't agree to the aging because of this issue. Looks OK on the AR trial balance. Any ideas how to correct this?

Reverse and enter again making sure the receipt is entered as a prepayment or just let it be and make a note on the aging.

Making a note on the aging us not an option. I was hoping for a dfdm field modification or some other fix other than reversing and re entering transactions. Seems to me the credit should display anyway on the aging as the cash receipt date is in an earlier month than the invoice. If it works on the trial balance why not on the aging?

I think the issue is in the programming, not the data. AP Trial Balance has issues when a check date is prior to an invoice date. There is nothing ""wrong"" in the files - it's in how Sage programmers expected the data to be in the file.

This is AR cash receipts and invoicing not AP.

Sorry, I didn't make that clear - the AP TB is ANOTHER program with the same sort of issue.

Same reason they say only to use the TB to balance to the GL. Two different reports written by two different people who understood zero accounting. DFDM the posting and call it a PP type of invoice.

IF you DFDM, besure to look at booth the open invoice table and the transaction history table and the cash receipts history table.

The invoice is not selected for the aging if the INVOICE DATE is after the aging date. I'm sure the logic is, how can you have a payment against an invoice if the invoice isn't posted yet? It should have been entered as a prepayment to begin with. I would have reversed the cash receipt and re-entered it correctly but going into all the necessary tables through DFDM will also work.

Yes.. should have been entered as a prepayment but it wasn't. End user bought another company and has been entering invoices and cash receipts a month late. Entered several invoices with invoice date of November and also entered prepayments against those invoices as cash receipts in October. Now the AR aging doesn't display the prepayments at 10/31 so GL doesn't agree to AR... this is an issue because of bank reporting... i am aware of the 2 tables necessary to make changes but doesn't look like there is an easy way to change the tables without screwing this up further....proceeding with @ThereseLogeais suggestion and going to reverse the cash receipts and re-enter as cr/invoice prepayments. Thank you for all of the suggestions!

Should note that I was reinforcing @NancyHanson 's original suggestion.

Thanks @ThereseLogeais , appreciate the credit, not necessary but appreciated!