Sage 100

User is on Sage 100 2013. They are entering Sales Orders dated 6-8 months into the future and they notice the orders pull cost (Average) on the day the order is entered. They are wondering if there's a way to have this cost assigned when the invoice is actually created? I suspect that their better solution is to create a quote and change that quote to an order closer to invoice date.

It is only showing the average cost in SO Entry. Are they using Average Cost for their valuation method? If so, it should pull the average cost when it is invoiced. If not, it will pull whatever cost is valid at the time of invoicing.

Do you mean they want that old average cost to be the cost used when the invoice updates, or do you mean they want it to be assigned the average that is current at the time of the invoice when the invoice updates?

I did a test order for an average cost item and it appears to assign the cost at the time I enter in the SO. Their issue is they are entering a bunch of future orders and that drives the quantity negative and they say (haven't followed this through with them) that the average cost goes negative as a result.

In order to test this would have to do a SO, then do a receipt to change the average cost, then do an invoice to see if it uses the new average cost. It should.

That should only drive the Qty AVAILABLE negative, not the Qty on Hand. But costs for invoices are assigned at the time of the invoice update, since the lots and serials may not be known until invoicing and with LIFO/FIFO it waits until the actual update to determine which layer to use. Same for Physical Count Register, which is why the total on your Variance may not be exactly equal to what actually gets posted to GL.

When I key an SO with an item that is an average cost I see that the cost is assigned right then. I don't know if it gets updated when the order becomes an invoice. Just got off the call a little bit ago .

That's only informational at the time of order entry. As @BethBowers said above, the actual cost is determined at the time of invoicing.

The cost appears not to update on the order or invoice but when posted it does seem to grab and updated average cost. Oddly the cost displayed on SO and Invoice was the original average cost but when the invoice got updated the DTR shows the updated average cost (I made a receipt between the time I created the SO and the time it was invoiced so as to be sure average cost changed).