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

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

RomRyan,

The item unit cost will be calculated while posting the invoices in GP based on the Inventory Valuation Method. So, the item unit price may differs from unit cost of the items.

Item Valuation Method is a big concept. For your reference, please have a look on the below links.

mahmoudsaadi.blogspot.in/.../inventory-valuation-methods.html

support.microsoft.com/.../865901

Hope this helps!!!

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Check out the IV10200 table which is the item purchase receipts table.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

The SOP10200 and SOP30300 tables will tell you when it was sold and the IV10200 table will tell you when you received the goods.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

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

Hope this helps!!!

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

I have seen non of purchasing table that has DEX_ROW_TS

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No