Home » Categories » Solutions by Business Process » Finance » Currency |
Converting Existing Ledgers - Order Processing - Database Changes |
Article Number: 909 | Rating: Unrated | Last Updated: Mon, Jun 12, 2023 at 7:57 PM
|
Datafile Software Converting Existing Ledgers - Order Processing - Database Changes 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. Order Header FileItem 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 Order Detail FileItem 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 |
Attachments
There are no attachments for this article.
|
System Profiles
Viewed 925 times since Tue, Jun 26, 2012
Application Differences - Sales and Purchase Ledgers - Account Maintenance
Viewed 859 times since Mon, Jun 25, 2012
Converting Existing Ledgers - Sales & Purchase Ledgers - Menu Design
Viewed 933 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger - Reports
Viewed 1011 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledgers - Entering Payments and Payment Adjustments
Viewed 937 times since Tue, Jun 26, 2012
Foreign Currency Considerations
Viewed 1074 times since Fri, Jun 8, 2012
Nominal Ledger Revaluations
Viewed 986 times since Tue, Jun 26, 2012
Database Structures
Viewed 829 times since Tue, Jun 26, 2012
List of Currencies Report
Viewed 953 times since Tue, Jun 26, 2012
Currency Management
Viewed 877 times since Tue, Jun 26, 2012
|