I have added a new mapping for the import scenario that helps a AP bill Tied to PO receipt and it was successful. My main man! Thanks so much for your help Ivan!
Thank you!! We’ll give that a try I stand corrected. When I posted my response I had only checked the primary list for the newly created Bill…. it did not have the PO line brought in via the import. Back to my drawring board. Yes I spelled that wrong on purpose.
Hello, does the import in your screen shot work if your not in migration mode? We have a customer who wants to match invoices to a PO in an AP bill import. Thanks! I got mine working by removing the selector line and adding in Field Action Receipt Nbr. - see below
Thanks Ben! I’ve dabbled in DAC’s before and this makes sense. The update I have for this query is that I’ve gone back to the business and am accomplishing their request with training on the use of the purchase receipt primary list. Reporting this sort of information contradicts the purpose of an ERP… IMHO.
The POReceiptLine table is there to get the PO Order Number field. In 2018 R1 the POReceipt table does not have the PO Order Number field.
How is that done in report designer?
Yup, the duplicate lines are for all the rows on each receipt. I’ve tried aggregation but have failed thus far as this is all in report designer.
In 2018 R1, the screen is not updated. However, the tables have the required field to join to INRegister!Now if only I could manage the joins so that only one row would show up.Here we see all the joins for all the rows matched on the POReceiptLine table:and here are the joins for the tables:any advice?
If you are looking to find all PO Receipts released since yesterday your only option is resort to LastModifiedDateTime. But this isn’t foolproof as i believe a note being added to a released PO Receipt will update the LastModifiedDateTime. If you don’t add notes to released receipts then you might be OK. Unfortunately, the last modified date time on the purchase receipt is updated when AP creates a bill from the receipt. Might just require a process & technical solution here. Thank you!
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.