Converting Existing Ledgers - Stock Control - Database Changes

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.

Stock File

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.

Transactions File

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.