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... / Item charges aggregate...
Small and medium business | Business Central, N...
Suggested answer

Item charges aggregate to "Cost of Sales" in P&L: unable to view breakdown of charges incurred

(0) ShareShare
ReportReport
Posted on by DJ999 10

Hi, we're setting up BC and we have lot of item charges for costs such as customs duties, shipping costs, surveyor fees, shipping insurance etc that we have set up.

We have set up posting groups to record these item charges into direct costs to their own codes but the system simply lumps them all in with the direct product cost and gives us one lump figure.

This means we cant look at our P&L and see how much we are spending on "shipping" for eg and prevents us being able to review and therefore manage our costs correctly. 

Any idea how we can get the system to show the breakdown in the P&L so that we can review and control these costs?

Thanks!

Darren

I have the same question (0)
  • Suggested answer
    Bryan Tschosik Profile Picture
    Bryan Tschosik on at
    RE: Item charges aggregate to "Cost of Sales" in P&L: unable to view breakdown of charges incurred

    Hi Darren,

    Thank you for your question posted in Communities.

    Question for you is where are you adding the Item Charges to?

    If you are adding them to the Sales Order, I believe the charge will be lumped into the Revenue.

    If you are creating a Purchase Invoice, add the item charge, and assigning the Item Charge to the Sales Shipment, this cost will be updated within the subledger Inventory Table 5802 'Value Entry' (and Table 32 'Item Ledger Entry') in the 'Cost Amount (Non-Invtbl.)' field....that will hit an expense account typically on the P&L...via Purchases Account within General Posting Setup.

    Hope that helps, thank you! :)

    Bryan

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Item charges aggregate to "Cost of Sales" in P&L: unable to view breakdown of charges incurred

    Charge_2800_Item_2900_-Process.pdf

    Darren,

    To add to Bryan's reply, attached is a Charge(Item) Training manual I use for my customers. It helps on the Purchase and Sales side.

    Hope this helps.

    Thanks,

    Steve

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,330

#2
Sumit Singh Profile Picture

Sumit Singh 2,738

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,546

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans