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.
|
Converting Existing Ledgers - Nominal & Cashbook - Menu Design
Viewed 1272 times since Tue, Jun 26, 2012
Edit System Status Display
Viewed 1283 times since Tue, Jun 26, 2012
Currency Principles
Viewed 1384 times since Fri, Jun 8, 2012
Application Differences - Sales & Purchase Ledgers - Reporting Differences
Viewed 1133 times since Tue, Jun 26, 2012
Controls & Audit Manager
Viewed 1199 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger - Account Maintenance
Viewed 1250 times since Tue, Jun 26, 2012
Database Audit
Viewed 1258 times since Tue, Jun 26, 2012
Maintain Currency
Viewed 1106 times since Tue, Jun 26, 2012
Spot Rates Report
Viewed 1090 times since Tue, Jun 26, 2012
Converting Exisiting Ledgers - Stock Control - Screen Design
Viewed 1202 times since Tue, Jun 26, 2012
|