New items are required on the transaction file and optional items can be added to the stock file. In addition it has to be assumed that all existing 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) If recording a currency cost against the stock code you need to enter the currency code that the cost is in.
FC-COST L, M Field for holding the currency cost. These two options apply for Purchase Order Processing – if an order detail is entered for a supplier whose currency matches that of the stock code then the FC-COST field is used instead of the standard cost field.
Item Name Type Description / Update From
FC-CODE X (3) Holds the currency code of the customer/supplier. Update with base currency (STG / GBP etc.)
FC-RATE M Holds the exchange rate of the transaction. Update with 1.0000
FC-COST/PRICE L, M Holds the cost price for type 2, 3, 4, 5, 7, 8 and 9 transactions. Holds the selling price for type 1 and 6. Update from existing cost or selling price accordingly.
Article ID: 906
Created On: Tue, Jun 26, 2012 at 11:50 AM
Last Updated On: Mon, Jun 12, 2023 at 7:58 PM
Online URL: https://kb.datafile.co.uk/article/converting-existing-ledgers-stock-control-database-changes-906.html