Import scenario issue: The last cost is not getting updated when trying to import stock items in Acumatica

A dependable ERP system is invaluable for any business looking to track and evaluate sales performance. In this blog, Acumatica users can gain key insights on how to solve the  
“Import scenario issue: Last Cost not getting updated when importing stock items.” 

 There might be scenarios while trying to import stock items in Acumatica; the Last Cost field might not get imported for the external file even when the Valuation Method = Average as shown below. 

Screenshot 1
Screenshot 2

Hence, the following Import Scenario can be created to get the field imported. 

  1. After defining the data provider on the Data Provider () form, head to the Import Scenario () form to map the fields. 
Screenshot 3

Map the fields in the Import Scenario as shown below. 

Screenshot 4

After mapping fields, open the Import by Scenarios form and search for the above-created Import Scenario. 
Click either the Prepare & Import button for 1-step migration or the Prepare button & then on the Import button for 2-step migration. 
The status is now changed to Processed, meaning the migration has been done successfully. 

Screenshot 5

Now open the Stock Items screen & search for the imported stock items. 
Here, we have imported one stock item- Stock1. 
Open the Price/Cost tab. 

Screenshot 6
  1. Hence, the Last Cost field has been imported and converted to an editable field. 

This blog explains the import scenario issue: Last Cost is not updated when importing stock items. For an immersive Acumatica customization and implementation consultation, please mail us at 

About Us– Recognized for its X3 implementation and customization worldwide, GerminIT is one of the oldest Sage X3 (a Sage Business Cloud Solution) development and implementation enablers and a one-stop solution provider for Sage X3 organizational needs. With a proven track record of X3 development and implementation solutions for clients across the US, UK, Middle East, Australia, Asia, and Africa, we bring complete end-to-end assistance for data migration, system integrations, technical consultations, and implementation competence, and third-party support add-on development, and product customizations.  GerminIT will support your business with the best-in-class Sage X3 customization and development services, integrated applications such as Shipping System | eCommerce | Business Intelligence | POS | WMS | Payment Gateway, and mobile add-on solutions. GerminIT caters to a wide range of Sage X3 offerings. We provide end-to-end support with Sage X3 implementation and customization solutions for Sage business partners, Sage PSG, and end-users worldwide.



Cloud ERP Consultation In India


Leave a Reply

Your email address will not be published. Required fields are marked *