I could’ve sworn that when an SO Line gets created for a new combination of stock item + Warehouse, it automatically adds this to the Item Warehouse Detail table. Maybe I was dreaming though, or mixing that up with InSiteStatus. Now we’re discovering a bunch of Sales Order Lines w/ no “cost” because an Item Warehouse Detail row doesn’t exist for that Warehouse (even though a Current Cost exists on the Stock Item profile).
Similar to the “Recalculate Prices” action on the Sales Order screen, is there (or could there easily be) a “Recalculate Costs” action? I’d like to avoid deleting a line and recreating it just to get the cost to retroactively fill in.
Have any other customers, who deal with multiple warehouses, found a good solution to this problem? I guess I assumed that Acumatica was doing more intelligent automations on the back-end to ensure standard cost data integrity, but I guess not.
Best answer by max21View original