Multiple Updating - Update From Any Datafile Database File - Nominal


Datafile Software

Multiple Updating - Update From Any Datafile Database File - Nominal

This option allows you to define how to update from any Datafile database file. You can create some very powerful system links outside the standard ledger and payroll links with this feature. In use the update procedure creates a double entry nominal ledger transaction for each incoming transaction — it is written with both debit and credit nominal codes.

The definition is very straightforward to complete in the screen shown below, and is in two parts consisting of:

The input accounting items for debit and credit amounts, value, and other items

The data items to be copied between transactions for reference and analysis

Input Accounting Items


DB account

or code:

CR account

or code:

Enter here the data items on the input file for both the debit and credit accounts. In case the input file data item for either of these is blank, you must also give the nominal ledger code to which the value is to be posted instead. If you leave either the debit or credit account input items blank then the or code would usually be a control account, if you specify both the debit and credit account input items then the orcode would usually be the suspense account.

Journal Source Code

Enter here the identify code of the journal – i.e. JNL if importing journals. You can view the codes you have defined in the nominal system profiles. If your input file contains a source code item, as you are importing from another nominal transaction file, then leave this blank and define an input copy item for it instead.

Amount

This is the data item which holds the value for this transaction. It can be an L-, K- or *-type data item in the input file.

The transaction amount is expected to be positive. If there is a negative amount, then it is written into the nominal transaction file as a positive amount with the debit and credit codes reversed.

Flag as being updated

It is good practice to include in the input file a flag which the update procedure can set to Y as it updates each transaction. This prevents the possibility that this record can be accidentally updated again at some future time. Give here the data item number for this flag (which must be a ?-type item).

Description

This is the data item in the incoming file which holds the description to copy into the nominal ledger transaction description field. It is an optional item.

Date (else run date)

You would normally give the data item number of the input transaction date here. If you do not give the data item number of a date field in the input file, then the run date is used as the date of the nominal transaction.Note that you cannot import transactions across periods – the period number you run the import at is the period updated regardless of the date on the transactions.

Post as Provisional?

You have the option to post all the transactions which are input by this routine as provisional transactions – set as required.

 

Tip

The only thing which distinguishes a provisional from a regular transaction is that the flag is set to Y. If you have your own application whose data you wish to update into the nominal, and some of which could be marked as provisional, then put a Y in an appropriate field in your file and use the copy item feature below to transfer this flag to the provisional flag in the nominal transaction.

Use DB selection criteria?

In many cases you may want to update only certain records from the input file. Set this option, and not only can you specify some selection criteria at run time but you can set up a proforma selection criteria screen following the input copy items procedure which comes next (see below).

Input Copy Items
 

You may specify up to 10 items which you want copied from the input file into the nominal transaction file. Do not include those already mentioned on the left of the screen, since the program knows where to put them. Enter the item number in the left-hand column for each item in your external file which you want copied, and the item number in the right-hand column for the nominal transaction file data item where you want it to go.

At any time during the completion of this screen you can <Escape> to be asked ‘Are the above details OK?’ - reply ‘No’ to return to the start of the screen, or ‘Yes’ if the details are correct. If you had requested selection criteria, then you can complete a proforma selection criteria screen (see the System User Guide for more information on selection criteria) otherwise you are returned to the User Facilities menu.


Custom Fields

Article ID: 1121
Created On: Thu, Jun 28, 2012 at 10:09 AM
Last Updated On: Mon, Jun 19, 2023 at 6:40 PM

Online URL: https://kb.datafile.co.uk/article/multiple-updating-update-from-any-datafile-database-file-nominal-1121.html