Multiple Documents on a Single Worksheet

GLSU has the capability to post multiple documents on a single worksheet. This is achieved by the dropped header concept. In short, any number of header fields can be dropped (dragged and dropped in the Add/Delete Columns function) to the line items.

Most header fields can be dragged from the upper-right box to the lower-right box as shown below. You can also select the up/down arrow indicators to move fields between the header and line items.

Each time a dropped header field changes, a new document will be posted. It is important to note that any header field which changes will trigger a new document, whether it is just one dropped header field, or every dropped header field. If a dropped header field is left blank, it will inherit the last non-blank value.

Four documents will be created due the change in the Reference field in this example.

All four documents will have the same Doc. Header Text

When using dropped header functionality, the balance cell in GLSU will no longer display "balanced". Since there are multiple documents on one sheet, this functionality is not feasible in the context of dropped headers. However, pre-validation will still be performed to ensure each individual document balances.

If an out-of-balance situation occurs, a pre-validation message will be issued. If you then double- click the error, GLSU will highlight the range of amounts on the worksheet in which the out-of- balance condition occurs.