web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Adjust item cost using...
Small and medium business | Business Central, N...
Answered

Adjust item cost using posted purchase invoice lines

(1) ShareShare
ReportReport
Posted on by Rasmus B 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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,043 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

  • Gavin Profile Picture
    Gavin 2,502 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
    Amit Baru Profile Picture
    Amit Baru 3,037 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

  • 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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,043 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/.../

  • 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 :)

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans