Nominal Enquiry - Links to Sales/Purchase Transactions


Datafile Software

Nominal Enquiry - Links to Sales/Purchase Transactions

This new feature allows the Nominal Enquiry to drill back to the sales and purchase transactions that were processed to create the nominal transaction. Cashbook users can also link from the receipt or payment to the sales / purchase transactions that were generated at the same point.


As you scroll up/down the nominal transactions the ‘SL/PL TRANS’ button will be enabled for appropriate transactions.Selecting this option will swap the enquiry to the sales/purchase account enquiry highlighting the appropriate transaction.


The link auto-performs a transaction enquiry for the account with filters set for retained transactions and a reference range equal to that recorded on the nominal transaction. Note that the enquiry links to the main transaction that appears on the customer statement or supplier remittance rather than the analysis lines.

From the main transaction you can see further detail on the transaction via the VIEW button (Premier only), display the invoice or credit document (where appropriate) or list the analysis transactions which were the actual source of the nominal transaction. <ESC> or the CLOSE button on the transaction enquiry takes you back to the nominal enquiry.

Installation

There are no specific configuration settings to enable the option to drill-back from the nominal transactions to the sales / purchase transactions when updating for a single application company.However, this option does rely on the nominal update definition being configured for full updating where each sales / purchase analysis transaction will create a separate nominal transaction. This is achieved through parameters in the Nominal System Profiles for Compactand Professional users and the Nominal Application User Facilities for Diamondand Premier Users. You also need to ensure that the sales/purchase transaction reference is copied as the nominal reference and that the sales/purchase account is copied as the nominal ‘memo-account’.

The key settings for the nominal drill-back option are:

 If transaction source equals ‘S/L’, the memo-account value matches the sales ledger account code format, and the reference is not blank.

If transaction source equals ‘P/L’, the memo-account value matches the purchase ledger account code format, and the reference is not blank.

If transaction source equals ‘CBR’ and the cashbook column setting links to the sales ledger then will allow drill-back where memo-account value matches the sales ledger account code format and the reference is not blank.

If transaction source equals ‘CBR’ and the cashbook column setting links to the purchase ledger then will allow drill-back where memo-account value matches the purchase ledger account code format and the reference is not blank.

If transaction source equals ‘CBP’ and the cashbook column setting links to the sales ledger then will allow drill-back where memo-account value matches the sales ledger account code format and the reference is not blank.

If transaction source equals ‘CBP’ and the cashbook column setting links to the purchase ledger then will allow drill-back where memo-account value matches the purchase ledger account code format and the reference is not blank.

 Note

 Cashbook receipts can be configured to allow update of both the sales and purchase ledgers (as can the Cashbook payments) – posting a receipt to a purchase account would create a payment adjustment transaction on the purchase ledger (a refund cheque from a supplier).

Database Restructure

If the nominal ledger is updated from the sales and purchase ledgers of more than one Application Company then for the drill-back procedure you need to record the ‘source’ company id on the nominal transaction file. If required you need to create a ‘company-id’ field on both the sales/purchase transaction file and the nominal transaction file.

File Item Type Description

SLT/PLT !=CCC X (3) Creates a data item containing as a default value of text after the ‘!=’.Replace the ‘CCC’ with the appropriate company-id.

NLT COMP-ID X (3) Holds the source company id of the nominal transaction. If blank assumes current company.

Database Profiles

The item on the Nominal Ledger Transaction file needs to be referenced within the Database Profiles. Parameter screen ‘Trans Optional 1’ parameter screen asks for the ‘Orig-Comp-Id’.

Application User Facilities

To update the ‘Orig-Comp-Id’ item on the nominal ledger transaction file you need to set a copy item within the nominal update definition to copy the company code from the sales/purchase transaction file.


Custom Fields

Article ID: 225
Created On: Tue, Jun 12, 2012 at 1:59 PM
Last Updated On: Tue, Jun 20, 2023 at 6:17 PM

Online URL: https://kb.datafile.co.uk/article/nominal-enquiry-links-to-sales-purchase-transactions-225.html