Hi @dilys , Can you please share the GI to review? Yes, looking forward to hearing from you
Hi @dilys! I would recommend to use the Merged DAC Structure (SM402000) screen to look for ways to link from APRegister to POReceipt. Have you already tried using this screen or the GI relations builder to find the stepping stones to get from AP to PO Receipts? Here is what I see to link them: Yes, I use this to search for relation but in PO Receipt field apRefNbr and aPDocType is Null when I query in database
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 @laura01 , below is the table POReceiptLandedCostDetail I’ve mentioned. I also try to join and it’s show the first line of this table, I put it in detail section 2 and grouping by LCRefNbr, do you know why it’s only show first line?
We want to join two tables on as many key fields as possible. Key Fields in POReceiptLine tableKey Fields in POLandedCostReceiptLine tableIf 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
Hello, @dilys , 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.
Thanks all, I found a way to record as prepayment and record from the bill and adjustment screen instead of check and payment
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 @laura01 so much,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
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.