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
PREV-YR-PER – Previous Year Period Budgets
Viewed 854 times since Wed, Jun 27, 2012
System Status - Nominal - Application User Facilities
Viewed 1228 times since Thu, Jun 28, 2012
Receipt Totals Analysis, Payment Totals Analysis
Viewed 1441 times since Wed, Jun 27, 2012
Journal Cleardown - Cashbook
Viewed 1167 times since Wed, Jun 27, 2012
PREV-YR-TOT – Previous Year-1 Comparative Totals, PREV-YR-PER – Previous Year-1 Period Comparatives - Nominal
Viewed 882 times since Wed, Jun 27, 2012
MASTER – Maintain Header Accounts - Nominal
Viewed 1298 times since Wed, Jun 27, 2012
Transaction Currency - Nominal - Database Profiles
Viewed 1221 times since Thu, Jun 28, 2012
Multiple Updating – General Details / Which Systems Allowed - Nominal
Viewed 871 times since Thu, Jun 28, 2012
Record Journal Number on Sales / Purchase Transactions
Viewed 1469 times since Tue, Jun 12, 2012
Mandatory Transaction Items - Nominal - Database Profiles
Viewed 1259 times since Thu, Jun 28, 2012