Extract BJE Data

 

Note: This update is part of the AMS360 22R1 release. Navigate to the AMS360 2022 R1 Release Notes to review other enhancements and fixes that were part of the release.

In earlier releases, Beginning Balance Journal Entries (BJE) were entered manually. AMS360 now allows the extraction of beginning balance journal entries to a CSV file to efficiently prepare for the mass updating of beginning balance journal entries.

An agency can now import customer BJEs from a CSV file extracted from another agency. This speeds up the process of merging a newly acquired agency while also providing improved accuracy.

In the Financial Center, Actions, there is a new menu item—"Extract BJE Data"—that opens a report form to extract the BJE data from a source AMS360 database into a CSV file, which can be used to import BJE into a destination AMS360 database.

INITIAL SETUP

In the Administration Center, select Security Group Setup in the left-hand menu under General. The user will need to be given Full Access to the secured item:

  • Feature: Financial Center

  • Group: Journal Entry

  • Task: Actions -- Beginning Balance Journal Entry –- Extract BJE Data

ADDITIONAL INFORMATION

BJE Type: The Customer BJE is the only option at this time. Other BJE types may be included in future releases.

Extract Type: Indicates the level of detail for the BJE, where the CSV file will have one row for each of the following elements:

  • Customer

  • Policy

  • Invoice

End Date: The Balance will be calculated as of the date selected.

Policy Selections: These filters will apply only when the Extract Type is "Policy" or "Invoice."

The CSV file can be imported by clicking on the "Import BJE Collection" button in the Financial Center > Views menu > Beginning Balance Journal Entry Collections.

 

© 2024 Vertafore