Solved

Where to get status history of invoice or payment?

  • 17 October 2023
  • 4 replies
  • 103 views

Is there a screen where I can see the status change history for invoices and payments? For example if I want to see on which day a payment was moved from Open to Closed status where can I see that?

 

Would eventually like to access this through one of the API endpoints as well.

icon

Best answer by Laura02 17 October 2023, 01:42

View original

4 replies

Userlevel 4
Badge +2

One way to see what has changed is to look at the Audit History.  More details can be explained here: https://asiablog.acumatica.com/2015/10/select-audit-data-from-database.html

Badge +18

Hello @definitesteve ,

By Default, With no Field-Level Audit turned on, we can see  two facts about all records: 

  1. Who CREATED a record/when, and
  2. Who last MODIFIED a record/when.

Acumatica also comes with several security audits in place:

  • User Login
  • User Login Failed
  • User Logout
  • User / Screen accessed
  • User Session Expired
  • Emails Sent Success
  • Email Sent Failed

In addition to Kulvir’s suggestion above, I am providing more information about Audits.

In order to use Field-Level Audit, the feature must first be enabled in  Enable/Disable Features screen.

After Field-Level Audit feature is enabled, Audit screens appear in User Security → Preferences → Audit. After Audits are configured for each transaction/document screen where you want to track document Status, the system will begin to accumulate the Status Dates you are seeking. (Dates will be tracked only from the date the new Audits are configured, forward… not for historical documents that posted before Audits were configured.) 

Recommended items to audit:

  1. AP
    1. Vendor remit address changes & deletions
    2. Addition of new vendors
    3. Changes to the Accounts Payable preferences Screen
  1. Payroll
    1. Employee salary and hourly pay rates
    2. Employee direct deposit account settings
    3. Paychecks and Adjustments (form did not allow audit 9/2/20 LB)
    4. PTO Banks
  1. Banking
    1. Addition of bank accounts
  1.   General Ledger
    1. Additions of new Accounts  user and date stamped
    2. Additions of Subaccounts user and date stamped
    3. Changes to the GL preferences Screen
  1. System Settings
    1. Additions or changes to Users
    2. Additions or changes to Roles
    3. Review of Security Preferences any changes User and date stamped

Laura

Userlevel 7
Badge +9

Hi @definitesteve Answer 1: Please enable detailed Audit on the required screen → field. In this case, for enable Audit for the “Invoices” screen 

  1. Open the Invoices screen
  2. Tools->Click Audit History

(Note: if this is for Invoice  and memo, follow the same steps for that screen).

  1. Enable Field Level Audit
  2. Select the field required for audit, as shown below

 

  1. Save the Configurations, Now the Audit is enabled for the Invoices screen→ Status field. Going forward, any changes to the status will be tracked.

    1. Testing the audit:
       Create a invoice and release. The status will change from Balanced to Open.
    2. Click on the Audit History on the Invoices screen 
  1. As shown below, the audit will be shown:

 

Userlevel 7
Badge +9

Hi @definitesteve In order use an API, please try to create a Generic Inquiry for the required data and check the “UI” checkbox to get a screenid for the Inquiry. And then make an API call to this new Generic Inquiry

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved