Importing AP Bills tied to a PO Receipt

Here is a pic of the import scenario
 

Hi everyone, any ideas here for @wfilipiak67 ? Thank you!

Hi, @wfilipiak67  If this is not resolved, can you please share the XML format of the import scenario file here.

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

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.

I have added a new mapping for the import scenario that helps a AP bill Tied to PO receipt and it was successful.

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!

Hello @wfilipiak67

Here is an import scenario that I successfully used to import AP bills and tell the system which line of the PO receipt to select in the dialog box.

Let me know if this helps.

Hi All, does anyone have a working import scenario that adds a PO Receipt to a debit adjustment for a PO Return?  I have a working import scenario to add a PO receipt line to an AP Bill, however I can’t use the same import scenario for a debit adjustment as the only action is Add PO Receipt.  Unfortunately, the import scenarios above aren’t working for me.  I keep getting the error of “The system failed to commit the poreceiptslist row.”

I added a line to select the order number first, but then it tells me “Field: Order Nbr., Value: POUS18319, Error: 'Order Nbr.' cannot be found in the system.” even though when I go to manually create a Debit Ad., that PO does exist and is available to select.

Here is a screenshot of my import scenario with the order number, the manual AP Debit Adj I’m adding that shows the PO is available to select, and the import by scenario screen (see next 3 screenshots).  

The screenshots after that are the import scenario without the Order Nbr being selected, and the error showing the poreceiptlist row failing to commit - I simply uncheck the Order Nbr part of the import scenario to deactivate that line