Corporate blunder

is there anyway to reset the POS retail price to what is was before a
download from the master?
we have 40 stores that control there prices apart from the corporate database,
corporate accidently launched a worksheet incorrectly and it set about 4000
items at all the stores retail price to the corporate master, is there a roll
back at the store level, or a log to find out what items were changed and
from what to what?, or better yet change them back?
RMS v2
Reply to
hi, in HQ there is table called ItemDynamics which has the snapshot for the last prices: SnapshotPrice,SnapShotPriceA...C
I belive and think this will help you , do you know how to export the table or may be you can export the table to text file and import the price back to HQ and upate all the stores. If need any help in this regards let me know , I am for you to help you out.
Akber Alwani
Reply to
Akber Alwani
hi Yes it has storeID as columns so you can restrict by store ID: below are the fields available: ID ItemID StoreID TaxID Quantity QuantityCommitted ReorderPoint RestockLevel LastReceived LastSold SnapShotQuantity SnapShotQuantityCommitted DeltaQuantity DeltaQuantityCommitted SnapShotTime DBTimeStamp SnapShotPrice SnapShotPriceA SnapShotPriceB SnapShotPriceC SnapShotSalePrice SnapShotSaleStartDate SnapShotSaleEndDate SnapShotCost SnapShotLastCost SnapShotReplacementCost SnapShotPriceLowerBound SnapShotPriceUpperBound SnapShotReorderPoint SnapShotRestockLevel SnapShotTaxID
Reply to
Akber Alwani

Site Timeline Threads

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.