Breadcrumbs

Dynamic AR/AP aging with Inventory & Reconciliation report samples - Acumatica

Purpose

Please see Introduction to Report Templates for information about Samples, Demos, and Production Templates and the differences between them. You many also want to refer to How to Modify Velixo Sample Reports.

To help you learn Velixo, we are providing you with these sample templates designed to illustrate usage of Generic Inquiries, pivot tables, and General Ledger functions through Accounts Receivable, and month-end Reconciliation scenarios.

These sample reports demonstrate:

  • Period-Sensitive or dynamic AR/AP Aging Reports, i.e., with the ability to select a period

  • Performing Monthly Reconciliations for AR, AP, and Inventory.

Coverage

These workbooks include the following sample reports:

  • Dynamic AP Aging sample

    • Dynamic AP Aging - detailed

    • Dynamic AP Aging summary


  • Dynamic AR Aging sample

    • Dynamic AR Aging - detailed

    • Dynamic AR Aging summary

  • Monthly reconciliation sample

    • Reconciliation summary

    • AP Aging - detailed

    • AP Retainage - detailed

    • AR Aging - detailed

    • AR Retainage - detailed

    • Inventory - detailed

Example Screens

Reconciliation

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/1HAHEdKFA6zVMqoko5jVwzV72mqFQUrnmw.png

AP Aging - Details

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/rdIVYDlZx6sC1-UOA506jDZ2qMFh13H7jA.png

AR Aging - Details

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/0SjTTXEF8TjazSD6XHmRRbl6edqgi5LNtQ.png

Inventory - Details

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/CywrnX-aHSvqVQnHwD7zzFRP5Pu1b2mm8A.png

AP Retainage - Details

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/E0ieOVBQ4Tf0hVt5NlSOvfptg33hlmoNCw.png

AR Retainage - Details

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/j-0xvwJqkU2VPUf51VWOkFRCydlmQyNpEA.png

Download the sample files

To use the sample reports, you will need to download the Generic Inquiries required by each sample report by clicking the download link for the inquiry and uploading that inquiry into the appropriate tenant of the ERP.


Dynamic AP Aging

Dynamic AR Aging

Monthly Reconciliation


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/K5BS8xllclWLYR5oUjaLtXEGH2KjFwwUvA.png
Download Report
(updated 28-Sept-2023)


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/K5BS8xllclWLYR5oUjaLtXEGH2KjFwwUvA.png
Download Report
(updated 28-Sept-2023)


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/K5BS8xllclWLYR5oUjaLtXEGH2KjFwwUvA.png
Download Report
(updated 29-Dec-2023)


Generic Inquiry required by this
AP sample pack:


Generic Inquiry required by this
AR sample pack:


Generic Inquiries required by this Reconciliation sample pack:


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/K5BS8xllclWLYR5oUjaLtXEGH2KjFwwUvA.png
Download AP Generic Inquiry
(updated 28-Sept-2023)


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/K5BS8xllclWLYR5oUjaLtXEGH2KjFwwUvA.png
Download AR Generic Inquiry
(updated 28-Sept-2023)


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/K5BS8xllclWLYR5oUjaLtXEGH2KjFwwUvA.png
Download ZIP file with all 7 required Generic Inquiries
(updated 8-Jul-2024)

💡

Having trouble downloading the file? Simply right-click the link and select Save link as


For more information about Generic Inquiries, please visit: