Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Extra Features in Purchase Invoice Transaction Lookup

Datafile Software

Extra Features in Purchase Invoice Transaction Lookup

Purchase Ledger invoice entry has a transaction lookup option that allows for linking of a transaction to another database and to copy information from / to that database. In practice this is often used to link to the sales order header database where a purchase invoice specifically relates to a customer order.

This new option allows for the system to read the customer account / invoice reference from the lookup database record and perform a Ledger Enquiry check against this invoice so you can determine if it has been paid.


After confirmation that this is the lookup record required the system then performs the sales account ledger enquiry the customer account / invoice reference recorded on the lookup record.

The usual options, depending on configuration, of VIEW / ANALYSIS / DOCUMENT / ORDER are available to review the sales invoice. Pressing the <ESC> key or the CLOSE button will exit back to the invoice entry to allow you to continue to post the invoice transaction.


Installation

Application User Facilities

The configuration parameters for the transaction lookup are accessed via the Purchase Ledger Application User Facilities. To update select Installation from the main menu followed by Application Manager and then Application User Facilities. Select the Purchase Ledger application followed by Purchase Transactions and proceed to the second page of parameters. As you <Enter> through the parameter ‘Perform Lookup to External File for Validating / Updating’ a pop-up screen will display the configuration parameters if the feature is enabled.


The new parameters to access the Sales Account Ledger Enquiry are:

Check S/L Account Info from I/P File: Account – reference the data item on the lookup record that contains the sales ledger account code.

Ref
– reference the data item on the lookup record that contains the sales ledger invoice reference.

Note

For full details on configuring the transaction lookup please refer to the Sales and Purchase PDF Help manual that can be accessed via the Help pull-down menu on the main Datafile toolbar.

Custom Fields
  • Release ID: 6.2
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
VAT Form 100 - Group VAT Registration
Viewed 3588 times since Tue, Oct 9, 2018
Changes to File Locking on Save Aged Analysis
Viewed 1785 times since Tue, Jun 12, 2012
Set Proposed Payments, Generate Payments Automatically - Purchase Ledger
Viewed 1737 times since Mon, Jul 2, 2012
Show Credit Values as Negative on Sales Statements
Viewed 61 times since Tue, Oct 15, 2024
Add Debtor / Creditor Control Memo from Ledger Enquiry
Viewed 4129 times since Fri, Jun 8, 2012
Unallocating Transactions in Earlier Periods
Viewed 2000 times since Wed, May 29, 2019
Turnover Analysis
Viewed 1691 times since Mon, Jul 2, 2012
Allow Insert of Lines within Order by Status
Viewed 96 times since Thu, Jan 2, 2025
Audit Pointers and Balances
Viewed 1868 times since Mon, Jul 2, 2012
Recalculate Debtor/Creditor Control
Viewed 1821 times since Mon, Jul 2, 2012