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?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.