Recurring Sales Invoicing advice needed.

TPReggie
Member Posts: 29
Hi All,
I have a query around recurring invoicing in NAV. This is 2017 version. I am aware of the standard sales codes option. However I am not convinced this will meet the requirements we have - although it does allow for items to be created on a customer by customer basis, and allows you to determine the currency code, and when you run the "Get Recurring Sales Lines" function it allows you to specify a document date and a posting date. I cannot see how/where it can fill the other holes I have. Would any of you be able to advise on whether it can do this - and if not, whether there is a prebuilt NAV addon for recurring invoicing that would be worth my having a look at?
1. We are doing around 1000 invoices per quarter this is all for subscription licenses. Some are quarterly billing, some are monthly. I cannot see anywhere in NAV using Standard Sales Codes, and Recurring Sales Lines where I can set a frequency on either a line, or customer basis in order to allow me to specify which should be created monthly and which should be created quarterly.
2. Our invoices have a specific line of text at the top - along the lines of "Quarterly License Billing Q1 2018" which will change to Q2 2018 at next run and so on. I cannot see anywhere where this could be done. Testing seems to show that NAV simply adds the line items to the line and creates the invoice - and that is it.
Any ideas or suggestions on this would be gratefully received.
I have a query around recurring invoicing in NAV. This is 2017 version. I am aware of the standard sales codes option. However I am not convinced this will meet the requirements we have - although it does allow for items to be created on a customer by customer basis, and allows you to determine the currency code, and when you run the "Get Recurring Sales Lines" function it allows you to specify a document date and a posting date. I cannot see how/where it can fill the other holes I have. Would any of you be able to advise on whether it can do this - and if not, whether there is a prebuilt NAV addon for recurring invoicing that would be worth my having a look at?
1. We are doing around 1000 invoices per quarter this is all for subscription licenses. Some are quarterly billing, some are monthly. I cannot see anywhere in NAV using Standard Sales Codes, and Recurring Sales Lines where I can set a frequency on either a line, or customer basis in order to allow me to specify which should be created monthly and which should be created quarterly.
2. Our invoices have a specific line of text at the top - along the lines of "Quarterly License Billing Q1 2018" which will change to Q2 2018 at next run and so on. I cannot see anywhere where this could be done. Testing seems to show that NAV simply adds the line items to the line and creates the invoice - and that is it.
Any ideas or suggestions on this would be gratefully received.
0
Best Answer
-
An Order or Invoice uses the same tables and processing codeunits. So invoice is not a problem. Its a 1 day modication. Please investigate the code.5
Answers
-
I have customized the "blanket orders" with a frequency field and changed the way those default orders are created. But how do you do it now?
0 -
mdPartnerNL wrote: »I have customized the "blanket orders" with a frequency field and changed the way those default orders are created. But how do you do it now?
Blanket Order modifications wont work as this creates Orders, and we want to create Invoices directly, so will likely be more work unfortunately.0 -
An Order or Invoice uses the same tables and processing codeunits. So invoice is not a problem. Its a 1 day modication. Please investigate the code.5
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions