Hi all,
I want to add tab Landed Costs to PO Receipt report but when I join, the inventory is doubled.
If you have any idea, pls help me.
Best answer by Laura02
View originalHi all,
I want to add tab Landed Costs to PO Receipt report but when I join, the inventory is doubled.
If you have any idea, pls help me.
Best answer by Laura02
View originalWhen we have duplicate lines, the problem is nearly always a problem with the join. I’m not a Join Expert or a report-writing export but I will try to give you some ideas and hopefully my ideas will help you...
In your screenshot I see POReceipt (A ‘header’ or Summary-level table/class) is joined to POReceiptLandedCostDetail, a detail/transaction table. Could one POReceipt have multiple I lines in the Landed Cost table? Maybe this leads to duplicates. With these two tables we can’t add a second join field because there is no Line Number in POReceipt table.
I think you will need to find the PO Receipt Line table, add PO Receipt Line table to your report, and connect the POReceipt Line table to the POReceiptLandedCostDetail table using both Receipt Number and Line Number fields.
Good luck!
Hi
POReceipt → ReceiptType, ReceiptNbr
POReceiptLandedCostDetail → POReceiptType, POReceiptNbr
When we have duplicate lines, the problem is nearly always a problem with the join. I’m not a Join Expert or a report-writing export but I will try to give you some ideas and hopefully my ideas will help you...
In your screenshot I see POReceipt (A ‘header’ or Summary-level table/class) is joined to POReceiptLandedCostDetail, a detail/transaction table. Could one POReceipt have multiple I lines in the Landed Cost table? Maybe this leads to duplicates. With these two tables we can’t add a second join field because there is no Line Number in POReceipt table.
I think you will need to find the PO Receipt Line table, add PO Receipt Line table to your report, and connect the POReceipt Line table to the POReceiptLandedCostDetail table using both Receipt Number and Line Number fields.
Good luck!
Thanks
I think your idea makes sense but when I join as you advice it's still duplicated, I went back to check the field in the PO Receipt Line table and i see the PO ReceiptNbr is empty.
I also check customize and I dont know how to add the right field into this.
Pls help me if you have any idea.
Hello,
Were you able to join with Naveen’s idea?
That idea doesn't work either, I see ur idea possible, but I don’t know why field POReceiptNbr does not appear.
We want to join two tables on as many key fields as possible.
If you join on the above fields, in the same order they appear above and you still see duplicates, please post your join.
I’m not able to help with customization - if needed, another community member will help you in this area.
Laura
We want to join two tables on as many key fields as possible.
If you join on the above fields, in the same order they appear above and you still see duplicates, please post your join.
I’m not able to help with customization - if needed, another community member will help you in this area.
Laura
Oh it’s work thank you, it's not duplicated anymore, but the information I want from the POReceiptLandedCostDetail table not POLandedCostReceiptLine
Hi,
I looked at the database in SQL and there is no POReceiptLandedCostDetail table. POLandedCostReceiptLine was the closest thing. Can you link POReceiptLandedCostDetail using the same fields?
If not, an expert report writer or programmer will need to help us.
Hi,
I looked at the database in SQL and there is no POReceiptLandedCostDetail table. POLandedCostReceiptLine was the closest thing. Can you link POReceiptLandedCostDetail using the same fields?
If not, an expert report writer or programmer will need to help us.
Hi
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.