Skip to main content
Solved

Importing AP Bills tied to a PO Receipt


wfilipiak67
Captain II
Forum|alt.badge.img+3

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
 

Best answer by wfilipiak67

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 

View original
Did this topic help you find an answer to your question?

11 replies

wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • February 23, 2022

Here is a pic of the import scenario
 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2751 replies
  • March 7, 2022

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3399 replies
  • March 8, 2022

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


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • Answer
  • March 8, 2022

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 


Forum|alt.badge.img+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!


donnadeskins55 wrote:

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

 


Forum|alt.badge.img+1

Thank you!! We’ll give that a try

 


donnadeskins55 wrote:

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.


  • Freshman III
  • 3 replies
  • December 16, 2022

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

 

 


ivannathan67 wrote:

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!


ed.goodman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Employee
  • 122 replies
  • December 21, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings