Skip to main content

Next Generation - Set up Multiple Due Dates for sales and purchase ledgers

Multiple Due Dates is a subscription and needs to be enabled for your database. Once enabled, it needs to be set up in Sales Ledger or Purchase Ledger Options found in the System module which is Security Profile driven.

Transactions affected by Multiple Due Dates

  • Sales and purchase ledger invoice.

  • Sales and purchase orders.

Set up multiple due dates for sales ledger

  1. Click System then click Options.

  2. Click Sales Ledger Options.

  3. Under the Due Dates section, select the Use Multiple Sales Ledger Due Dates option.

  4. If required, select the check box Dates relative to Invoice Process Date in Sales Order.
    Note: If you leave these check boxes not selected, the due dates are relative to the order date. If you select the check boxes, the due dates are relative to the invoice Tax Point date.

  5. Enter the number of days or weeks or months that you want to be the default.
    Note: If you set a default timescale, you can still amend these manually on the invoices when entering a transaction.

  6. Click Save.

Relative to Tax Point Date for Sales Ledger is off

  • When you invoice a sales order where Multiple Due Dates is selected and the number of payments is not zero, a set of payments is generated for the sales transaction.

  • If you invoice the full order, then the values saved to the sales transaction is no different to those entered on the order.

Relative to Tax Point Date for Sales Ledger is on

  • When you invoice a sales order where Multiple Due Dates is selected and the number of payments is not zero, a set of payments is generated for the sales transaction.

  • The date of each payment is recalculated.

  • The Start Date is set to the Tax Point Date entered when processing the invoice.
    Note: Tax Point Date is the date when you receive the payment.

  • The date of the first payment is set to the new Start Date and the date of each subsequent payment is calculated using the new Start Date.

Set up multiple due dates for purchase ledger

  1. Click System then Options.

  2. Click Purchase Ledger Options.

  3. Under the Due Dates section, select the Use Multiple Purchase Ledger Due Dates option.

  4. If required, select the check box Dates relative to Invoice Process Date in Purchase Order.
    Note: If you leave these check boxes not selected, the due dates are relative to the order date. If you select the check boxes, the due dates are relative to the invoice Tax Point date.

  5. Enter the number of days or weeks or months that you want to be the default.
    Note: If you set a default timescale, you can still amend these manually on the invoices.

  6. Click Save.

Dates relative to Invoice Process Date in Purchase Order is off

  • When you invoice a purchase order where Multiple Due Dates is selected and the number of payments is not zero, a set of payments is generated for the purchase transaction.

  • If you invoice the full order, then the values saved to the purchase transaction is no different to those entered on the order.

Dates relative to Invoice Process Date in Purchase Order is on

  • When you invoice a purchase order where Multiple Due Dates is selected a the number of payments is not zero, a set of payments is generated for the purchase transaction.

  • The Start Date is set to the Tax Point Date entered when processing the invoice.

  • Note: Tax Point Date is the date when you enter the payment.

  • The date of the first payment is set to the new Start Date and the date of each subsequent payment is calculated using the new Start Date.

  • This rule is applied when processing invoice from the Outstanding Purchase Orders enquiry or when invoicing via matching a purchase order to a purchase invoice register entry.

Did this answer your question?