For Example
Display the sub total values based on
Account code and show grand total end of the report.
The report has only one group (G_ACCT)
and group columns like
Account Code, Ro Number, ROLine# ,Ro Type, Ro Date, Supplier#, Supplier
Name,
Supplier Site, W/H, Buyer, Items, Qty, Price, Trxn Amount
Show the subtotal and grand total amount
for Trxn amount column based on account code combination.
Steps:
- Divide the for –each loop with Account code column
- Do the current group logic.
- Display the sub total column before closing current group loop.
- Display the grand total value at end of the report.
Adding above steps logic in xml tags:
- <?for-each-group:G_ACCT;./ACCOUNT_CODE?> (first F Xml tag)
- <?for-each:current-group()?>(second F xml tag)
- After displaying G_AMT Closing current-group for-each.
- Displaying the T_AMT (grand total amount)
Output:
what is content in ACC xml tag? I tried like that but it for each one group only.
ReplyDeleteHi, DoyenTeam ,Could you kindly please send the RTF template to my email? That would be very nice of you.Thanks.
ReplyDeletejack.cui@greaconsulting.com
This comment has been removed by the author.
DeleteThanks for sharing artile about OCI Punchout
ReplyDeletecXML PunchOut
OCI PunchOut - Vurbis Interactive used OCI PunchOut, Punchout cXML, cXML Punchout, cXML Ariba, cXML protocols created by Ariba in 1999 for business communications.
ReplyDeleteOCI PunchOut
Vurbis Interactive used punchout cxml protocol developed by Ariba which helps for online shopping and ordering between e-procurement systems.
ReplyDeletePunchOut cXML
Thank You.!
ReplyDeletePunchout CXML
Can you please share RTF template. I have same kind of requirement. I have also one G_1 tag which is giving DEPT, EMP, Salary.
ReplyDeleteLike to get subtotal based on based on DEPT based salary. I tried same tag but not worked properly.
Thank you for sharing such a nice and really very helpful article
ReplyDeleteOracle Fusion SCM Online Training