We have a request to add the Inventory Id to the Journal Transactions by Period report? Would this be possible? It is not a traditional GI, so I am not quite sure where to begin.
Best answer by Laura02
View original
+18
Hello,
I think it is possible to add inventory id to journal transactions from Inventory module, possibly purchasing , billing and/or invoicing transactions.
I think, start by joining Gltran to Intran. Here is a link discussing how to join Intran and gltran, answered by Dcomerford.
Here is a second post discussing join on gltran and Intran answered by Naveen.
Once you have successfully joined two transaction tables, you will want to explore additional joins to other tables that hold inventory ids, such as aptran, ArTran … to show the inventory item on more lines and more accounts.
Good luck!
Laura
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.