Hi paddyr,
Thank you so much for your post and welcome to the Community Forum! I'm sorry to hear about the issue you've been facing and thanks for the detailed information. I really appreciate your patience and understanding about this issue,3 and I do apologize for the delayed response.
The issue you've identified regarding AccountRight only supporting the Posting date and not the Invoice date for Sales and Creditor Invoices can indeed affect the accuracy of Aged Accounts Receivable (AR) and Accounts Payable (AP) reporting, especially when invoices are processed after a month-end close with an invoice date in the prior period. While this limitation may present challenges, there are some considerations and potential workarounds to address this issue:
Custom Reporting:
- Consider creating custom reports or modifying existing reports within AccountRight to accommodate Aged AR and AP reporting based on the invoice date. Custom reports may provide more flexibility in selecting the date criteria for your specific reporting needs.
Accrual Accounting Adjustments:
- In accrual accounting, transactions are recorded when they are incurred, not when cash is exchanged. If your organization follows accrual accounting principles, you can make accrual adjustments to ensure that invoices with an invoice date in a prior period are accounted for in that period. This can help align your financial reporting with the invoice date.
Please do let me know how you go on this.
Regards,
Earl