Hi All,
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
SOOrderShipment → ARInvoice table we don’t have common fields. Please add the joins like below and hope this helps
| SOOrder (OrderTyp, OrderNbr) | SOOrderShipment (Order Type, OrderNbr) |
| SOOrderShipment (ShipmentNbr) | SOShipment (ShipmentNbr) |
| SOOrder (Customer ID) | BAccount (BAccountID) |
| SOShipment (ShipmentNbr) | SOShipLine (ShipmentNbr) |
| SOShipLine (ShipmentType, ShipmentNbr, lineNbr, InventoryID) | ARTran (SOShipmentType, SOShipmentNbr, SOShipmentLineNbr, InventoryID) |
+19Hi
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
Hi
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.
Thank you!
+19Hi
SOOrderShipment → ARInvoice table we don’t have common fields. Please add the joins like below and hope this helps
| SOOrder (OrderTyp, OrderNbr) | SOOrderShipment (Order Type, OrderNbr) |
| SOOrderShipment (ShipmentNbr) | SOShipment (ShipmentNbr) |
| SOOrder (Customer ID) | BAccount (BAccountID) |
| SOShipment (ShipmentNbr) | SOShipLine (ShipmentNbr) |
| SOShipLine (ShipmentType, ShipmentNbr, lineNbr, InventoryID) | ARTran (SOShipmentType, SOShipmentNbr, SOShipmentLineNbr, InventoryID) |
Hi
SOOrderShipment → ARInvoice table we don’t have common fields. Please add the joins like below and hope this helps
| SOOrder (OrderTyp, OrderNbr) | SOOrderShipment (Order Type, OrderNbr) |
| SOOrderShipment (ShipmentNbr) | SOShipment (ShipmentNbr) |
| SOOrder (Customer ID) | BAccount (BAccountID) |
| SOShipment (ShipmentNbr) | SOShipLine (ShipmentNbr) |
| SOShipLine (ShipmentType, ShipmentNbr, lineNbr, InventoryID) | ARTran (SOShipmentType, SOShipmentNbr, SOShipmentLineNbr, InventoryID) |
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
Can you pls see it? Thanks a lot!
+19
sir
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
