Home » Categories » Solutions by Business Process » System Features

History Database Cross-Links

Datafile Software

History Database Cross-Links

The Datafile Premier system allows extra detail databases, termed ‘History’ files, to be viewed off the Sales Ledger, Purchase Ledger, Sales Order and Purchase Order Ledger Enquiry options. These options allow you to link any database that contains the main enquiry index code and list and view records in the enquiry.

New in Release 6.2 is the ability to define application cross-links to other enquiry applications in the same way as, for example, the sales order list of the sales account enquiry allows you to cross-link to the sales order enquiry.Currently these cross-link options are restricted to links to the sales / purchase order enquiry (but not both on the one database) or the stock enquiry but this will be expanded in future releases.

Installation

Ledger Enquiry Manager

To define the history database cross-links you need to set additional parameters within the Ledger Enquiry Manager. To update select Installation from the main menu followed by Ledger Enquiry Manager, Enquiries Configuration, the application required, and then Transaction / Detail Enquiries.Confirm the authority levels for access to the detail databases and then select the history database from the subsequent menu.



Detail File 1st/ 2nd Datafile Link Item
– define the data item on the list database that corresponds to the prime-index of the application you wish to link to.

Applic – select the application you wish to link to. As noted earlier this is currently restricted to the Stock and Sales / Purchase Order Processing applications. Please also note that cannot link to both sales and purchase order enquiries from the one history database, and that the Order History enquiries cannot link to themselves.

Custom Fields
  • Release ID: 6.2
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Additional F4-Select Options
Viewed 3945 times since Wed, Jun 13, 2012
Database Activity Alerts
Viewed 3322 times since Tue, Jun 12, 2012
User Help Notes
Viewed 2444 times since Fri, Jun 8, 2012
Landing Grids
Viewed 2418 times since Mon, Jun 26, 2017
Additional Options for History / Analysis Enquiries
Viewed 2672 times since Fri, Oct 26, 2012
Output User List to Excel
Viewed 4796 times since Fri, Oct 26, 2012
Forecast Dates - Additional Options
Viewed 3256 times since Fri, May 27, 2016
Landing Pages - Company / Key-Item Selection
Viewed 832 times since Tue, Oct 15, 2024
Record Groups as Items in Discount and Supplier Matrix
Viewed 3762 times since Fri, May 27, 2016
Ledger Enquiry – Zoom to Account from Order Enquiry
Viewed 1456 times since Wed, Jun 13, 2012