Home » Categories » Solutions by Business Process » System Features |
Nominal Enquiry - Links to Sales/Purchase Transactions |
Article Number: 225 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 6:17 PM
|
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 ProfilesThe 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 FacilitiesTo 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. |
Attachments
There are no attachments for this article.
|
Ledger Enquiries - Performance Tuning
Viewed 8001 times since Mon, Feb 4, 2013
Which Price Matrix Entries
Viewed 2019 times since Fri, May 20, 2016
Stock Enquiry - History / Detail Database Options
Viewed 9877 times since Mon, Nov 25, 2013
Image Display on Maintenance Screens
Viewed 2301 times since Wed, Jun 13, 2012
General System Options - Email Address Format Validation
Viewed 109 times since Thu, Oct 17, 2024
Reprint Options when Report to Screen
Viewed 1794 times since Fri, Jun 8, 2012
Default Text as Data Items
Viewed 4011 times since Wed, Jun 13, 2012
General System Options - Copy a User Id
Viewed 102 times since Thu, Oct 17, 2024
Scanned Documents - Save As PDF
Viewed 2377 times since Mon, Jun 11, 2012
Word Wrap in Multi-Line Text Inputs
Viewed 952 times since Thu, Jun 18, 2020
|