Combine columns of PO catalog, category, Accounting Code into 1 report
Summary:
Combine columns of PO catalog, category, Accounting Code into 1 report
Content (please ensure you mask any confidential information):
Hi Experts,
Would like to reach out to you for your experiences working on the list of PR/PO categories into a list for reference.
What we had implemented is that we have defined quite some PR/PO categories, using mapping sets to define the accounting codes to them.
Now we want to pull out a report having the list of the PR/PO categories versus the accounting codes mapped to it, but I found the information sits in 2 areas.
Please refer to the screenshot below, that I got the mapping set (having category name and its accounting code) via a SQL:
0