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

Notifications

Announcements

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
    31,586 Super User 2025 Season 2 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
    96,039 Super User 2025 Season 2 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

News and Announcements

Season of Giving Solutions is Here!

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,651

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 808 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 718 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans