Solved

Import Scenario to update Unit Price on Invoice

  • 25 November 2021
  • 7 replies
  • 471 views

Userlevel 2
Badge

I have a scenario where I need to Ship and Invoice a Sales Order via an import scenario. Occasionally I will need Qty Shipped to be different than the Qty on the Sales Order and I also will need to update the unit price on the invoice that is created. This will take 2 import scenarios because the unit price is not available on the shipment form. I have figured out how to get the shipment import scenario working. 

 

However the import scenario I have built for SO303000 is adding a new line to the invoice, not updating the existing one that matches the item.

 

Any ideas what could be causing that? 

icon

Best answer by vkumar 25 November 2021, 05:22

View original

7 replies

Userlevel 2
Badge

Thanks, I have it working now. 

 

Userlevel 7
Badge +11

Hi @Brian Rowerdink 

You may map the extended price column manually as well if the values are available on import source file. 

This is how the column behaves :

https://help-2021r2.acumatica.com/(W(11))/Help?ScreenId=ShowWiki&pageid=5e6f3b27-b7af-412f-a40a-1d4f4be70cba

Ext. Price The extended price, which is either the unit price multiplied by the quantity or a manually entered amount that may not be equal to the product of the unit price and the quantity.
If you want to update the extended price automatically to the current value (that is, the applicable sales or default price multiplied by the item quantity), you can use the Recalculate Prices and Discounts action. If you have modified the extended price once and saved the document, the value will not be updated by the system if you change the document date.

 

Regards,

Userlevel 2
Badge

I have made progress. I hadn’t change the Source Value to =[Transactions.InventoryID], but once I did in the scenario, it updated the unit price. I just need to confirm the search will work with multiple lines and I noticed it is not updating the Ext price. Should be Qty times Unit price. 

Userlevel 7
Badge +17

@Brian Rowerdink If possible, can you please attach the updated import scenario here?  I can take a look and let you know, if I found anything.

Userlevel 2
Badge

 

@Naveen B I had already found that link, but thanks for sharing. @vkumar It appears I have the lookup section the same as yours but when I run the scenario it adds a line, and doesn’t update the one above. Any thoughts? This is the SO Invoice screen. 

 

 

Userlevel 7
Badge +17

Hi @Brian Rowerdink  Addition to @vkumar still, if you have any queries on the import scenarios, below article will helps you a lot.

 

https://www.eis.consulting/post/acumatica-import-and-export-scenarios-tips-and-tricks

Userlevel 7
Badge +11

Hi @Brian Rowerdink 

Please use following two lines to update existing SO line. 

  • first line highlighted below is to search/ locate the SO line you want to update
  • Second line is deactivated ( -1 normally inserts a new line)
  • Third line is to supply the inventoryID which needs to be updated with new price

 

Let me know if this helps. 
Regards,

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