We issue our monthly requisitions with an invoice date that differs from the account date as we use accounting date of last day of the month. This seem to cause a problem when running AR Aging by Job, Customer or Contract by accounting date. The payments will not always line up in the correct aging columns to ZERO out the invoice paid.
Would it be Best Practice to use the invoice date as the accounting date or have all invoices dated the last day of each month? I never had this problem using Sage CRE at previous employers and think that the only issue as the accounting/invoice dates we used were the same.
