Sage 100

Item cost is showing 0.00 on invoice with avg cost item that has a cost and the cost is populated on the sales order but changes to 0.00 when invoicing. Version 4.5.7. If I add the item to the invoice that is currently showing 0.00 cost it comes across with the correct cost?

are there multiple warehouses involved? individual warehouses each store their own average cost

No only 1 warehouse

I would use data file display and maintenance to check the average cost show on the screen against what is in the IM_ItemWarehouse table at the time of (or right before) invoicing the item. when you are manually adding it and seeing the correct cost have you put a quantity in? is Job cost involved?

All files show the avg cost correctly prior to invoicing. Yes I put qty in on the invoice. No job cost.

Additional information: it only appears to happen when the item is on the invoice multiple times. They can't combine due to code dates. The 1st instance shows a cost the 2nd does not.