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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (