Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Multiple Updating – Input from CSV File - Nominal

Datafile Software

Multiple Updating – Input from CSV File - Nominal

The definition for the update from CSV is largely the same as that from an external database except that the data items you specify are the entries in the CSV file – i.e. ‘ITEM-1, ITEM-2, ITEM-3, etc.’

Instead of the selection criteria and flag options, however, are options to delete the input file and to import new accounts as well.

Opt. CSV to check accounts (Code, Name)

Here you can enter a separate CSV file to use for importing account records, the CSV file containing two items - the account code followed by the account name. If the file is present the codes are first checked against the current nominal ledger and any new codes added before the journal is imported.

Delete Files after Posting

Set this option to delete the input file after posting – you cannot flag a CSV record as updated so deleting the file prevents duplicate posting.

Note

You cannot use the same multiple update definition to bring in transactions from both a CSV file and an ‘external’ DFD database – you must create separate definitions for them.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
FULL – Maintain Accounts in Full - Nominal
Viewed 1170 times since Wed, Jun 27, 2012
Receipt and Payment Entry - <F7-Balance> Option
Viewed 1214 times since Wed, Jun 13, 2012
Ledger Enquiry Manager - Cashbook
Viewed 1204 times since Thu, Jun 28, 2012
ENTER – Enter Current Budget Year Totals - Nominal
Viewed 875 times since Wed, Jun 27, 2012
Additional Options for Bank Reconciliation
Viewed 1172 times since Tue, Jun 12, 2012
VAT Adjustments - Post-Dated Purchase Invoices
Viewed 3380 times since Thu, Oct 11, 2018
Receipt Column Headings - Cashbook
Viewed 1646 times since Wed, Jun 27, 2012
Database Profiles - Cashbook
Viewed 1175 times since Thu, Jun 28, 2012
Account Currency - 3 - Nominal - Database Profiles
Viewed 1169 times since Thu, Jun 28, 2012
Maintain Accounts - Cashbook
Viewed 1417 times since Wed, Jun 27, 2012