Dynamics 365 Business Central App – Recurring Invoice
Setting up the Recurring Detail Documents app is designed to be simple and easy, leveraging many of Dynamics NAV 2017’s built-in functions. Start by using the Search function and find the Recurring Document Number Series Setup and click the link. The Recurring Detail Documents app allows for the creation of both purchasing and sales documents, with the option for orders and invoices for both series. To add a purchase invoice number series, just make the selections using the drop-downs and then either select an existing number series or create a new one unique to these documents. Click on the New button to create a new number series. Here, we can see all four Recurring Detail Document types have been created and assigned a unique number series. Set up for the app is now complete.
Use the Recurring Detail Documents to create a sales invoice for a monthly subscription. To access the Recurring Detail Documents, click on the department’s link, and then go to the Sales and Marketing link. Then under the Tasks list, click on the Create Recurring Sales Document link. This will open a list view of all the documents being managed by the app. Adding a new document is started in a blank line. Document type can either be order or invoice. Enter document type in the Sell To Customer and the app will add in the next number based on the number series you chose in the setup. Enter the start and end dates as well as the recurring frequency. The posting description will default to the document type and number providing an audit trail back from posted invoices to the original recurring detail document.
Next, click on the number zero under the Lines column. This will open the line details for your document. In the line detail list, the view is automatically filtered to show just the lines for the chosen document. Next, we begin to add in the line details. In this invoice, our client is being billed for a monthly subscription: the hardware rental and the support contract. This structure will be consistent for the life of the contract or the quantities may vary from month to month.
Once the detail lines have been added, it’s time to generate the sales order. Recurring Detail Documents app will provide a status update after each generation is ran. The sales header view will show the results both posted and unposted. See at a glance the current status of all your recurring detail documents. After generating the recurring order, we can now see the document in the sales order list. All the details have been pulled on to the sales order, and here, the individual quantities could be adjusted if needed.
Creating a recurring detail document for purchasing is no different from creating a sales document. Navigate to Departments and the Purchasing and Order Processing. Click on the link to create recurring purchase documents. As with sales, we have the choice of order or invoice. After entering the header details, click on zero under the Lines column; enter the details for the purchase order. In this case, the recurring document is set at track Rent by Department. Once the recurring purchase order has been created, it will need to be generated.
The native NAV Job Queue can be leveraged to run the Generate Routine automatically. The Recurring Detail Documents app includes predefined job objects that can be selected and ran automatically.
Designed to add line item detail, enhance audit ability and ensure accuracy, the Recurring Detail Documents app, powered by TMC, offers a simple and easy way to get better results.
Thanks for watching the video, TMC is here to help. For specific information, feel free to contact us.