For BI reporting purposes, I am looking for a way to correctly link the data (costs) from the GL Voucher Rows Analysis to the Part number (as per Customer Order).
Unfortunately, it appears that there is no unique identifier to link the GL voucher information to the inventory transaction history, mpccom accounting, customer order, …
I can only do an approximate link, by mapping the GL Voucher Rows Analysis [Voucher number, voucher type, account, code parts, amount] to the mpccom accounting table + [order reference] to the Inventory Transaction History. That way, we can fetch the Part Number from the Inventory Transaction History.
This only works when there are not multiple rows on the Customer Order with the same cost (and code parts).
Has anyone found the real unique reference from GL Voucher information to the inventory module?
Best answer by Adam Bereda
View original
