By using this website, you agree to our Terms of Use (click here)
HI ,
i wanna shows every single invoice item to invoice screen
like this:
Refnbr Inventory ID SOLD QTY
ARI12345 APF-1234 5
ARI12345 APF-5678 1
ARI12345 APF-4567 9
ARI56778 APF-7788 3
ARI56778 APF-7564 2
my tables and relations is
but the screen shows duplicate and empty
whats somthing wrong with this ?
thank you
I think I would add a condition, there is a tab over to the right of tables/relations called conditions.
If you put in that the quantity needs to be greater than 0 it should eliminate those entries.
After you do that if that doesn't work maybe post an update?
Nic
@nicholas-smith
thanks for reply, i add a condition for this situation , like this
and worked
If the three columns you show are the only values you want, don't include ARInvoice or SOInvoice. These three columns can be found in ARTran which is used to store the detail lines for all invoices, regardless of which module they were created in.
This should help avoid ambiguous joins which are most likely the cause of your duplicate rows. (I believe you are experiencing this by using SOInvoice as your parent table rather than ARTran.)
Only stock items have Inventory ID on AR Tran rows.
To correctly filter non-stock lines from your results, you should be using condition: ARTran.InventoryID Is Not Null.
What you have with Does not contain = 'Null' really makes no sense at all.