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.