Sage 100

5.2.4 standard. Average cost valuation for all items. User has 2 warehouses: CA and IL. In item maintenance, for item 048505, if you drill down on each warehouse, the average cost is $5.21 for whse IL and $3.50 for whse CA. There are no quantity on hand for CA and 100 on hand for IL. When a sales order is entered, the default warehouse is IL (the customer doesn't have any addresses in ship to address maintenance). On the lines tab, item 048505 is entered, and the unit cost shows $5.21. This item needs to ship from the CA warehouse. When the user changes the line item warehouse code from IL to CA, the line item cost remains at $5.21. We would expect it to change to $3.50, the correct cost for the item in the IL warehouse. If the user changes the default warehouse to CA on the SO header tab the deletes the line item and re-enters it, the correct line item cost of $3.50 is displayed. What is going on? A user may ship different line items from different warehouses. You shouldn't have to change the default warehouse to get the correct unit cost to display.

Wondering if the fact that there are no on hand quantity for the CA warehouse is causing the average cost to not update. Technically, although there is a value in the average cost for the CA warehouse, when there is no on hand quantity, the calculated average cost should be zero.

Could be. I need to test that. You should still be able to enter an order even without quantity on hand and get the correct cost. I have a call scheduled with Sage tomorrow morning.

In the mean time, a script could work around this issue by prompting if you want cost to come from the designated warehouse.

Spoke with Sheri at Sage. She is taking this to engineering and testing it further. Looks like it could be a bug.

Update from Sage: Doug, The issue you reported on the above case has been submitted to engineering. At this time it is under review and targeted for program fix on version 2019(6.10). It appears this has worked this way for many prior releases. After review it may be decided to correct this in earlier or later releases per the Supported Versions kb attached. Factors determining this are the scope of the fix needed, the urgency, severity, possible workarounds and frequency customers will experience this. I am going to close the support ticket at this time as there is no further action required by the support team. Please check the release notes of downloads to see if the fix for the attached kb is included. If you have further information on this issue or need status update, please contact support with the case number and kb or defect id.

When you post the invoice does it use the correct cost?

Yes it does if you have the correct warehouse on the line. In some cases the costs may be quite different depending on what warehouse the item is shipped from. The user should be able to determine if the profit margin of an item is sufficient. The cost updates correctly. The correct cost also needs to be communicated to the user so the correct price is entered.

BTW.. It took Sage engineering 2 months to verify what I showed tech support in 5 minutes.

and they'll probably call it a WAD because not enough people complained to inconvenience the stockholders...

Phil - They are acknowledging it as a bug. It is scheduled to be fixed in version 2019 (6.1) and may have a PU issued for previous versions. See my post from yesterday morning.

Targeted is not the same as scheduled. More wishy washy weasly..... Any one want to wager that it doesn't make it?

That doesn't surprise me Jeff. I would have better odds betting on the Bears winning the Super Bowl next year.

Well, Miracles DO happen, especially in Minneapolis!!

Amazing game yesterday. I am glad to see it.

It was awesome!!!! SKOL!!!

A friend of mine, Dave Huffman played for the Vikes for 11 years. They are my second favorite team. Too bad they are in the same division as the Bears. I love Mike Zimmer. He wrestled at Lockport High School (not far from Chicago) and played football / graduated from Illinois State.