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

Converting Existing Ledgers - Stock Control - Database Changes

Datafile Software

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Converting Exisiting Ledgers - Order Processing - Database Profiles
Viewed 1239 times since Tue, Jun 26, 2012
Converting Exisiting Ledgers - Stock Control - Screen Design
Viewed 1201 times since Tue, Jun 26, 2012
Converting Existing Ledgers - Sales & Purchase Ledgers - Database Changes
Viewed 1265 times since Tue, Jun 26, 2012
Holding Rates Report
Viewed 1090 times since Tue, Jun 26, 2012
Expand Data Files
Viewed 1153 times since Tue, Jun 26, 2012
Sales Nominal Codes & Purchase Nominal Codes Report
Viewed 1179 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger - Reports
Viewed 1263 times since Tue, Jun 26, 2012
Application Screen Layouts
Viewed 1122 times since Tue, Jun 26, 2012
Application User Facilities - Currency Maintenance
Viewed 1626 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledgers - Allocating Transactions
Viewed 1142 times since Tue, Jun 26, 2012