Hello,
I am currently putting together a GI that will provide inventory on hand values on a specific date. With this, I had added the InTran table to acquire the InTran.TranDate values for the Parameters tab. With the addition of the InTran table, I am now getting a large number of duplicate values from the GI. I assume the reason is join related, but I am having trouble getting these duplicates removed. Any assistance would be appreciated!
Hello
Did you see the very similar question on this Community? Link below shows correct tables and joins that might be needed for your Inquiry.
Your relations are all over the place - eg. INCostStatus to POLine, InventoryItem to INTran. Suggest you use the DAC schema browser and understand the DACs that you are using before joining them. Also use Add Related Table button so that you only add joins that make sense.
If you don’t join properly, you will get duplicate data rows in your result.
Might be easier to start over.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.