Skip to main content
Solved

Adding Inventory Id to Journal Transactions by Period

  • 22 February 2024
  • 1 reply
  • 37 views

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

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

View original
Did this topic help you find an answer to your question?

1 reply

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • February 22, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings