SQL Misc Receipts Due Date
SummaryI require to find the field for the due date for miscellaneous receipts
I am producing an AR ageing report and have all the AR data i require from the ar_payment_schedules_all apart from the miscellaneous receipts (i believe), this table holds the due date for the other data, but i cannot seem to find the due date for the miscellaneous receipts.
The closest i have been able to find it how it would be possible to calculate it, using RA_TERMS_LINES. However, i would prefer to not calculate if anyone has any suggestion regarding my issue?