You’re offline. This is a read only version of the page.
Does anyone have an excel template to upload to ALRAT00?
*This post is locked for comments
I have the same question (0)
It really depends on how your rate table is set up (how many key fields you have).
this is the simple control macro(you can generate this from SL - Admin - Utilities - Control Macro Generator)
Header,crate_table_id,crate_type_cd,crate_level
Detail,crate_key_value1,crate_key_value2,crate_key_value3,ceffect_date,crate
Save these lines into a text file with a csv extentsion - then open with excel.
Header, RTB, RT, 1
Detail,LABOR-DT,,, 5/1/2014, 100
Detail,LABOR-OT,,, 5/1/2014, 75
Detail,LABOR-ST,,, 5/1/2014, 50
and if you had a Rate table with a code value of RTB and a rate type of RT with one Key of ACCT and the labor accts I have this would do it.
Share
Report
All responses (
Answers (
