Hi,
I would like to knwo where I can find the gross profit. At which table can I find it and which formular must I use (NL, NF or GL) do get the data into Excel?
Here some examples of what I would like to calculte:
1.) gross profit made with a certain range of products over a certain period of time
2.) gross profit made in a certain region over a certain period of time
A related question is, where do I find the gross profit in the Tabel Builder? I would like to extract data via Table Builder for pivot analysis. I would like to show sales and gross profit over time in a pivot chart.
I guess / hope that I get this problem solved by knowing the right table.
Thank you to everyone!
Kind regards,
Steff
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi SteffBin,
Unless you have made customizations to your NAV,gross profit isn't a standard field in the database.
You will need to use math to get what you need. You can take two NL(Sum) functions and perform math on them such as:=NL("Sum","Item Ledger Entry","Sales Amount (Actual)")-NL("Sum","Item Ledger Entry","Cost Amount (Actual)")
Please sign in to leave a comment.