Dear experts :)
I am new to this forum, but have been working with implementing Dynamics NAV in our small company from business side for some time now.
Currently, I am trying to figure out the following, which I hope that you can help me with:
I am planning on using Power BI to do evalutation on how much we earn (or lose) on each sales invoice in the end after costs have been assigned.
Will do that by using the value entries.
The final cost amount of goods on a sales invoice will be the sum of purchase price + handling charges + freight in + other.
Purchase costs will be assigned through purchase order/invoice, and the rest will be assigned later as item charge.
When I evaluate profitability per sales invoice in the end, it would be nice, if I could identify, which cost line in the value entries relates to which item charge or purchase invoice.
Right now I have several lines with cost amount, but the description is the same on all of them - the sales invoice document no. That does not help me much.
Is it perhaps possible to carry over the item charge description to the matching cost amount line in value entries?
Hope that I explain it well enough. If not, just let me know, and I will try again :-)
*This post is locked for comments
I have the same question (0)

Report
All responses (
Answers (