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 Status
Viewed 1097 times since Tue, Jun 26, 2012
Nominal Ledger Revaluations
Viewed 1239 times since Tue, Jun 26, 2012
Edit System Status Display
Viewed 1250 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledger Revaluations - Holding Rate Revaluation
Viewed 1244 times since Tue, Jun 26, 2012
Converting Existing Ledgers - Sales & Purchase Ledgers - Database Changes
Viewed 1239 times since Tue, Jun 26, 2012
Document Design Manager
Viewed 1098 times since Tue, Jun 26, 2012
Application Screen Layouts
Viewed 1091 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledgers - Account Enquiry
Viewed 1136 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledgers - Entering Invoices, Credits and Adjustments
Viewed 1118 times since Mon, Jun 25, 2012
Set Application Code Formats
Viewed 1040 times since Tue, Jun 26, 2012
|