Feature Overview
The Invoice Creation feature turns subscription orders into actual sales invoices. It reads all subscription lines where the Next Invoicing Date falls on or before a chosen cut-off date, generates one or more sales invoices with the correct line amounts and period dates, updates each subscription line's dates, and optionally opens the invoice list for review.
Invoice creation can be triggered in two ways. Manual creation is initiated directly from a Subscription Order or from a batch report — useful for testing, ad-hoc billing, or handling exceptional cases. Automatic creation via the Job Queue runs on a configured schedule and processes all subscription orders in one unattended batch — the standard production approach for organisations that invoice regularly.
Both methods share the same underlying logic: they apply date formulas to calculate the include-up-to date, posting date, and document date; then they process each eligible subscription line and generate invoice headers and lines. The Invoice Per setting controls how lines are grouped: per customer (one invoice per bill-to customer across all their subscriptions), per subscription order (one invoice per order), or per line (one invoice per subscription line). A description text based on the subscription period and item translation is automatically appended to each invoice line.
Key Facts
| Topic | Detail |
|---|---|
| Manual invoice creation | Create Invoices action on Subscription Order, or via batch report |
| Automated creation | Subscription Job Queue Setup |
| Invoice grouping options | Customer, Subscription, Line |
| Date control (manual) | Include up to date, Posting Date, Document Date — entered at run time |
| Date control (job queue) | Controlled by date formulas: Include Up To Date Formula, Posting Date Formula, Document Date Formula |
| Status tracking (job queue) | Last Run Date Time, Last Run Status, Invoices Created Last Run |
| Invoice line description | Auto-generated from Subscription Text Translation; requires Default Subscription Text Language to be set |
Getting Started
- Ensure Subscription Setup is complete: Subscription Nos., Posted Subscription Nos., and Default Subscription Text Language must all be filled in.
- Ensure at least one Subscription Order exists with a line that has a Next Invoicing Date populated.
- For manual creation: Open the Subscription Order and choose Create Invoices from the action bar. On the request page, confirm or adjust: Include up to date (lines with Next Invoicing Date up to and including this date are processed), Posting Date, Document Date, Invoice per, and an optional Invoice Line Comment.
- After running, the system offers to open the invoice list so you can review and post the created invoices.
- For automated creation: Open Subscription Job Queue Setup (from Subscription Setup → action bar, or by searching). Configure the date formulas, invoice grouping, and schedule, then enable the job queue. The first time you enable it, the job queue entry is created with status On Hold — you must manually open the job queue entry and set it to Ready to activate automatic execution.
Related Features
Invoice Creation reads data exclusively from Subscription Orders — it cannot create invoices without correctly configured subscription lines. The quality of the output (correct periods, correct amounts, correct partial-period adjustments) depends entirely on how the subscription lines are set up.
The Subscription Text Translation feature provides the description lines added below each invoice line. If no translation is found for the customer's language, the fallback text from Default Subscription Text Language in Subscription Setup is used. If that is not configured, invoice creation will fail with an error.
If Master Data Information is installed, master data values from the subscription order header and lines are automatically transferred to the generated invoice header and lines during invoice creation.
User Stories
US-01: Run invoice creation manually for a single subscription order
As a Sales Order Processor
I want to manually trigger invoice creation for one specific subscription order
So that I can create and review the invoice before committing to a full automated batch
Setup:
- Open the relevant Subscription Order.
- Choose Create Invoices from the action bar.
- On the request page, review and confirm the following fields:
- Include up to date: lines with Next Invoicing Date on or before this date will be included.
- Posting Date: the posting date to set on the created invoice(s).
- Document Date: the document date to set on the created invoice(s).
- Invoice per: choose Customer, Subscription, or Line.
- Invoice Line Comment: optional text added as a heading line on each invoice.
- Click OK. The system creates the invoice(s) and offers to open the Sales Invoice List.
US-02: Group multiple subscriptions for the same customer onto one invoice
As a Sales Order Processor
I want to have all subscription lines for the same bill-to customer combined onto a single invoice
So that the customer receives one consolidated invoice instead of one per subscription
Setup:
- In the Create Invoices request page (or in the Job Queue Setup), set Invoice per to Customer.
- When invoice creation runs, all eligible subscription lines for the same bill-to customer are grouped onto one invoice header, regardless of how many subscription orders they come from.
Note: If different subscriptions for the same customer have different sell-to customers, the sell-to information on the invoice is set to that of the bill-to customer.
US-03: Create one invoice per subscription order
As a Sales Order Processor
I want to generate one invoice per subscription order (not one per customer)
So that each subscription is billed separately, making it easier to identify what each invoice relates to
Setup:
- In the Create Invoices request page (or in the Job Queue Setup), set Invoice per to Subscription.
- When invoice creation runs, one invoice header is created per subscription order. All eligible lines from the same order are placed on the same invoice.
US-04: Create one invoice per subscription line
As a Sales Order Processor
I want to generate a separate invoice for every individual subscription line
So that each billable item is invoiced independently
Setup:
- In the Create Invoices request page (or in the Job Queue Setup), set Invoice per to Line.
- When invoice creation runs, each eligible subscription line generates its own invoice.
- Ship-to address information from the subscription order is also copied to the invoice when this mode is used.
US-05: Add a heading comment to all invoices created in a run
As a Sales Order Processor
I want to add a standard comment line at the top of all invoices created in a batch
So that each invoice includes a recognisable reference or description for the customer
Setup:
- In the Create Invoices request page, enter text in the Invoice Line Comment field (up to 50 characters).
- When invoice creation runs, this text is inserted as a description line at the top of each created invoice header.
US-06: Set up the Subscription Job Queue for automatic nightly invoice creation
As a IT Manager
I want to configure the job queue to automatically create subscription invoices each night
So that invoices are generated without manual intervention on the scheduled billing day
Setup:
- Open Subscription Job Queue Setup (from Subscription Setup → Subscription Job Queue Setup, or search).
- Set Include Up To Date Formula — e.g.
<1M+CM>to include lines due up to the end of next month. - Set Posting Date Formula — e.g.
<CM+1D>to post invoices on the first day of next month. - Set Document Date Formula — e.g.
<0D>to use today's date. - Set Invoice Per to the desired grouping (Customer, Subscription, or Line).
- Optionally set Invoice Line Comment for a standard comment on all invoices.
- Under Schedule, set Earliest Start Time if the job should not run before a certain time of day.
- Set No. of Minutes between Runs (e.g. 1440 for once per 24 hours) and check the appropriate Run on [day] checkboxes.
- Enable Configure Job Queue to create the job queue entry.
- Click Open Job Queue Entry and change the status from On Hold to Ready to activate automatic execution.
US-07: Use a date formula-based recurrence for the job queue
As a IT Manager
I want to schedule the job queue using a date formula instead of a fixed minute interval
So that the job runs on a predictable monthly or weekly cadence rather than at fixed intervals
Setup:
- Open Subscription Job Queue Setup.
- In the Schedule section, set Next Run Date Formula to a date formula such as
<1M>(monthly) or<1W>(weekly). - When a Next Run Date Formula is set, the No. of Minutes between Runs and Run on Days fields are disabled — the formula controls the schedule exclusively.
- Save and ensure the job queue entry is set to Ready.
US-08: Run invoice creation immediately without waiting for the schedule
As a IT Manager
I want to trigger invoice creation on demand from the Job Queue Setup page
So that I can test the configuration or handle a one-off billing run outside the normal schedule
Setup:
- Open Subscription Job Queue Setup.
- Ensure Configure Job Queue is enabled (required for Run Now to work).
- Click Run Now from the action bar.
- The system runs the invoice creation process immediately using the configured date formulas and settings. After completion, a success message is shown and the Last Run section is updated.
US-09: Monitor the result of the last automated invoice creation run
As a Accounting Manager
I want to check whether the last automated invoice creation run succeeded and how many invoices were created
So that I can confirm billing ran correctly and identify any errors
Setup:
- Open Subscription Job Queue Setup.
- Review the Last Run Information section:
- Last Run Date Time: when the job last executed.
- Last Run Status: Success or Error.
- Invoices Created Last Run: the number of invoices created in the last run.
- Last Run Error: visible only when the last run status is Error; shows the error message.
- Click View Activity Log to see a full history of job queue runs.
US-10: Pause automatic invoice creation without losing the job queue configuration
As a IT Manager
I want to temporarily stop the job queue from running without deleting its configuration
So that I can resume from the same settings when ready without re-entering everything
Setup:
- Open Subscription Job Queue Setup.
- Turn off Configure Job Queue. This sets the job queue entry to On Hold but does not delete it — all settings are preserved.
- To resume, turn Configure Job Queue back on. The existing entry is updated (not recreated) and you can re-activate it from the Job Queue Entry Card.
Note: If you want to permanently remove the job queue entry and reset all scheduling fields, use the Delete Job Queue action instead.
US-11: Understand how invoice lines are calculated for a quarterly subscription invoiced monthly
As a Accountant
I want to understand how the system creates multiple invoice lines when Subscription Period Length is shorter than Invoicing Frequency
So that I can verify the invoices are correct and explain the detail to a customer
Setup:
- This is automatic system behaviour. When a subscription line has Subscription Period Length =
<1M>and Invoicing Frequency =<3M>, each invoice creation run for that line produces three invoice lines — one per monthly period within the quarterly window. - Each invoice line has its own Starting Date and Ending Date corresponding to the individual monthly period.
- After the run, the Period Start Date on the subscription line advances by 3 months (one full Invoicing Frequency forward).
US-12: Understand what happens to a subscription line after invoice creation
As a Sales Order Processor
I want to understand how the subscription line is updated after an invoice is created from it
So that I know what to expect when I review the order after a billing run
Setup:
- After invoice creation runs:
- Next Invoicing Date on the subscription line advances by one Invoicing Frequency.
- Period Start Date advances by one Subscription Period Length (or one Invoicing Frequency if they are equal).
- If the new Period Start Date meets or exceeds the Ending Date, the line is automatically marked Completely Invoiced.
- The subscription line remains on the order and will be picked up again on the next run if it is not yet completely invoiced.
US-13: Create invoices only for a specific subset of subscription orders
As a Sales Order Processor
I want to run invoice creation only for specific subscription orders, not all of them
So that I can bill a subset of customers without affecting others
Setup:
- Open Create Subscription Invoice report directly (search in Tell Me bar), or use the Create Invoices action on a specific Subscription Order to pre-filter to that order.
- On the request page, use the filter fields (No., Sell-to Customer No., Bill-to Customer No.) to restrict which subscription orders are processed.
- Adjust the date fields as needed and click OK.
Field Reference
Create Invoices Request Page
| Field | Where to find it | What it does | Default |
|---|---|---|---|
| Include up to date | Create Invoices request page | Subscription lines with Next Invoicing Date ≤ this date are included | End of next month |
| Posting Date | Create Invoices request page | Posting Date set on all created invoice headers | First day of next month |
| Document Date | Create Invoices request page | Document Date set on all created invoice headers | Work date |
| Invoice per | Create Invoices request page | Grouping of invoice lines: Customer, Subscription, or Line | Customer |
| Invoice Line Comment | Create Invoices request page | Optional text inserted as a heading line on each created invoice | — |
Subscription Job Queue Setup Fields
| Field | Where to find it | What it does | Default |
|---|---|---|---|
| Configure Job Queue | Job Queue Setup → General | Enables/creates the job queue entry (On Hold on creation); turn off to pause | Off |
| Job Queue Status | Job Queue Setup → General | Read-only; shows current status of the job queue entry | — |
| Include Up To Date Formula | Job Queue Setup → Invoice Creation Parameters | Date formula applied to work date to calculate which lines to include | <1M+CM> |
| Posting Date Formula | Job Queue Setup → Invoice Creation Parameters | Date formula for the posting date on created invoices | <CM+1D> |
| Document Date Formula | Job Queue Setup → Invoice Creation Parameters | Date formula for the document date on created invoices | <0D> |
| Invoice Per | Job Queue Setup → Invoice Creation Parameters | Grouping: Customer, Subscription, or Line | Customer |
| Invoice Line Comment | Job Queue Setup → Invoice Creation Parameters | Optional comment text added to invoice lines | — |
| Earliest Start Time | Job Queue Setup → Schedule | The earliest time of day the job may run | — |
| Next Run Date Formula | Job Queue Setup → Schedule | Date formula for recurrence (alternative to minutes-based scheduling) | — |
| No. of Minutes between Runs | Job Queue Setup → Schedule | Minutes between executions when not using a formula | 1440 |
| Run on [Weekday] | Job Queue Setup → Schedule | Which days the job is allowed to run | Mon–Fri: on |
| Last Run Date Time | Job Queue Setup → Last Run Information | When the job last executed | — |
| Last Run Status | Job Queue Setup → Last Run Information | Success or Error | — |
| Invoices Created Last Run | Job Queue Setup → Last Run Information | Number of invoices created in the most recent run | — |
| Last Run Error | Job Queue Setup → Last Run Information | Error message from the most recent failed run | — |