Item Unit Cost on Sales Return in NAV 4.0

Beatrice

Hi Everyone,

I need clarification on the following:

Item A with a Unit Cost of 100 LCY is sold to a customer today.

After a week, the same customer returns Item A because it is faulty.

On the day the item is returned, the Unit Cost is 110 LCY on its Item Card.

A sales credit memo is entered for the returned item. In the Appl. -from Item Entry field,we select the item ledger entry to which this return applies.

When the sales credit memo is posted, we find that system takes Unit Cost as 110 LCY instead of 100 LCY.

In a normal case, the system should have posted the sales credit memo with the original cost 100 LCY.

Please advise.

Thanks in Advance.

Beatrice.

chengalasettyvsrao

check the Item Ledger entries / value entries for that entry.

Dont consider the Unit cost of that item from item master.

Beatrice

Thanks a Lot for your reply.

I have checked the Item Ledger entries / value entries for that entry, the Cost Amount (Actual) is 110 LCY instead of 100 LCY.

Automatic Cost Adjustment was already set to Always. I have also launched the Adjust Cost Item Entries batch job and Post Inventory Cost to G/L, but nothing has been updated...

dimus

Check an Item Application Entry for the return Item Ledger Entry and see where it's been applied to.

chengalasettyvsrao

did u test this scenrio in cronus company. ?

what about the result ?

Beatrice

Hi,

I have tested the results in Cronus database and it is working fine.

But then for what reasons could this happen in our customer's database?

Thanks in Advance.

Regards,

Beatrice.

jannestig

What costing method is the item using?

under sales and marketing setup is your exact cost reversing set to yes?

Beatrice

The Costing Method is Average for the Items.

Beatrice

Exact Cost Reversing is also checked on Sales and Receivables Setup.

chengalasettyvsrao

Did u check the Previous transctions ?

Have u done any bad customization ?