Variance in unit cost for Transfer entry

(0) Share

Report

Posted on by Refeesh Ali

5,201

Hi,

i am facing a problem in last month transfer entries the unit cost is varying. i checked in my PO and Receiving entries their is no price changes and my transfer entry screen the unit cost is disable.it will act by default.

please help me how the variance happen for this particular items and advice me how i can recover and prevent for future.

please treat as top urgent!!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

Hi, not enough information I'm afraid. How are you valuing your stock? FIFO Perpetual etc.

Have you checked the stock layers? Stock will be transferred from the oldest available layer if you are using FIFO.

Are these transfers between inventory sites? or inventory decrease transactions?

Ian.

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

Hi Ian,

we are valuing our stock using average perpetual method.we are making transfers between inventory sites.

Refeesh

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Look at your Item Transaction Inquiry window and analyze what happened between 7/26 and 7/28. Something changed the unit cost on the 27th and on the 28th and it looks like it changed by SR20.00 each time.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I saw this issue with many clients so far, if you are sure that all transactions are correct and your item transactions costs are correct, then you might need to zero out your item quantity and reimport back with the correct cost, it might be an incompleted record information in IV10200 that cause this cost fluctuation.

However, I am in KSA these days, feel free to call me if you need any help.

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

hi mohammad,

In the table IV10200, i found variance in the data which i attached as a picture.

i noticed that after post one PO or RCT the cost are changing and in the RCT i found their is no data.

please advice me what happens and how can i solve this issue.

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

The below is the clear data

Was this reply helpful? Yes No
Zhigang Lu 795 on at

Like (0)

Report

I think this is rounding problem.

If the unit cost is 0.37 per bottle. The totol 3000 bottles(150Box/20) should be SR1,110.00. However the actual total is SR1,100. SR10.00 less. The system will assign the unit cost as follow. The last bottle cost is assigned to $20.36.

2999 * 0.36 = $1,079.64

1 * 20.36 = $20.36

$1,100.00

The solution is, if you decide the unit cost is 0.37 Per Bottle or 7.40 per Box/20, when you get the extended cost SR1,110.00, you need add SR10.00 to trade discount in order to match the actual total SR1,100.00

Was this reply helpful? Yes No
Refeesh Ali 5,201 on at

Like (0)

Report

dear all,

i badly need to change the cost in my old transaction which i mentioned earlier. how i can do?which table?these are posted transactions. please advice me to recover from this issue.

pls help

Was this reply helpful? Yes No