Community,
In Inventory Transaction History window, we can see accounting information in Accounting tab. We would like to create a report that show not only inventory transaction ID but also the accounting info.
when I am browsing the file MPCCOM_ACCOUNTING that are under tab Accounting, I don’t see any data column could be the keys that can be linked with inventory transaction, e.g. Transaction ID, Site, Part No….
how we could make this report? any idea?
Best answer by cynthia.wilson
I’m pretty sure the link you are looking for is the accounting_id in mpccom_accounting = transaction_id in inventory transaction views
I’m pretty sure the link you are looking for is the accounting_id in mpccom_accounting = transaction_id in inventory transaction views
+12Hi
Could you please review the following communications to determine if they would be helpful in addressing your question?
Regards,
Chanuka
+9Hi all,
I checked my scripts. Our FACT_ITH contains the following:
...
FROM
extr_IFS_INVENTORY_TRANSACTION_HIST_TAB as ITH
LEFT OUTER JOIN
extr_IFS_MPCCOM_ACCOUNTING_TAB as MA
ON
ITH.CONTRACT = MA.CONTRACT
AND
ITH.ACCOUNTING_ID = MA.ACCOUNTING_ID
Please let me know if your report goes the same direction.
BR
Michael
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
