Home » Categories » Solutions by Business Process » Finance » Currency |
Converting Existing Ledgers - Nominal & Cashbook - Database Changes |
Article Number: 902 | Rating: Unrated | Last Updated: Mon, Jun 12, 2023 at 7:59 PM
|
Datafile Software Converting Existing Ledgers - Nominal & Cashbook - Database Changes New items are required on both the accounts and transaction files. In addition it has to be assumed that all existing accounts and transactions are held in the base currency and these additional currency fields need to be updated from the existing (base currency) equivalent using the DataFiler Global Update procedures. Accounts FileItem Name Type Description / Update From FC-CODE X (3) Contains the currency code of the account. Update with base currency code (STG / GBP etc.) F-CURR-ST-YR L Contains the opening balance for the year in the currency of the account. Update from CURR-ST-YEAR. F-CURR-01 to F-CURR-13 L A series of 13 fields containing the movement for period 1 through 13. Update from CURR-ACT-01 or equivalent. F-CURR-BAL L Contains the closing balance for the year in the currency of the account. Update from CURR-BALANCE. DATE-REVALUE D/E Will hold the last date of revaluation. F-PREV-ST-YR L Contains the opening balance for last year in the currency of the account. Update from PREV-ST-YEAR. F-PREV-01 to F-PREV-13 L A series of 13 fields containing the movement for periods 1 through 13 of the last year. Update from PREV-ACT-01 or equivalent. F-PREV-BALANCE L Contains the closing balance of the account for the last year. Update from PREV-BALANCE. F-PREV1-ST-YR L Contains the opening balance for the year before last in the currency of the account. Update from PREV1-ST-YEAR F-PREV1-01 to F-PREV1-13 L A series of 13 fields containing the movement for periods 1 to 13 in the year before last. Update from PREV1-ACT-01 or equivalent. F-PREV1-BAL L Holds the closing balance for the year before last in the currency of the account.Update from PREV1-BALANCE Transactions FileItem Name Type Description / Update From FC-CODE X (3) Holds the currency code of the transaction. Update with base currency (STG / GBP etc.) FC-RATE M Holds the exchange rate of the transaction. Update with 1.0000 FC-AMOUNT L Holds the amount of the transaction in the appropriate currency.Update from existing AMOUNT field. FC-NET L Holds the amount exclusive of tax in the appropriate currency.Update from existing CASH-NET field. FC-TAX L Holds the tax amount on the transaction in the appropriate currency.Update from existing CASH-TAX field. |
Attachments
![]() There are no attachments for this article.
|
Application Differences - Nominal Ledger - Year-End Procedures
Viewed 1152 times since Tue, Jun 26, 2012
Application Differences - Cashbook - Bank Statements
Viewed 1129 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger Revaluations - Revalue All Nominal Accounts
Viewed 1188 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledgers - Entering Invoices, Credits and Adjustments
Viewed 1116 times since Mon, Jun 25, 2012
Ledger Enquiry Manager
Viewed 1237 times since Tue, Jun 26, 2012
Stock Control
Viewed 1185 times since Tue, Jun 26, 2012
Application User Facilities - Reports
Viewed 1089 times since Tue, Jun 26, 2012
Application Differences - Cashbook - Cashbook Transactions
Viewed 1280 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledger Revaluations - Holding Rate Revaluation
Viewed 1244 times since Tue, Jun 26, 2012
Spot Rate Changes
Viewed 1111 times since Tue, Jun 26, 2012
|