Updating Replacement Cost

We are using HQ. I just realized that the 250 worksheet does not update the Replacement Cost in the Inventory Tab of the Item record. Does anyone know which worksheet, if any, will do this? Thanks.

Reply to
DDowningMO
Loading thread data ...

Reply to
Kaibin

HQ is synced. No error messages in the event log. Multiple 250's have been run on multiple items and the Replacement Cost has not been updated at the store level for any of the items.

"Kaib> 250 should do the job, any error message in the event log?

Reply to
DDowningMO

HQ is synced. No error messages in the event log. Multiple 250's have been run on multiple items and the Replacement Cost has not been updated at the store level for any of the items.

"Kaib > 250 should do the job, any error message in the event log? > you can try to create a 201 against that item to see if it's synced w/ HQ. > > "DDowningMO" wrote: > > > We are using HQ. I just realized that the 250 worksheet does not update the > > Replacement Cost in the Inventory Tab of the Item record. Does anyone know > > which worksheet, if any, will do this? Thanks. > >

Reply to
cptsoft

Thanks for the response Jeff, but I think you've misunderstood which field I'm asking about. We have our normal cost and average cost fields set up just fine. The field in question is the Replacement Cost field. It can be used simply as a referance field, similar to the MSRP field under the pricing tab. The Replacement Cost field can be found in the Item Properties under the Inventory Tab towards the lower right corner. The 250 worksheet does not appear to push this field down to the store level except upon initial record creation and I have not found another worksheet that included this field. The 302 would change the (average) cost field on the General Tab, something we never do except in extraordinary circumstances. Any ideas would be appreciated. Thanks.

"Jeff @ Check Po> DDowningMO,

Reply to
DDowningMO

I typically recommend to clients that the Supplier Cost (cost in supplier tab) be the one used as the "replacement cost", that is, if you were to create another PO for that item from that supplier, what cost should go on the PO.

Now, different folks have different approaches to what "replacement cost" means - some will think of it as an opportunity cost, others want it to be a standard cost for internal use only, etc.

If you are simply using this as a reference field, would the supplier cost suffice? You could also use a sql script to copy supplier cost into replacement cost.

hope this helps -

"DDown>

Reply to
convoluted

Thanks for the suggestion but we were needing a more static field then the Supplier Cost, which we have set to update when we receive PO's.

From the different responses, I guess the answer to my main question as to which worksheet sends the "Replacement Cost" field from HQ to the store level is that there isn't one. Seems a bit silly to me that MS has fields that can be changed in HQ but that those changes can't be sent down to the stores but then again, it doesn't surprise me either. If I'm wrong in my assumption, someone please correct me. Thanks to everyone for their advice.

DDowningMO

"c> I typically recommend to clients that the Supplier Cost (cost in supplier

Reply to
DDowningMO

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.