New items are required on both the order header and detail 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.
Item Name Type Description / Update From
FC-CODE X (3) Holds the currency code for the order. Update with the base currency.
FC-RATE M Holds the exchange rate for the order. Update with 1.0000
FC-FIXED ? Identifies whether the order was entered with a fixed exchange rate (i.e. excluded from revaluation).
FC-ORD-VAL L Holds the value of the order in the currency of the account.Update from ORDER-VALUE.
FC-INV-VAL L Holds the value of invoices against this order, exclusive of VAT, in the currency of the account. Update from INVOICE-VALUE.
FC-INV-INCVAT L Optional. Holds the value of invoices against this order inclusive of VAT. Update from INV-INC-VAT.
FC-ORIG-RATE M Optional. Holds the original rate of the order before revaluation. Update with 1.0000
Item Name Type Description / Update From
FC-CODE X (3) Holds the currency code for the order. Update with the base currency.
FC-RATE M Holds the exchange rate for the order. Update with 1.0000
FC-PRICE L, M Holds the unit price of the stock item in the currency of the account.Update from existing PRICE field (SOP) or COST field (POP).
FC-ORD-VAL L Holds the value of the order in the currency of the account.Update from DETAIL-VALUE.
FC-INV-VAL L Holds the value of invoices against this order, exclusive of VAT, in the currency of the account. Update from INVOICE-VALUE.
FC-INV-INCVAT L Optional. Holds the value of invoices against this order inclusive of VAT. Update from INV-INC-VAT.
FC-ORIG-RATE M Optional. Holds the original rate of the order before revaluation. Update with 1.0000
Article ID: 909
Created On: Tue, Jun 26, 2012 at 11:54 AM
Last Updated On: Mon, Jun 12, 2023 at 7:57 PM
Online URL: https://kb.datafile.co.uk/article/converting-existing-ledgers-order-processing-database-changes-909.html