Hi,
I am trying to build an Accounts Receivables As Of a date report for Epicor 10 but find the transactions to be very puzzling.
There are two columns.
AR invoices details and AR cash payments
You should be ale to take one from the other and get a balance but no.
There are three transactions in the cash column, Adjustments that normally get entered as a negative which needs to be changed to a positive number if you do the above, but sometimes not. Credit Memos that need to be changed to a positive as well but sometimes not as well.
Then on the invoice side we have Credit Memos, Debit Notes and Unapplied cash all with the signs totally meaningless. Epicor seem to know what to do when they produce their AS Of but has anyone got any idea on how they calculate this. It seems a total mess.
Thanks for any help