Import Scenario - Purchase Receipts - ADD PO LINE button not adding PO Line 2

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 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!

I am using this Purchase Receipt Import successfully, however I want to add a Note Text and I cannot get it to work. Any suggestions would be appreciated

Hi, looking at this solution I’ve tested the import from ChandraM and it works to bring in lines 2 and 3 and but I can’t get line 1 and I need all of them. How can I get all the receipt lines to get created? 

An alternative to doing an import scenario.

Acumatica has REST API endpoints for Purchase Receipts, with common endpoints found under /entity/Default/Version/PurchaseReceipt and for actions like AddPOOrder within specific endpoints such as /entity/vendorpolineitems/Version//purchasereceipt/AddPOOrder, allowing for the creation and management of purchase receipts. To find the exact endpoints and their specific parameters for your Acumatica instance, you can navigate to the "Web Service Endpoints" form directly within your Acumatica system. 

How to find the specific endpoint for your instance: 

1. Log in: to your Acumatica instance.
2. Navigate: to the "Web Service Endpoints" form.
3. Locate: the PurchaseReceipt entity to view available endpoints, entities, fields, and actions specific to your Acumatica version.

Common examples of endpoints and actions:

• General Purchase Receipt Entity: 

  You might use a base endpoint like /entity/Default/Version/PurchaseReceipt to interact with purchase receipts. 

• Creating a Purchase Receipt from a Purchase Order: 

  You might find an action or a dedicated endpoint like /entity/vendorpolineitems/Version//purchasereceipt/AddPOOrder that takes a OrderNbr parameter to create a purchase receipt from an existing purchase order. 

Important Considerations:

• Version Specificity: 

  The exact version number in the endpoint URL will vary depending on your specific Acumatica deployment (e.g., 18.200.001). 

• Contract-Based API: 

  Acumatica uses a contract-based REST API, which means you can find detailed information about the available endpoints and fields within your live instance. 

• Developer Resources: 

  You can also find examples and guidance in the Acumatica Integration Development Guide and through resources on the Acumatica Community forum. 

With the help of Acumatica Support, my Import for PO Receipts is now working successfully.  Here it is for anyone interested.

Thanks for the input. The above import brings all lines from a PO? 

Yes this brings in all the lines and adds a note to the header of the document. It will also create the vendor bill.

Thanks for the input. I will take a look and confirm. 

Hi TShoaff, 

I ran the import displayed above and I keep getting a receipt with missing inventoryIDs: 

What could cause this? This is what I have in the import: 

And the PO: 

And the file: 

Let me know what could be the cause of the missing inventory ids when running this import. Thanks. 

Remove this highlighted line above

and Add highlighted line below

Thanks, made the changes got a little closer. It looks like it can’t find the purchase order number which is open: 

Hi, Thanks for all the input. I got a little further. I was able to bring in accurate lines to each corresponding PO number line but now my issue is that when I introduce a 2nd PO for the same vendor the import doesn’t read that new line see below: 

Import: 

Spreadsheet: 

Result: 

One possibility would be to break them up into separate receipts per purchase order. Any thoughts on how to do this or maybe try to fix? 

Thanks for the replies, the suggestions worked and we were able to import our data. 

Hi ​@rquiroz84, I’m running into the same issue with multiple POs. Can you please share how you resolved it?