Skip to main content

I’m creating an Import Scenario for the Purchase Request screen (PO.30.20.00).

I’m having difficulty adding an individual PO line (other than the first PO line) using the ADD PO LINE button (found under the DETAILS tab).

 

 

It seems like the 2nd line never gets properly selected thus, by default, the first line remains selected.

How do I add a PO line other than the first one?

Here is are my steps (in two screenshots):

 

 

Hi @dmillette Please upload the import scenario you have created, so that we can take a look.


Hi @dmillette Please also let us know the Acumatica Version being used.


How do I export an import scenario in order to upload it here?


Hi @dmillette Please use the below option to export as XML. After that you will find the XML in the “Downloads” folder on your PC/Laptop.

Chandra


Hi @dmillette Just an update. I created a new Import Scenario and was able to replicate the issue that you mentioned.

Just attaching the import Scenario here.

 

 

 


hi @dmillette Here is the solution to answer your question - How do I add a PO line other than the first one?
Please find the attached import scenario to import the PO Receipt with the PO lines other than the first line.

Here is the screenshot showing the result:
 

 


Hi @dmillette Just an additional information on my testing. Please find the screenshot of the sample PO used for my testing and the excel data file used for my testing.

Screenshot of the PO used for my testing:

 

The imported PO receipt - Imported the lines other than the first line (solution for your original Question - How do I add a PO line other than the first one?)

 


Hi.  I tried the attached solution for this issue, and I am getting the same error as the PR import scenario I created.  Quantity must be greater than zero.  When I pull in a PO line into the receipt, the quantity received defaults to zero. This happens when entering a receipt manually and must be changed also.   I’m trying to change the quantity received in my import with no luck.  Any ideas?  If I need to open a new post on this just let me know.  Attached is the error for the original import solution attached to this thread, and also a screenshot of my import scenario.

Thanks,

 

 

 


Hi @MFlint Please try changing the receipt Qty formula as below with a single quote.

 =’1.00’


Hi ChandraM.  Thank you for the reply.  I’ve actually just made some progress on the PR import. The issue with the ‘Receipt Qty must be greater than 0’ was happening because of the save action in the document summary happening before the line changing the Receipt Qty to = 1.00.  Deactivating the save is now allowing me to import a 2 line PR.  I did have 3 items, but one of the items was creating an Document error.  I’ll have to investigate why that is, but this is a good start.

 


Hi @MFlint Thanks for the update!


Reply