Question

Used a migration job to load starting inventory but it doesn't appear in the GL or inventory transaction history. (Inventory Parts in Stock is correct though)


Badge +2

Used a migration job to load starting inventory but it doesn't appear in the GL or inventory transaction history. (Inventory Parts in Stock is correct though)

 


3 replies

Userlevel 4
Badge +9

Sounds like you are loading directly to the IPIS table instead of using the take on stock screen view/API.

What’s the DataMig look like?

Badge +2

That is precisely what happened. The quantity in stock was populated, like we loaded end results instead of doing it properly. Any idea how to get the initial transaction without affecting the ipis table? Or creating the missing transaction and then adjusting the ipis table afterward?

Userlevel 4
Badge +9

I would reverse/back out the transactions and reload using the correct API calls.

Trying to fix the data will be much messier 😟

Reply