Microsoft Dynamics GP (Archived)

Changes in Price/Cost

(0) Share

Report

Posted on by Romryan

Everyone,

I have a client who always want to sell items at a price sames as the cost price.

Sometimes, the selling price changes and to a price different different to the cost price.

What could be the cause of this?

Secondly,which table from purchase module or inventory module records the time stamp when stocks are bought?

I checked on tables but I couldn't get one but on sop tables sop10200 has it so I know the exact time the item was sold in the system.

RomRyan

*This post is locked for comments

All responses (11)

Answers (0)

Romryan on at

Like (0)

Report

RE: Changes in Price/Cost

Leslie,

Thanks for your suggestion how do I set up or enable the serial number .if a receipt of an item and sale happen the same day how can I know which preceded the other on item stock inquiry or iv30300?.

Thanks,

RomRyan
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Changes in Price/Cost

Ryan,

If you want the price to = the cost, consider using serial numbers. Unless you time your receipts and your sales perfectly, I do not know another way to accomplish your objective.

Kind regards,

Leslie
Romryan on at

Like (0)

Report

RE: Changes in Price/Cost

Hi,

I have this scenario item X has

Standard cost- 2.10

Current cost- 2.22

List price -2.10

Valuation method -average perpetual

Price method- markup + current cost

GL alc for sales and cost of good sold should be same meaning the cost price and selling price are exactly the same.

The similarity on the cost price and selling price goes well if receipt is done when the stock is zero but if receipt is done when stock is not 0 then issue price (selling price) on the issue just before the receipt changes and the subsequent stock movements will take the new price.

In my item X the item movement was cost of 2.10 in and out (selling price and unit cost) until a receipt was done while stock was 40 items, when an issue that has the same date as the receipt and appearing just above the receipt in my item stock enquiry the unit cost changed to 2.17 and the next movements had 2.17.But in a situation where stock of X is zero the receipt won’t affect the unit cost.

Now my questions are:-

1. Given my scenario, how was 2.17 computed?

2. When both receipts and sales are on the same date, how can I know which preceded the other as not RCT table has time stamp?

3. When RCT and sales are posted, does one them delay when updating such that a sale batch might update the stock before the receipt one?

4. How do I need to do to ensure no incidences of selling price and cost price differing?

Thanks,

RomRyan
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Changes in Price/Cost

For the time stamp, you can check the SEE30303 table on the inventory level (in case you have deployed the historical inventory trial balance).

Since cost changes according to the valuation method, keep in mind that the price list and the price method is the ultimate solution for such cost changes.

Your feedback is highly appreciated,
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Changes in Price/Cost

The field DEX_ROW_TS is not available from all the POP table. It is available on few of the POP tables(eg. POP10100, POP10110, POP30100, POP30110, etc.,,).

Please have a look on the POP tables from below link and check where is the DEX_ROW_TS field available in POP.

dyndeveloper.com/DynTable.aspx

Hope this helps!!!
Romryan on at

Like (0)

Report

RE: Changes in Price/Cost

I have seen non of purchasing table that has DEX_ROW_TS
soma 24,410 on at

Like (0)

Report

RE: Changes in Price/Cost

You can also track the Inventory In/Out details from the table IV30300.

Hope this helps!!!
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Changes in Price/Cost

The SOP10200 and SOP30300 tables will tell you when it was sold and the IV10200 table will tell you when you received the goods.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Changes in Price/Cost

Check out the IV10200 table which is the item purchase receipts table.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Changes in Price/Cost

A simple thing you can do is to set the percent markup or margin to be zero. This way as the cost changes, the sell price will change with it. Now there is no way to make sure they are always the same due to stock levels, unless you turn on serial or lot number tracking. What is your current price method? Does any one adjust the pricing method per item?