Store Prices stores where

(0) Share

Report

Posted on by Shane O' Malley

380

Hi,

I was wondering if anyone knew where the Store prices stored. When we go into HQ we can see the store prices and the update that brought it in allowed us to have different prices for different stores. However those prices are not stored in the dbo_item table and it does not seem to be the _dbo_ItemDynamic either. (It is stored there as part of the snapshot but sometimes that does not match with what we can see in HQ.

Is there a new table that i have not spotted yet.

Thanks

Shane

All responses (4)

Answers (0)

ToddB on at

Like (0)

Report

RE: Store Prices stores where

Hi Shane,

Is Store 1 still an active store?

When was the last time a 401 was run for Store 1?

Is the price correct at Store 1?

If you update the price (for store 1), and then change it back to 105 (or the expected price), does the price reflect correctly in the ItemDynamic table?

NOTE: In testing, I updated the price for store 2 to be 10.00 ; and the changed price was immediately showing in the ItemDynamic table:

Once a 401 was subsequently run, the SnapShotTime was updated.
Shane O' Malley 380 on at

Like (0)

Report

RE: Store Prices stores where

Thanks Todd. I thought that myself but found a few examples of the entry in Item_Dynamic being different than shown in the HQ Manager for store pricing.

I have done a query to identify cases where the normal price for the item (from the item table) is different than that shown in the ItemDynamic table. In some cases there is nothing in the prices (ItemDynamic) because the item was setup after that particular store was made inactive. However in HQ it still shows a price for it. Also cases where HQ shows a different price than in the table.

The second table is from the item_dynamic table copied to excel. As you can see the price for Carrickmines (store 1) is zero in HQ but 105.00 in the table. I was assuming that since the snapshot is old (Nov 2020) that there must be another record somewhere of Store Prices and the snapshot prices have not updates because there has been no stock holding or movements.

Thanks

Shane
ToddB on at

Like (0)

Report

RE: Store Prices stores where

Hi Shane,

The ItemDynamic table should store the Price per store.

In running the following queries, I can see that for Item ID 1, the correct Store price is showing in the ItemDynamic table:

select * from itemdynamic order by itemid

select * from item order by id

Here is what this shows in HQ Manager for the Store pricing:

_______________________________________________

Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs

This is less than 3 months from now; and you can continue using RMS after this date but technical support will not be available.

I would recommend checking with your partner in regard to what they may recommend as a replacement system after the extended support end date.
Shane O' Malley 380 on at

Like (0)

Report

RE: Store Prices stores where

Apologies for the terrible wording of the heading. "Store Prices" stored where?