Has anyone had any luck with pulling the inventory part number with the GL voucher rows analysis data?
I want to see if there is a way that when I run the GL balance analysis or GL rows analysis it pulls in the inventory sales part number as well.
Best answer by Thomas PetersonView original
MPCCOM_ACCOUNTING_ID is stored on GEN_LED_VOUCHER_ROW. You can join with MPCCOM_ACCOUNTING or INVENTORY_TRANSACTION_HIST views to achieve what you want
I created a sample quick report for you. Parameters are COMPANY, ACCOUNTING_YEAR and ACCOUNTING_PERIOD
You can extend the report based on your requirements
Hope this helps
Just one more thing,
The voucher must not exist in summarize voucher window. This may cause lose of mpccom_accounting_id during GL update routine
The GL - Balance analysis / similar does not have a configuration that can bring in that type of detail - inventory part. Like
@gumabs wrote - a very common process is to create a quick report, and was nice to add that to this posting.
The idea is you could use this as a quick report - even add that to your IFS navigator. It would essentially run similar to the voucher rows analysis screen.