Transaction / Detail Enquiries

This option gives you the ability to configure the display of the transaction enquiries available for each customer or supplier record. On selection of this option, you are able to set the authority levels for access to each transaction enquiry.

Transaction Details

LIFO

Set to display transactions in LIFO – last in first out – order. If set then you should ensure that the transaction data item ACCOUNT is a secondary index.

DATE

Transactions are usually displayed based on the order they were entered, setting this option sorts the details into date order – either FIFO or LIFO based on setting of the prompt above.

List Items

Here you can select up to eight items to be displayed when selecting the transaction options from the Sales/Purchase Ledger Enquiry.

Premier users have an additional configuration option for transaction display, after confirming the last of the list items.

Full Screen Layout for ‘Transactions’ Enquiry

If Premier, you are given the option to design a full-screen enquiry display, for the transaction record. If you elect to use the full-screen enquiry then you are taken into the screen design.

You design the screen as per the standard design parameters.

To add text to the screen you use the mouse or arrow keys to position the cursor at the start of where you wish to enter your text, and type in the required label(s). To clear any text, use the space bar.

To add a data item to the screen, you use the mouse or arrow keys to position the cursor at the start of where you wish the item to display, and then either ‘right-click’ with the mouse or press <F4-Select>. The list of available data items are displayed for you to select. To delete a data item from the screen, use the mouse to click the item and then hit the <DELETE> key.

To draw borders around the screen, choose the option ‘Border’ on the Tools pull-down at the top of the screen.

To draw a line on the screen, select the option ‘Line Mode’ on the Tools pull-down, and then use the mouse to click the start position of the line and then drag the line (horizontally or vertically) to the end position of the line. To delete a line, use the mouse to select the line, (it will turn blue when selected), and then hit the <DELETE> key. Once the line(s) has been drawn switch back to text mode by using the option on the Tools pull-down.

Once complete choose the File pull-down option ‘Save & Exit’. On save of the screen, you will be asked if you wish to use a second screen – respond as required.

Transaction Analysis

The Transaction Analysis display items are shown when you select the ANALYSIS option, on any invoice or credit transaction displayed in the transaction features, showing the analysis breakdown of the invoice.

List Items

Here you can select up to eight items to be displayed, when selecting the analysis button from the Sales/Purchase Ledger Enquiry.

Premier users have an additional configuration option for transaction display after confirming the last of the list items.

Full Screen Layout for ‘Transactions’ Enquiry

If Premier, you are given the option to design a full-screen enquiry display, for the transaction record. If you elect to use the full-screen enquiry then you are taken into the screen design.

Order Header

LIFO

Set to display orders in LIFO – last in first out – order. If set then you should ensure that the order header data item for the ACCOUNT is a secondary index.

DATE

Orders are usually displayed based on the order they were entered, setting this option sorts the details into date order – either FIFO or LIFO based on setting of the prompt above.

List Items

Here you can select up to eight items to be displayed, when selecting the SALES ORD (or PURCH ORD) option from the Sales/Purchase Ledger Enquiry.

Premier users have an additional two configuration options for order display.

Default Status of Orders to Show (Blank=All)

Typically all orders are listed but you may want to restrict those displayed to (say) active orders by entering ‘A’. Additional codes are C-Complete, D-Deleted, F-Forward, H-Hold and Q-Quote.

Full Screen Layout for ‘Order Header’ Enquiry

If Premier, you are given the option to design a full-screen enquiry display for the order.

Order Details

The sales/purchase order details are displayed via a DETAILS button on the order enquiry.

List Items

Here you can select up to eight items to be displayed when selecting the details button from the Sales/Purchase Ledger Enquiry.

Premier users have an additional configuration option for transaction display after confirming the last of the list items.

Full Screen Layout for ‘Order Details’ Enquiry

If Premier, you are given the option to design a full-screen enquiry display for the order detail record. If you elect to use the full-screen enquiry then you are taken into the screen design.

Sales/Purchase History (Premier only)

The history option allows you to link to any database that contains the customer/supplier account code.You could use this to link to (say) a ProFiler contacts database, or to the Invoice Costing details – the file pathname to link to is entered as part of the location of files. Within the Ledger Enquiry configuration you are first asked to define the relationship between the accounts file and the history file.

 Account file item for first pointer (optional)

If the history file is a detail file off the accounts file, then there will be a pointer relationship between the two files. This option asks for the account data item that holds the record number of the first history file record that relates to this account, <F4-Select> is available.If the accounts file is only referenced as a lookup, on the history file and no pointer relationship exists, then leave this value as 0.

If you wish to display the details in LIFO order, then select the data item that contains the record number of the last history record that relates to this account.

Detail file item for account code (mandatory)

Enter the data item number, <F4-Select> is available, of the history file item that contains the customer/supplier account code.

Detail file item for next detail (optional)

Only applicable if the history file is a detail of the accounts file, here you enter the data item number on the history file that contains the record number of the next history record for the customer/supplier.

If displaying the details in LIFO order, then select the data item that contains the record number of the previous history record for the customer/supplier.

LIFO

If not using the pointer items, then set this option to display history records in LIFO – last in first out – order. If set, then you should ensure that the history data item for the ACCOUNT is a secondary index. If using the pointer chain, then this option should not be set, you can still display in LIFO by selecting the pointer fields as discussed above.

List Items

Here you can select up to eight items to be displayed when selecting the history button from the Sales/Purchase Ledger Enquiry.

Full Screen Layout for ‘History’ Enquiry

You are given the option to design a full-screen enquiry display for the history record. If you elect to use the full-screen enquiry then you are taken into the screen design.

Sales/Purchase Desktop Details (Premier only)

The desktop details option allows you to link to a second database that contains the customer/supplier account code. You could use this to link to (say) a ProFiler contacts database or to the Invoice Costing details – the file pathname to link to is entered as part of the location of files. Within the Ledger Enquiry configuration you are first asked to define the relationship between the accounts file and the details file.

Account file item for first pointer (optional)

If the detail file is an actual detail file off the accounts file, then there will be a pointer relationship between the two files. This option asks for the account data item that holds the record number of the first detail file record that relates to this account, <F4-Select> is available.If the accounts file is only referenced as a lookup on the detail file, and no pointer relationship exists then leave this value as 0.

If you wish to display the details in LIFO order then select the data item that contains the record number of the last detail record that relates to this account.

Detail file item for account code (mandatory)

Enter the data item number, <F4-Select> is available, of the detail file item that contains the customer/supplier account code.

Detail file item for next detail (optional)

Only applicable if the detail file is an actual detail of the accounts file, here you enter the data item number on the detail file that contains the record number of the next detail record for the customer/supplier.

If displaying the details in LIFO order then select the data item that contains the record number of the previous detail record for the customer/supplier.

LIFO

If not using the pointer items then set this option to display detail records in LIFO – last in first out – order. If set then you should ensure that the detail data item for the ACCOUNT is a secondary index.If using the pointer chain then this option should not be set, you can still display in LIFO by selecting the pointer fields as discussed above.

List Items

Here you can select up to eight items to be displayed when selecting the details button from the Sales/Purchase Ledger Enquiry

Full Screen Layout for ‘Details’ Enquiry

You are given the option to design a full-screen enquiry display for the detail record. If you elect to use the full-screen enquiry then you are taken into the screen design.