Share
ReportDoes anyone have an excel template to upload to ALRAT00?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
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.
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
All responses (
Answers (
