Related topics
The following describes the process of changing the transaction currency for all open items in Accounts Receivable and Accounts Payable with a currency that will be non-existent, like currencies within the EMU. The reason for this is that there may exist open items in both the A/R and A/P ledgers, in the “old” transaction currency.
The conversion program will convert open items in transaction currency to the selected currency, and only open items with remaining amount >0.
What this document contains:
Overview
- Only open items in Accounts Receivable and Accounts Payable will be converted.
- Balances will be rebuilt using the standard function for
- Rebuilding balances from transactions
- The following files will not be converted:
- SROPST
- SROLOGGL
- SROVAT
or
- SROECF (Sales/Purchase final statistics)
- A parallel file will always be created, saving the amount before and after conversion.
- The conversion will be run separately for Accounts Receivable and Accounts Payable.
- The conversion may be run more than once.
- You must run the conversion for each currency entering a From – To currency code. If the To currency code is the same as the system currency code, then the amount in system currency will be moved to transaction currency without calculation.
- It will be possible to enter due date, which means that only documents with due date after entered date, will be converted. You can leave the field blank and all open items will be converted.
- A conversion in the portfolio handling will be done for draft/bill transactions, document types with liquid entry panel defined as 2, with status 0. (Not for cheques). If these transactions are also connected to an open item in A/R (data type 6), then they will be converted to exactly the same amount.
- All open items in A/R connected to portfolio handling and with a status greater than 0 will not be included in the transaction currency conversion at all.
- Preliminary invoices, which have been matched, will not be converted, i.e., transactions exist in file SROPIG. These invoices must be booked final before they can be converted.
Note: When the preliminary invoices are converted, entered Base amount and VAT amount will always be calculated according to entered conversion rate. This could eventually cause smaller differences, which can be corrected when the invoice is booked as final.
Prerequisites
It is recommended that the following tasks are completed before the conversion takes place (there will be no control or conversion made on these files):
| File |
To do |
| Check for open orders in old currency and carry through the following if any exist. Run the primary currency conversion for the customer or run the invoice routine and update Financials. |
| SROIBT |
Check transactions residing in the interface file for G/L to Financials. Update transactions with old currency. |
| SROOVF, SROOVW |
Transfer all journals in error (for old transaction currency). |
| SROLPH, LPP, LP2, LP3, LP4, LP5 |
No conversion will be made for transactions in A/P payment proposals. Check your proposals, if any should be updated or deleted. |
| SROPGED, SROPGEL |
No conversion will be made for transactions in A/R payment proposals. Check your proposals, if any should be updated or deleted. |
Distribution
| File |
To do |
| SROBTR |
Update all accounting transactions created in Distribution. |
| SROECB |
Update all acquisition statistics created from goods reception to Financials. |
Financials
| File |
To do |
| Accounts Receivable and Accounts Payable |
| SROTRAA, SROTRAC, SROTRAO, SROTRAS, SROTRAV |
Update or delete temporary interrupted batches. |
Prerequisites
The following prerequisites must be fulfilled before conversion. The conversion program will check that all of these prerequisities have been taken into consideration.
| File |
To do |
| Accounts Receivable |
| SROGRDL, SROGDT |
Update or delete all Group document proposals. |
| FKR062A, SROINTC, SROINTD, SROINTT |
Update or delete Interest note proposals. |
| SRORTRC, SRORTRD, SRORTRT |
Update or delete A/R payment order reminder proposals. |
| SROKBA |
Transfer all invoices residing in the general interface file to Financials. |
| SROKBP |
Transfer all batch payments residing in the general interface file to Financials. |
| File |
To do |
| Accounts Payable |
| SROLBA, SROLBV |
Transfer all invoices residing in the general interface file to Financials. |
| SROECT |
Transfer all Intrastat transactions for purchase statistics residing in the general interface file to Financials. |
| SROPYH1, SROPYD |
Transfer transactions residing in the DI interface file for extended payment order. |
| SRORDRC, SRORDRD, SRODRDT |
Update or delete A/R payment order reminder proposals. |
| SROKBA |
Transfer all invoices residing in the general interface file to Financials. |
| SROKBP |
Transfer all batch payments residing in the general interface file to Financials. |
Files to be converted
The following files are converted or changed. If system currency is equal to transaction currency, then no conversion is made, only a move from amount in system currency.
Accounts Receivable
| A/P |
File description |
| SROLEN |
Liquid entry |
| SROPFP |
Portfolio proposal heading |
| SROPFPL |
Portfolio proposal lines |
| SRODTA |
A/R Transaction file |
| SRODTAR |
A/R Transaction file, redefinition |
| SRODTAI |
A/R Transaction file, invoices |
| SRODTAB |
A/R Transaction file, bill transaction |
| SROVPH |
A/R Settlement path heading |
| SROVPX |
A/R Settlement path index |
Accounts Payable
| A/P |
File description |
| SROLENP |
A/P Liquid entry |
| SROLTA |
A/P Transaction file |
| SROLTPG |
A/P Transaction file, prelim G/L trans |
| SROLTAR |
A/P Transaction file, redefinitions |
| SROLTAI |
A/P Transaction file, invoices |
| SROLTAL |
A/P Transaction file, invoice lines |
| SROLPH |
A/P Settlement path heading |
| SROLPX |
A/P Settlement path index |
Parallel files
The conversion program checks if parallel files already exist in the conversion library; if not, then they will be created.
Accounts Receivable
| A/P |
File description |
Parallel file |
| SRODTA |
A/R Transaction file |
SCODTA5 |
| SRODTAB |
A/R Transaction file, bill transaction |
SCODTAB5 |
| SRODTAI |
A/R Transaction file, invoices |
SCODTAI5 |
| SRODTAR |
A/R Transaction file, redefinition |
SCODTAR5 |
| SROLEN |
Liquid entry |
SCOLEN5 |
| SROPFP |
Portfolio proposal heading |
SCOPFP5 |
| SROPFPL |
Portfolio proposal lines |
SCOPFPL5 |
| SROVPH |
A/R Settlement path heading |
SCOVPH5 |
| SROVPX |
A/R Settlement path index |
SCOVPX5 |
Accounts Payable
| A/P |
File description |
Parallel file |
| SROLTA |
A/P Transaction file |
SCOLTA5 |
| SROLTAR |
A/P Transaction file, redefinition |
SCOLTAR5 |
| SROLTAI |
A/P Transaction file, invoices |
SCOLTAI5 |
| SROLTAL |
A/P Transaction file, invoice lines |
SCOLTAL5 |
| SROLPX |
A/P Settlement path index |
SCOLPX5 |
| SROLPH |
A/P Settlement path heading |
SCOLPH5 |
| SROLTPG |
A/P Transaction file, preliminary G/L trans |
SCOLTPG5 |
| SROLENP |
A/P Liquid entry |
SCOLENP5 |
Related topics