You’re offline. This is a read only version of the page.
200
Hi,
If I am selling a bicycle to a customer for $500(line type item) and the delivery charges is $100. How shall i create the Sales Invoice in NAV to make sure the sales report (e.g Customer Top 10 List) to show only the sales amount which is $500?
Regards,
Magesen
*This post is locked for comments
Hi,
as Aleksandar said, it has to be customized. The Customer Top 10 list uses the "Sales (LCY)" field from the C/L Entries as data source, which is always filled with net sales amount (before VAT). You have other possible data sources for the sales amount, for exampe the G/L accounts where the actual sales you're interested in are posted to. This works if you post directly to G/L accounts or via items or resources. In the G/L entries, you also have the source type (customer) and source no. (which), so creating a Top 10 sales list on what you count as sales is no problem, however it must be created as a custom report.
with best regards
Jens
That is ok if the client use item type for actual sales lines but how about if the client use G/L Account for sales line and some other G/L account for delivery charges on same order? how not to reflect the delivery charges on sales report?
pls advise. Thanks.
You need to customize reports to calculate only for item type. Standard 'Top 10' work with total sales or balance.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (