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

The below import to create a Debit Adj. and add a PO Return works for me in 25r1:

 

would you happen to have xml of this working importer?

was fighting the poreceiptlist row failing to commit error for a few days.  after walking  through the import manually, i finally found the REASON for the error.

when creating new AP bill, the system defaults LOCATION to the account default.

HOWEVER, we had some receipts with the LOCATION set to a location that was not the default.

so, i added LOCATION assignment to the import scenario and it worked.  The key of course is that i have to seperate the import runs by LOCATION...but VERY happy to have found the reason and solution.

@pforres13 Glad you got it to work, try adding the isnull statement to the location and then you can do it in a single import, just leave the ones without a specific location blank in your data file and they will default to the default location for the vendor.

=IsNull([VENDORLOCATION], [Document.VendorLocationID])

thanks nick...actually it was that the location on the receipt did not match the location on the PO