CU61.1 - Maintain Translation Rates
**Form purpose
Use Maintain Translation Rates (CU61.1) to display and maintain currency table
translation rates imported from a non-Lawson environment (a spreadsheet for
example) into the CUTRATEREL file before you interface it to the Lawson
Currency system. This form is used to verify your information transferred to
the Lawson system correctly.
**Prerequisites
Before you interface translation rates, you must define all the currency
relationships for which you are interfacing data, using Currency Relationship
(CU02.1), and you must define all the translation codes you are interfacing,
using Translation Codes (CU05.2). In addition, if you are interfacing
translation rates for a currency table, you must define the currency table,
using Currency Table (CU00.1); if you are interfacing translation rates for a
company or company group, you must set up the company or companies, using
Company (GL10.1); and if you are interfacing translation rates for a budget,
you must define the budget, using Period Budget, Rate (FB20.1)
**Process at a glance
1. Convert your non-Lawson file to a comma-value-separated (CSV). The fields
in your CSV file must match the position, size and type of the fields in the
CUTRATEREL Lawson interface file.
2. Use a transfer utility program (such as the winptxfr or ftp command) to
transfer your non-Lawson file to your Lawson environment. You may need to
rename your PC file to match the naming conventions of your Lawson
environment. For example, to transfer file currency rate.csv in your PC Data
directory to your UNIX machine, use this command:
winptxfr -u cutran-rate c:\\Data\\Curr transl rate.csv
where cutran-rate is the name you give the file on your Lawson machine.
3. Import the file you just transferred into the Lawson Currency Translation
Rate Interface file (CUTRATEREL), by using an Import command, such as:
importdb productline CURATEREL curr-rate
where productline id the Lawson product line where you want to load the
file.
4. View and maintain the information in the CUTRATEREL file, using Maintain
Translation Rates (CU61.1) or Maintain Co Translation Rates (CU61.2), and
Period Rates (CU61.3).
5. (Optional) Run Translation Interface Listing (CU261) to list currency
records.
6. Run Interface Translation Rates (CU161) to load the currency translation
information into the Currency application.
7. Correct any records that did not interface using CU61.1, CU61.2, or
CU61.3, and run CU161 again. Repeat these steps until all records are
interfaced.
**More help
Once records are interfaced successfully using CU161, they are deleted from
the CUTRATEREL file and can no longer be viewed on CU61.1, CU61.2, or CU61.3.
They have become regular Currency records and you can view and maintain them
on Currency Table Translation Rates (CU20.1) or Company Translation Rates
(CU20.3).
Use the Rates button to open Period Rates (CU61.3) and view and maintain the
period rates for each currency relationship and translation code in the
CUTRATEREL file.
Updated Files
CUTRATEREL -
Referenced Files
CUCODES -
CURELAT -
CUTABLE -
TRCODES -
CU61.2 - Maintain Co Translation Rates
**Form purpose
Use Maintain Co Translation Rates (CU61.2) to display and maintain company
currency translation rates imported from a non-Lawson environment into the
CUTRATEREL file, before you interface the data to the Lawson Currency system.
This form is used to verify that your information transferred to the Lawson
system correctly.
**Prerequisites
Before you interface translation rates, you must define all the currency
relationships for which you are interfacing data, using Currency Relationship
(CU02.1), and you must define all the translation codes you are interfacing,
using Translation Codes (CU05.2). In addition, if you are interfacing
translation rates for a currency table, you must define the currency table,
using Currency Table (CU00.1); if you are interfacing translation rates for a
company or company group, you must set up the company or companies, using
Company (GL10.1); and if you are interfacing translation rates for a budget,
you must define the budget, using Period Budget, Rate (FB20.1)
**Process at a glance
1. Convert your non-Lawson file to a comma-value-separated (CSV). The fields
in your CSV file must match the position, size and type of the fields in the
CUTRATEREL Lawson interface file.
2. Use a transfer utility program (such as the winptxfr or ftp command) to
transfer your non-Lawson file to your Lawson environment. You may need to
rename your PC file to match the naming conventions of your Lawson
environment. For example, to transfer file currency rate.csv in your PC Data
directory to your UNIX machine, use this command:
winptxfr -u cutran-rate c:\\Data\\Curr transl rate.csv
where cutran-rate is the name you give the file on your Lawson machine.
3. Import the file you just transferred into the Lawson Currency Translation
Rate Interface file (CUTRATEREL), by using an Import command, such as:
importdb productline CUTRATEREL curr-rate
where productline id the Lawson product line where you want to load the
file.
4. View and maintain the information in the CUTRATEREL file, using Maintain
Translation Rates (CU61.1) or Maintain Co Translation Rates (CU61.2), and
Period Rates (CU61.3).
5. (Optional) Run Translation Interface Listing (CU261) to list currency
records.
6. Run Interface Translation Rates (CU161) to load the currency translation
information into the Currency application.
7. Correct any records that did not interface using CU61.1, and run CU161
again. Repeat these steps until all records are interfaced.
**More help
Once records are interfaced successfully using CU161, they are deleted from
the CUTRATEREL file and can no longer be viewed on CU61.1, CU61.2, or CU61.3.
They have become regular Currency records and you can view and maintain them
on Currency Table Translation Rates (CU20.1) or Company Translation Rates
(CU20.3).
Use the Rates button to open Period Rates (CU61.3) and view and maintain the
period rates for each currency relationship and translation code in the
CUTRATEREL file.
Updated Files
CUTRATEREL -
Referenced Files
CUCODES -
CURELAT -
GLADDRESS -
GLCHART -
GLSYSTEM -
TRCODES -
INVOKED Programs
IFSG
|
