Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook |
Multiple Updating – Input from CSV File - Nominal |
Article Number: 1122 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 6:40 PM
|
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. 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. 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. |
Attachments
There are no attachments for this article.
|
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
|