Solved

Importing AP Bills tied to a PO Receipt

  • 23 February 2022
  • 11 replies
  • 537 views

Userlevel 5
Badge +2

Hi, 

I am trying to import AP bills. The AP Bills are tied to a PO Receipt. 
As well as the vendor, I have the PO number & PO Receipt Line number. 

I am having an issue with trying to select the Add PO Receipt Line in the Scenario. 
The Document is being created but nothing else is happening.
(If in migration mode, you cannot use the Add PO Receipt button) 

Does anyone have any solutions/ideas for getting this to work?
Thank you in advance!

Bill
 

icon

Best answer by wfilipiak67 8 March 2022, 19:35

View original

11 replies

Userlevel 5
Badge +2

Here is a pic of the import scenario
 

 

Userlevel 7
Badge

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

Userlevel 7
Badge +17

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

Userlevel 5
Badge +2

Hi, 

As an Update,  We found that this is not possible when the AP is in Migration mode. Which is what we were trying to do.  
You do not have access to use the Add PO or Add PO Receipt buttons.
Thanks!
Bill 

Userlevel 5
Badge +1

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!

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

 

Userlevel 5
Badge +1

Thank you!! We’ll give that a try

 

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.

Userlevel 1

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!

Userlevel 5
Badge +2

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.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved