Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Adjust item cost using posted purchase invoice lines

Posted on by 147

Hi,

What would be the best way of allocating costs from one posted purchase invoice to articles on other posted purchase invoices?

The scenario is as follows. We receive invoices for the goods we ordered which we posted and paid. Then sometime later we received invoices for additional expenses (toll, shipping, packaging) related to previous invoice. These invoices are all posted which makes it a bit harder. We would like to allocate these costs to the articles beginning with the later posted purchase invoice.

What I found was the "Adjust Cost - item entries" function but that does not quite meet the requirements.

Thanks for any input! :)

Kind regards

  • Verified answer
    Rasmus B Profile Picture
    Rasmus B 147 on at
    RE: Adjust item cost using posted purchase invoice lines

    Thanks! I believe this is a good solution. I will mark as a verified solution once it is done :)

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Adjust item cost using posted purchase invoice lines

    Hi Rasmus B !

    You are correct. The item charge needs to be applied before the purchase invoice is posted. So you basically have two options. Revaluate the items through a journal or create a creditmemo for the purchase invoice and then post it again as item charge.

    In your situation i would go with revaluation as described in my blog.

    bc365.co/.../

  • Rasmus B Profile Picture
    Rasmus B 147 on at
    RE: Adjust item cost using posted purchase invoice lines

    Thanks for your answer. However this only works if the item charge invoice is open and not posted? In this scenario the line has been booked against an account. Sorry for the confusion.

    I did not find a solution other than doing it in a journal.

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Adjust item cost using posted purchase invoice lines

    Hi,

    Use Item charge  Functionality for allocating cost on the invoice.

    Regards

    Amit Sharma

    www.erpconsultors.com

    linkedin.com/in/amit-sharma-94542440/

    Press Yes if info is useful

  • Gavin Profile Picture
    Gavin 2,337 on at
    RE: Adjust item cost using posted purchase invoice lines

    Hi,

    This sounds like a good use case for Item Charges. 

    Using Item charges you can post costs via a new purchase invoice and apply them to previously posted receipts on a different purchase invoice. This creates additional value entries and will also update the Cost of Goods Sold if those items have been sold.

    You can read about it here: https://docs.microsoft.com/en-gb/dynamics365/business-central/payables-how-assign-item-charges

    Hope this helps

    Thanks

    Gavin

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Adjust item cost using posted purchase invoice lines

    Item charge is the functionality you should use for this. Please refer to this doc:

    docs.microsoft.com/.../payables-how-assign-item-charges

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans