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
Compact & Audit Database
Viewed 854 times since Tue, Jun 26, 2012
System Status
Viewed 856 times since Tue, Jun 26, 2012
Invoicer, SOP and POP Applications
Viewed 961 times since Tue, Jun 26, 2012
Application Differences - Cashbook - Bank Statements
Viewed 894 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger - Reports
Viewed 1003 times since Tue, Jun 26, 2012
Converting Existing Ledgers - Nominal & Cashbook - Database Changes
Viewed 942 times since Tue, Jun 26, 2012
Application Differences - Cashbook - Account Maintenance
Viewed 848 times since Tue, Jun 26, 2012
Database Audit
Viewed 980 times since Tue, Jun 26, 2012
Application Screen Layouts
Viewed 854 times since Tue, Jun 26, 2012
Converting Exisiting Ledgers - Order Processing - Screen Design and Documents
Viewed 879 times since Tue, Jun 26, 2012