Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Correct wrong unit cos...
Microsoft Dynamics NAV (Archived)

Correct wrong unit cost from purchasing how

(0) ShareShare
ReportReport
Posted on by ahmed barbary 4,548

I have item his name iron his method cost is average i do only in it purchasing it represent in my company as spare partes i only made purchase to it(no consuming no sales no production) I have transaction to it from 01-09-12 until now like following

posting date   unit cost   quantity

 01-09-12         200              1

01-09-12         400               1

01-11-12        300                1

 0-12-12        600                 1

The actual unit cost is 400 and another values is wrong what i want to do is make unit cost to this items for all unites purchasing is 400 meaning i need to correct (200,300,600) to 400 what i do to change this values

*This post is locked for comments

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    When i add one quantity as positive adjustment it come as  following :

    quantity          invoiced           remaining

    1                        1                            0

    This not affect to non invoiced quantity 0

    although I make adjust cost item entries

    what i do are what i make is true

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    can if possible any one reply for me in above question

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    Are make purchase order receipt and invoicing to 1 quantity is what you mean

    .if this what you mean why entry not affected when i add receipt and invoice to 1 quantity .

    it affect on another entry .

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    what i mean to be clear when i add purchase order receipt and invoice for 1 quantity to this item it will add another entry as following :

    quantity      invoiced (qty)      remaining

    1                        1                            0

    but not modify the entry that need to be invoiced

    so that

    this what you mean or what

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    Thank you for reply

    your are mean that i make new purchase order from first to one quntity

    or there are another way to modify  this entry from 0 to 1 fror the entry not invoiced.

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Correct wrong unit cost from purchasing how

    Your images show that you have uninvoiced quantity.

    You need to post invoice for remaining quantity on first entry. After that you need to start Adjust Cost - Item Entries.

    On the end of process, you must get: Increase Quantity/Values and Decrease Quantity/Values the same and As of 31/12/12 will be 0/0. Also, Cost Posted to G/L will be 0.

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    www.mediafire.com/.../1234bb.bmp

    the link above show print screen from inventory valuation 1001 with  marked Include Expected Cost field on Options tab?

    thanks for interest

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Correct wrong unit cost from purchasing how

    I look at Inventory Valuation report, but can you make print screen with marked Include Expected Cost field on Options tab?

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Correct wrong unit cost from purchasing how

    Thanks for interest

    see here my situation

    in item ledger entry table my entries as following :

     date               item        location      qty        invoiced    remaining     cost perunit

    13-09-12        vary1         jay              1             0                 1                     74

    13-09-12        vary1         jay              1              1                 1                     0

    my entries as above

    I reevaluate second entry to 0 cost it accept

    but in

    first one entry  not accept and still 74

    after this i make adjustment to quantity in inventory to 0 in inventory field in card

    and make adjust cost-item entries .

    After this i run in inventory revaluation report 1001 it give me value -74 and cost posted to g/l -74 although inventory quantity is 0 after i make adjustment to it.

    my inventory revaluation report as below :

    www.mediafire.com/.../aaa.bmp

    and if you need any detail extra tell me and and i will clear to you

    thanks

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Correct wrong unit cost from purchasing how

    I am not sure what is your problem.

    If I undesrtand, you bought item (average cost type) with quantity 1 (receive and invoice). After that, you made revaluation to value decrease from 40 to 0. And after that, you made Negative Adjmt. for this item. Am I correct?

    What is values and quantites in report Inventory Valuation for this item?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans