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.
|
Bar Code Printing
Viewed 760 times since Mon, Jan 6, 2020
Additional Options for History / Analysis Enquiries
Viewed 1628 times since Fri, Oct 26, 2012
Ledger Enquiry – Improved Scans Option
Viewed 1018 times since Wed, Jun 13, 2012
Windows 10 1803 Update / Windows Defender
Viewed 2116 times since Wed, May 30, 2018
Filter Records on Enquiry Search
Viewed 4744 times since Fri, Oct 26, 2012
F8-Zoom - Allow Other Searches and Enquiries
Viewed 3847 times since Fri, Jun 8, 2012
F4-Search - Default Item
Viewed 1788 times since Fri, Jun 8, 2012
Output User List to Excel
Viewed 4187 times since Fri, Oct 26, 2012
Application Utilities Panel - Allow Scans Enquiry
Viewed 1755 times since Fri, Jun 8, 2012
Application Memo Options
Viewed 1655 times since Tue, Jun 12, 2012
|