Can someone please help me? I can’t get some tables’ field data so I tried removing some tables and relationships that I’m not getting any data from because it seems like they’re causing it. After removing some, I got those tables’ data. But then, my total net sales, still with same filtering, differed. And that shouldn’t happen. Now what do I do? Returning the tables will not display those field again tho. Pls let me know what I need to show so you could help, thanks a lot!
Best answer by Naveen Boga
Hi @paula012 I see some issues with the JOINS it will lead to duplicate/inconsistent results.
SOOrderShipment → ARInvoice table we don’t have common fields. Please add the joins like below and hope this helps
Can you please let us know what table you have joined, what is not working, and then which tables you have removed?
If you can provide these details along with the screenshots, it would be helpful for us
This is my original table and relationship, I highlighted what I removed which caused to show me the fields I need. In the next picture is my new set of relationships. And I highlighted the new joins. What’s not showing before the edits are fields from ARInvoice and SOShipment.
Sir, do you mean these are the only tables I should put. Or from where do I start inserting these? What do I do in my existing tables above? I got error. I added these tables
Sir, this is my new set of relationships. It gives me correct total. I need a field from ARInvoice though, how can I relate to that table? Thank you so much!
And sir @Naveen Boga , Sometimes, my total net sales is correct, and sometimes, it doesn’t tally. Here are the screenshots. 1st has wrong, the 2nd has correct.
sir @Naveen Boga , so this is what I saw, sometimes, total net sales (sum[ARTran.Netsalesamount]) gives me the total of Net Sales ([ARTran.Netsalesamount]) which is also equal to (Total per item/1.12) and sometimes it gives me amount of (Invoice/1.12). Can’t understand why that would happen. Pls help, thanks a lot!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.