We have found that the AR Advance Billing/Deposit Report is showing deposits for sales orders which have been processed and shipped. These deposits should no longer show on the report.
Epicor Support had an SCR, which was then canceled and replaced by another, stating that since only the report was wrong and the GL was affected properly, that this was a 'cosmetic' issue. Their resolution was either we correct the report or call their custom programming group.
I wouldn't mind correcting the report if I understood the logic behind it. The RDD contains a table named 'OrderDtl'. However, it appears to be a code-generated table as it contains values for orders that do not match the database. I think they meant the table to be more like 'OrderInfo'.
Has anyone been able to successfully reproduce this report? I can't figure out which table should be the 'controlling table'. That is, which tables tell me whether a deposit has been fully applied or not?
Thanks,
Bob Beaghan
Epicor Support had an SCR, which was then canceled and replaced by another, stating that since only the report was wrong and the GL was affected properly, that this was a 'cosmetic' issue. Their resolution was either we correct the report or call their custom programming group.
I wouldn't mind correcting the report if I understood the logic behind it. The RDD contains a table named 'OrderDtl'. However, it appears to be a code-generated table as it contains values for orders that do not match the database. I think they meant the table to be more like 'OrderInfo'.
Has anyone been able to successfully reproduce this report? I can't figure out which table should be the 'controlling table'. That is, which tables tell me whether a deposit has been fully applied or not?
Thanks,
Bob Beaghan