Duplicate Entry Consolidation

GLSU can be configured to consolidate duplicate spreadsheet records for simplicity, faster processing, and reduction of document size. To configure this option, select the Options ribbon button, go to the Consolidation tab and confirm the option is checked.

A manual Validate action will cause the consolidation to occur if the option is active and valid duplicates are found. Please note a Validate Before Post/Export option under General in Options will not cause consolidation to occur. GLSU will create a new sheet with the consolidated data. Dropped header fields will still inherit their up-spreadsheet values (a blank dropped header field will be summarized with the last populated value in the sheet for consolidation purposes). Blank fields in the line items will be treated as a separate, distinct, and unique value and given their own consolidated line item. All currency/quantity fields are summed together.

The newly created sheet is in the GLSU format and may be used for posting/parking.

Below is a consolidation example:

Source -