Home » Categories » Solutions by Business Process » Finance » Currency

Converting Existing Ledgers - Sales & Purchase Ledgers - Database Changes

Datafile Software

Converting Existing Ledgers - Sales & Purchase Ledgers - 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 File

Item Name Type Description / Update From

FC-CODE X (3) Holds the currency code for the account. Global Update with base-currency code (STG / GBP etc.)

FC-BAL-B/F L Holds the balance brought-forward at the start of the period in the currency of the account. Globally Update from existing balance-b/f field.

FC-BALANCE L Holds the current balance in the currency of the account. Globally update from existing balance field.

FC-UNALLOC L Holds the total of unallocated payments and credits on the account. Update from existing unallocated field.

FC-OPEN-YR L Holds the opening balance for the year on non-open item accounts.Globally update from existing open-year-balance field.

FC-FWD-BAL L Holds the balance of the forward period transactions on the account.Update from existing forward balance field.

FC-FWD-UNALL L Holds the total of unallocated forward period payments and credits on the account. Update from existing forward unallocated field.

FC-FWD-T/O L Holds the turnover from forward period transactions against the account. Update from existing forward turnover field.

FC-T/O-YEAR L Holds the turnover for the year so far. Update from existing turnover-year field.

FC-T/O-PERD L Holds the turnover for the period so far.Update from existing turnover-per field.

FC-T/O-1 L Holds the turnover for period 1. Update from existing turnover-period-1 field.

FC-T/O-2 L Turnover for period 2.

FC-T/O-3 L Turnover for period 3.

FC-T/O-4 L Turnover for period 4.

FC-T/O-5 L Turnover for period 5.

FC-T/O-6 L Turnover for period 6.

FC-T/O-7 L Turnover for period 7.

FC-T/O-8 L Turnover for period 8.

FC-T/O-9 L Turnover for period 9.

FC-T/O-10 L Turnover for period 10.

FC-T/O-11 L Turnover for period 11.

FC-T/O-12 L Turnover for period 12.

FC-T/O-13 L Turnover for period 13.

FC-T/O-LYR L Turnover for last year. Update from existing turnover for last year field.

Transactions File

Item Name Type Description / Update From

FC-CODE X (3) Holds the currency code of the transaction. Globally update with currency code of base currency (STG / GBP etc.)

FC-RATE-ORIG M Holds the exchange rate of the transaction before revaluation. Update with 1.0000

FC-RATE-NOW M Holds the current exchange rate of the transaction.Update with 1.0000

FC-FIXED ? Flag to identify exchange rate as being fixed (unavailable for revaluation).

FC-AMOUNT L Holds the amount of the transaction in the currency of the account.Update from existing AMOUNT field.

FC-TAX-AMNT L Holds the tax-amount of the transaction in the currency of the account. Update from existing TAX-AMT field.

FC-PAY-DISC L Holds the payment discount of the transaction in the currency of the account. Update from existing PAY-DISC field.

FC-TOTAL * Calculation of FC-AMOUNT plus FC-TAX-AMNT plus FC-PAY-DISC.

FC-ALLOC L Holds the allocated amount of the transaction in the currency of the account. Update from existing ALLOCATED field.

FC-O/S * Calculation of FC-TOTAL less FC-ALLOC

FC-FWDALLOC L Holds the amount of the transaction allocated against a forward transaction in the currency of the account. Update from existing FWD-ALLOC field.

FC-LASTALLOC L P/L only. Holds the amount allocated last against the transaction in the currency of the account. Update from existing LAST-ALLOC field.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Edit System Status Display
Viewed 941 times since Tue, Jun 26, 2012
System Profiles
Viewed 922 times since Tue, Jun 26, 2012
Application Differences - Cashbook - Bank Statements
Viewed 902 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledger Revaluations - Holding Rate Revaluation
Viewed 1007 times since Tue, Jun 26, 2012
Clear Old Rates
Viewed 837 times since Tue, Jun 26, 2012
Database Structures
Viewed 827 times since Tue, Jun 26, 2012
Spot Rate Changes
Viewed 854 times since Tue, Jun 26, 2012
Document Design Manager
Viewed 852 times since Tue, Jun 26, 2012
Cashbook
Viewed 870 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledgers - Reporting Differences
Viewed 864 times since Tue, Jun 26, 2012