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.
Solved
Adding Inventory Id to Journal Transactions by Period
Best answer by Laura02
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.