You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to replace alphanumeric codes with numeric codes as given by finance team

Question
29
Views
0
Comments

Summary:

Our Finance team is expecting to get numeric codes instead of alpha numeric codes for GL COA Location in payroll costing report.To acheive this ,we are planning to do a customization in rtf template .xdoxslt logic was handled to populate all segments . Please find below the seeded code


<?for-each:*[starts-with(name(),'SG')]?><?xdoxslt:set_variable($_XDOCTX, name(),text())?><?end for-each?>

<?for-each@cell:xdoxslt:foreach_number($_XDOCTX,1,xdoxslt:get_variable($_XDOCTX,’count’),1)?>

  <?xdoxslt:get_variable($_XDOCTX,xdoxslt:get_variable($_XDOCTX,text()))?>

<?end for-each?>

Attached Costing Segment data in document.We need to replace NBC with 1141 numeric code. Is there a way to achieve this scenario in template?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!