Price is calculating wrongly in sale order level

[Former Member]

HI

I Maintained Conditon Record for PC is 30 Rs

I created Sale order with 100 PC's but system is calculating Net value 3

I found that in sale order level pricing as well as conditon reocrd level Per unit PC its picking 1,000 but amount column its showing 30.00

if enter the price manually its working fine but picked from conditon record is the problem i.e per unit decimal points

i cheked user file 1,2345.89 (X)

What is the configuration is required to achive this ?

[Former Member]

hi

check is there any different sale order unit is maintained in the material master

[Lakshmipathi]

In condition record, what value is there under the tab "per"

G. Lakshmipathi

[Former Member]

Hi

Per Tab 1,000

and also no conversion factor

[Lakshmipathi]

Go to condition tab of that sale order and block that condition type and clck on blue lens at bottom left. You can see now a tab "Condition values" where you can check how system has calculated.

G. Lakshmipathi

[Former Member]

HI

Under Condition Value tab

Amount     30.00 INR   /  1,000 PC

Condition base value   100.000 PC          INR

Condiiton Value   3.00 INR            3.00         Alt cal Type 17

but system supposed to take Conditon Value 30*100 = 3000 but it is taking 3.00

Guide me

[former_member184555]

>

Amount     30.00 INR   /  1,000 PC
> 
> Condition base value   100.000 PC          INR
> 
> Condiiton Value   3.00 INR            3.00         Alt cal Type 17

It seems the condition record is maintained per 1000 PCs and hence it is calculating the condition amount in the document as 3.00 per 100 PCs (as 30.00 INR per 1000 PCs). Miantain the condition record as 30.00 INR per 1 PC and check creating another sales order or update pricing in the same sales order.

Thanks,

Ravi

[Former Member]

Hi

In condition Record , i just entered the Sales org., Distribution channel , Material code and Amount (Key combination is Materail )

I didnt touch the Per unit tab by default its picking 1,000 PC

How to solve

[former_member212699]

Hi

Anuradha please go to conditions record and check quantity as you supposed to tell only 100pc,but you mentioned 1000pc ,so plz change the qty to 100 pc and give 30rs to it and check the result.

[former_member212699]

check settings in mm settings in accounting what u have gave in i mean in standard price tab

[Former Member]

HI

My Question is why system is picked 1,000 PC rather than 1 PC where is the settings related to that

In Material Master my standard Price is 3.00

[former_member184555]

My Question is why system is picked 1,000 PC rather than 1 PC where is the settings related to that 

Because the condition record is maintained as 30.00 INR 'PER' 1000 PCs

[Former Member]

HI

Sorry i think your didnt understand my question

Why system is pciked by default 1,000 PC , why it is not picked 1PC

where is the configuration settings

[former_member184555]

why it is not picked 1PC

Do you have a condition record maintained for 1PC? How can the system pick 'condition value' for 1PC when there is no condition record for 1PC?

If it is not clear and if your question is different...please explain the scenario in detail.

Are you working on IDES?

[Lakshmipathi]

It is very clear now. You have maintained price of 30 per 1000 which means, per piece, it would be 0.30 only and for 100 nos., the net value would be 3.00 which the condition value tab showing.

G. Lakshmipathi

[Former Member]

HI

Per 1 PC = 30 Rs

At the time of creating the condition record its picked

Material     Amount   unit      Per         unit 
ABCD         30.00      INR     1,000      PC

why system by defauly picked 1,000 PC , it should be 1 PC

I created sale order for 100 PC , its calculated 3.00 , chekc my above posts

I hope you understand my problem

[former_member184555]

I understand that you thought of maintaining the condition record as 30.00 INR per 1 PC and instead created the condition record as 30.00 INR per 1000 PC.

Goto VK12 and change the condition record in the column 'PER' changing the value 1000 to 1. Save the condition record and create a new sales order.

Are you working on IDES?

[Former Member]

HI

I am not working on IDES ,

Rather than changing the manually , we can enter the price in sale order manually

if i enter manually its working

But My Doubt is why system is picked 1,000 PC rather than 1 PC ? where is the control ?