Anybody got any experience with updating inventory...
# general
m
Anybody got any experience with updating inventory items' average costs for different locations? Today we have items where the average costs in several locations differ greatly from the average cost in Main inventory. I would like to do a mass update for those items and match the average cost in all locations to match the main inventory value. How hard is this to do by yourself using AI to code you a script to deploy?
c
You should start by first understanding why the variance is happening. Is there a bad transfer order that had incorrect costing, A work order without proper routing, a purchase order that happened to bring the cost down, etc. By correcting the average without knowing where the variance is coming from is just kicking the issue down the road. To my knowledge the only way to reset the average is to drain the inventory, and bring it back in at the correct price through adjustments.
💯 2
g
I Agree with @Christopher Quackenbush , we had to do this once due to a bad inventory adjustment and we could not reopen the period. We adjusted all the inventory out, waiting for the costing engine to run and the next day adjust the inventory back in with the correct cost, granted we have serialized inventory, which complicated it a bit. But that was the solution to use.
m
That's what i am thinking as well: use inventory adjustment to empty quantities and then reenter them with the correct cost. I know this can be done via csv imports and I would rather like to do it by script. Here's the thing. I know some items in our system are Serialized and some are not, some probably have bin numbers? and some don't. What I am getting hung on is the inventory detail that needs to go with the bookings. Will Claude be able to sort this out if i just generally explain what I would like to do and for it to give me a script that will do it?
s
have you tried Ask Oracle, it might use lot of your AI units, but it might be able to help, unless you talking about Claude with MCP already connected to your instance
c
This is still a multi-step process since you need to wait for the accounting engine to run before proceeding. I'd recommend doing it via CSV uploads personally. You just need to make sure your saved search / query pulls the data correctly.
💯 1