Home » Categories » Solutions by Business Process » System Features |
Ledger Enquiry - Alternate Link Item for History Databases |
Article Number: 2283 | Rating: Unrated | Last Updated: Wed, Oct 23, 2024 at 11:20 AM
|
The History databases on the Ledger Enquiry match based on the primary enquiry index – to link to a history database on the sales enquiry you need a data item holding the sales account code, the stock enquiry on the stock code and so on. New in this release you can nominate another item on the main application file instead of the prime index to use when selecting the history records for display. As an example, the Sales Ledger enquiry would usually list history records specifically for that sales account. If using Delivery Accounts or Group Accounts however you may want to list all history records for the group and not just those for the specific account. If you reference the ‘group account’ item as an alternative link item, the system will then display the history records that match the group account rather than specific account used in the enquiry. Similarly, on Stock if using location stock, you may wish to see history records for all stock items regardless of location. Referencing a sub-item that removes the location prefix would allow this. ![]() InstallationLedger Enquiry ManagerTo define the link items on the enquiry, select from the main menu, Installation followed by Ledger Enquiry Manager and Enquires Configuration. Select the application required followed by Transaction / Detail Enquiries. Confirm the authority levels are set then click NEXT to configure the transaction enquiries, selecting the required history database. ![]() Detail File Item for Master Code – this option asks for the data item on the history file that contains the match item (for example on a sales history database the item that contains the sales account code, on a stock history database would be the stock code and so on). This option is mandatory and, if no pointer chain in use, this item must be defined on the database as a secondary index. Alternate Link Item – this new item enables you to reference an alternate item on the master file to match the history file records to instead of the primary enquiry index. For example, on the stock enquiry above the detail item for master code and the alternate link item both reference sub-items off the stock code to strip off the location to leave the SKU. |
Attachments
![]() There are no attachments for this article.
|
Ledger Enquiry - Application Panels – Allow Up to Ten Items / Faster Display
Viewed 55 times since Tue, Oct 15, 2024
User-Definable Ledger Enquiry Applications
Viewed 21916 times since Tue, Jun 12, 2012
Landing Pages - Expand and Collapse All Groups
Viewed 231 times since Thu, Oct 17, 2024
Record Groups as Items in Discount and Supplier Matrix
Viewed 2699 times since Fri, May 27, 2016
Document Design Manager - The Document Design Toolbar
Viewed 2496 times since Wed, Jun 13, 2012
Ledger Enquiry – New Label Print Option
Viewed 1366 times since Wed, Jun 13, 2012
Warehouse Tablet - Sales Order Pick Note Image Capture
Viewed 291 times since Thu, Oct 24, 2024
Document Design Manager - Save and Exit
Viewed 3703 times since Wed, Jun 13, 2012
Default Transaction Filters
Viewed 2067 times since Tue, Jun 12, 2012
General System Options - Increased No of Saved Selection Criteria
Viewed 238 times since Thu, Oct 17, 2024
|