Skip to main content
Question

Import Scenario for Inventory Issue for Project Stock items

  • Nov 13, 2026 10:23 PM UTC
  • 4 replies
  • 21 views
  • Translate All

Our current proces has items being fabrication for projects that never get issued out via sales or shipments.   I am trying to write a Import Scenario that create an Issue transaction to issue these items back to the source project to clear them out of inventory and put their costs back to the project.  

I have a GI setup as the provider for the Import Scenario.  I am running into two errors:

  1. For lot tracked items, the LotNumber is not be recognized.  I have confirmed the LotNumber, Warehouse, Location, Project and Task being passed are all correct.
  2. For non tracked items, I am getting “Object reference not set to an instance of an object.” at the last record.

 

Prepared data:

 

Appreciate any thoughts.

4 replies

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@ehuels Have you tried using excel file provider and import the data?Can you share me sample data and XML file attachment?

Translate

Forum|alt.badge.img+5
  • Varsity III
  • Nov 14, 2026 8:49 AM UTC

hi ​@ehuels 

Can you please share the xml of the GI along with the import scenario?

Translate

Eric Ratté
Jr Varsity I
Forum|alt.badge.img+5
  • Jr Varsity I
  • Nov 15, 2026 7:20 PM UTC

Hi,

If you would try to create an issue manually for the first row, using the exact same steps has what is in your import scenario, you would probably get more info about the error, either at the screen or in the trace.

I had seen the Project cost layer has often being the problem. Depending on the strategy for inventory management assigned to the project, the Free stock allowed or not at the project-level and the cost layer of the inventory in stock (Free or Project), Acumatica will prevent using certain quantity on hand. By creating manually the transaction, there is a good chance you will get an error message more meaningfull.

Translate

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Nov 15, 2026 11:12 PM UTC

Hi ​@ehuels 

Please refer to the following thread, which has a working import scenario reference for Issue document with Lot/Serial. Alter your import scenario to have fields mapping in same sequence. Its a working import scenario from our Demo tenant. Test your import scenario separately to ensure it works on its own. Use it on business event once you get the scenario to work independently first. 

 

Hope this helps,

Thanks,

 

Translate