Often a business needs to create a periodic based invoicing process for a customer or customers.  Standard NAV can accomplish this by using Standard Sales Codes.


To accomplish this the general tasks are:


How to: Create Multiple Sales Invoices Based on Standard Sales Codes


Microsoft Dynamics NAV 


You can use the Create Recurring Sales Inv. batch job to create sales invoices according to standard sales codes that are assigned to the customers and with posting dates within the valid-from and valid-to dates that you specify on the standard sales code. You can either run the batch job manually or schedule automatic runs using the Job Queue feature. For more information, see Use Job Queues to Schedule Tasks.


In the Standard Customer Sales Codes window, you can also specify a direct-debit payment method and a direct-debit mandate. The sales invoices that are created with the Create Recurring Sales Inv. batch job will then include information required to collect payment for the sales invoices with SEPA direct debit. For more information, see Collect Payments with SEPA Direct Debit.

To set up standard customer sales codes


  1. In the Search box, enter Standard Sales Codes, and then choose the related link.

  2. Define a standard sales code, for example for standard invoice lines for printer paper and cartridges, such as PRINTER EQUIPMENT. For more information, see How to: Set Up Standard Purchase Codes and Standard Sales Codes.

    Proceed to assign the standard sales code to customers who you deliver printer equipment to.

  3. In the Search box, enter Customers, and then choose the related link.

  4. Open the customer in question, and then, on the Navigate tab, in the Sales group, choose Std. Cust. Sales Codes.

  5. In the Standard Customer Sales Codes window, fill in the fields as described in the following table.


    Field
    Description
    Code
    Specify the standard sales code that you set up in step 2 in this procedure.
    Valid From Date
    Specify the first day when the Create Recurring Sales Inv. batch job can be used to create sales invoices.
    Valid To date
    Specify the last day that the Create Recurring Sales Inv. batch job can be used to create sales invoices.
    Payment Method Code
    Specify the payment method that you have assigned to the customer for direct debit collection. For more information, see How to: Set Up SEPA Direct Debit.
    Payment Terms Code
    Specify the payment terms that you have assigned to the customer for direct debit collection. For more information, see How to: Set Up SEPA Direct Debit.
    Direct Debit Mandate ID
    Specify the direct-debit mandate ID that you have set up for the customer’s bank account. For more information, see How to: Set Up SEPA Direct Debit.
    Blocked
    Specify that this standard customer sales code cannot be used.


  6. Choose the OK button.

  7. Repeat steps 3 through 6 for all customers that you want to create sales invoices for.


To create sales invoices based on standard customer sales codes


  1. In the Search box, enter Create Recurring Sales Invoices, and then choose the related link.

  2. In the Create Recurring Sales Inv. window, fill in the fields as described in the following table.


    Field
    Description
    Order Date
    Specify the date that will be entered in the Document Date field on the sales invoices that are created by using the batch job.
    Posting Date
    Specify the date that will be entered in the Posting Date field on the sales invoices that are created by using the batch job.


  3. On the Standard Customer Sales Code FastTab, in the Code field, enter PRINTER EQUIPMENT. This is the value that you specified in step 2 in the “To set up standard customer sales” section.

  4. Choose the OK button.

Sales invoices are created for the customers with the specified standard customer sales code, and any specified direct-debit information, for posting on the specified date.


https://msdn.microsoft.com/en-us/library/dn414553(v=nav.90).aspx