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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

purchase item charges link to sales value entries

(1) ShareShare
ReportReport
Posted on by 135
Hello, 
When we purchase product, we usually have 3-4 item charges related to the purchase. 
When we sale this product, we want to see each item charge category in value entries related to that sale. 
 
For example, we purchase item A - 1 pcs for 10$, transport charge was 1$, preparation charge was 2$ etc.
When we sell that particular item A in a month, we will see the actual cost of 13$. However, we want to see that in this 13$ we have transport charge of 1$ and preparation charge of 2$ in value entries. Right now there are 3 lines of value entries of 10$, 1$ and 2$ but what charge is responsible for 1$ and 2$ is not identifiable. 
 
Is it any workaround to understand in value entries related to sale which item charges were assigned to them on purchase?
 
Thanks in advance
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    32,390 Super User 2026 Season 1 on at
    You have three options:
     
    1. Look at the entries for each sales order one by one
    2. Create a custom report in jet reports or in Business Central that displays this information
    3. Don't use item charges and expense the additional charges directly to the GL; or use item charges but instead of looking at COGS, look at the purchasing GL Accounts
     
    To start, if you look at the Item Ledger Entries for the sales entry, you can click on Applied Entries. This will open the Item Ledger Entry for when you purchased the item for that specific sales order. On this entry, you can click Value Entries to view all the 3 amounts (10, 1, 2). 
     
     
     
     
    This is how you can make the connection manually for each sales order. You can then build a report in jet report, or in Business Central, to display this for you for multiple orders. The report would make this connection automatically for you. Out of the box, there is no report that displays this. Jet Reports is very useful in these situations for these sort of reports.
     
    Lastly, when you buy items instead of using item charges you can expense the additional costs directly to some separate account on the income statement. This way you don't capitalize these costs when the item is purchased and then book them to COGS when the item is sold, but they are expensed on the income statement when incurred. This will help with the breakdown, but its not the best solution. 
     
    Also, when you buy an item the system debits a purchases account in the GL. You can setup your items and item charges to debit separate accounts. This way you have the value of item purchases and item additional costs. These values are not really tied to COGS, as its the value of the purchased items rather than sold, but with some analysis you can make this connection perhaps. 
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,611 Super User 2026 Season 1 on at
    As far as I know, standard functions cannot be displayed directly. You need to check in Value Entries.
    And if you don't have Lot/Serial management, I think item A - 1 is not accurate. For example, it may be 1 purchased on June 1st, or 1 purchased on June 2nd.
    I don't know what your costing method is, but I think it is enough to look at the cost automatically calculated by the system.
     
     
    Hope this helps as well.
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,937 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,031 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 700 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans