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.
Blanking the authority level disables that particular transaction enquiry option, otherwise set as appropriate (remember values are from 0-9 where 0 is the highest and 9 is the lowest authority level). After setting the appropriate levels you can then configure the display items for these option.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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
If Premier, you are given the option to design a full-screen enquiry display for the order.
The sales/purchase order details are displayed via a DETAILS button on the order enquiry.
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.
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.
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.
Enter the data item number, <F4-Select> is available, of the history file item that contains the customer/supplier account code.
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.
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.
Here you can select up to eight items to be displayed when selecting the history button from the Sales/Purchase Ledger 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.
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.
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.
Enter the data item number, <F4-Select> is available, of the detail file item that contains the customer/supplier account code.
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.
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.
Here you can select up to eight items to be displayed when selecting the details button from the Sales/Purchase Ledger 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.
Article ID: 1353
Created On: Mon, Jul 2, 2012 at 2:24 PM
Last Updated On: Mon, Jun 19, 2023 at 3:42 PM
Online URL: https://kb.datafile.co.uk/article/transaction-detail-enquiries-1353.html