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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Item Charges Unit Cost
Small and medium business | Business Central, N...
Suggested Answer

Item Charges Unit Cost

(0) ShareShare
ReportReport
Posted on by Rikarddo 273

Hi all,

I'm facing the following problem: when a Purchase Order with a respective item has some charges, for example transport and insurance, and i invoice  the Purchase Receipt of the item and only one of the charges, the charge pending will affect my Unit Cost


How can i surpass this situation


The cost expected of the insurance is afecting the unit cost. The problem is without the invoice of the Transport Vendor i cannot invoice it.

Custo-produto.JPG

I mean of course the cost expected must affect the unit cost, but it affects wrong in these cases...

How can i surpass this situation?

I have the same question (0)
  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at

    Hi Rikarddo, 

    Thank you for posting.  I am not sure I am totally clear on the request. However, I believe that you desire to have Cost Amount (Expected) value for Charge (Item) lines that have been Received but not Invoiced. Unfortunately, Cost Amount (Expected) is only posted and added for the Item Lines for Purchase cost where only Receipt has occurred.  Item Charges are for costs added to acquire and receive the Inventory. However, unlike physical inventory for Items, there is nothing physically received, so no accrual of cost is recorded. Item Charges are only valued at Invoicing as Cost Amount (Actual).  See the following link for further Design details: https://docs.microsoft.com/en-us/dynamics-nav-app/design-details-expected-cost-posting

    If delays are expected in invoicing the Item Charge but cost is required to be applied immediately, I have recommended adding two G/L Account Lines to manage for the Uninvoiced Charge (Item) line. Basically, one G/L Account is a negative offset to the Charge (Item) Line. Then, add a second G/L Account Line to be Received and Invoiced when the actual charge Invoice comes in.  This allows for the Charge (Item) line to be Received & Invoiced along with the negative offset to G/L Account for Uninvoiced Charge item.  We then have the additional G/L Account Line to Receive and Invoice for the invoiced cost of the actual charge when the Vendor Invoice is issued.  Thus, we can get this Charge (item) line invoiced but delay the cost invoicing until the Vendor issues the invoice.

    I hope this helps clarify. Thank you for your post.  Have a great weekend.

    Best Regards,

    Tom

  • Rikarddo Profile Picture
    Rikarddo 273 on at

    Hi Tom and thanks for the explanation,

    Exactly as you said "Item Charges are only valued at Invoicing as Cost Amount (Actual).", but when in Cost Expected it is affecting my unit cost (i think it's a specification of my client).

    As this example shows, The unit cost should be 1,41 and not 1,44 because of the item charge in cost expected.

    Capturar111.JPG

    I know when the charge is invoiced all the sales will  have a cost of 1.41. I think this expected cost of item charges is affecting badly the unit cost.

    Shouldn't the cost expected prevent this?

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans