Invoice Entry

There are a number of ways an Invoice can be created in Salesforce using the Maica solution including manually entering it or submitting it via Salesforce' API. This article focuses on the Invoice Entry Screen provided by Maica to easily and reliably submit Invoices to Salesforce whilst validating the Participants underlying funding structures.

Let's see it in action - video

Before we describe the process in detail, we thought it would be good to see the Invoice Entry in action, so please have a look at the below animation or view the full video here.

The Invoice Entry component contains a number of Validations and Alerts to assist and guide you as you add the Invoice details. These are described in detail in the Alerts & Validation article below.

Manual Invoice Entry

The way to get started with manually entering an Invoice is to simply click the New Invoice button within Salesforce. This button has a Lightning Experience Override, meaning that it will open our Add New Service Invoice component (maica:InvoiceEntryQA), as opposed to the standard New record screen, presented when you click New for other objects.

Overall, in order to successfully create an Invoice, we need to collect some specific information such as:

• Who the Invoice is from (the Provider)

• Who the Invoice is for (the Participant)

• The Invoice Number

• The way the Invoice should be claimed

• The Invoice Line Item detail

The screen below shows you what a completed Invoice would look like with a description of each input field.

Invoice Entry Input Fields

At the top level, we collect the following information to set up the overall structure of the Invoice.

Provider

The Provider is the service provider who has issued the Invoice and on whose behalf this Invoice is being entered. Providers can be found by searching on either Organisation Name or ABN which Maica will use to present a list all Account records in Salesforce matching this criteria. Directly underneath the Provider name, Maica displays the ABN stored for the Provider so it's easier for you to distinguish between Providers with the same name.

In cases where you are delivering services to your Participants, the Provider field would be your own Organisation (Account) record.

Participant (NDIS Number)

The Participant is the person who received the services for which the Invoice is being submitted/entered. The majority of the time a Participant can be found in the list by typing in the NDIS Number or the Name.

Invoice Date, Due Date, and Invoice Number

This is the Date, Due Date, and Invoice Number of the Invoice as stipulated by the Provider issuing the Invoice for submission.

Funding Structure

The funding structure offers three choices on how to submit this Invoice to Maica, including Plan Managed, Agency Managed, or Self-Funded. Let's have a look at how these two behave differently, including:

• Agency Managed Invoices are validated against an existing and active Plan as well as any associated Service Booking. Without a valid Service Booking, you cannot submit an Agency Managed Invoice as Maica validates the required funding structures are in place to submit this Invoice.

• Plan Managed Invoices are aimed at providing an Invoice to the plan manager for a given participant. This means that Maica will automatically generate an invoice and send this to the associated plan manager for a participant (via a lookup on the Contact profile).

• Self-Funded Invoices are aimed at scenarios in which there might not be an active Plan; this could be because Maica couldn't synchronise the Plan or the Participant did not give consent to synchronise the Plan or the Invoice is funded outside the NDIS funding structures.

Claim Behaviour

This is where some of the magic happens when entering and submitting Invoices to Maica. A few options exist when setting this value that will impact Maica's behaviour differently, including if a Payment Request record is created or not to facilitate PRODA Claims.

The Claim Behaviour options are described further below:

Adding Invoice Line Items

The real heartbeat of an Invoice is the Invoice Line Item which captures all the required information to either dispatch the Invoice or claim the Invoice from the NDIS. This section provides you with some more detail around what the various input fields are for an Invoice Line Item, including:

Service Date

This is the date on which the service was delivered (as opposed to when the Invoice was raised); it is important to capture the service date to understand what the applicable rate was at the time the service was delivered as well as what budget was available within the Service Bookings funding the Invoice. Maica uses standard Salesforce Price Books to control pricing of Support Items. You can learn more about Salesforce Products and Price Books below.

Help And Training Community

Support Category

The Support Category is shown based on the available Service Booking funding at the time of service delivery, in other words, whatever Support Categories the Participant had funding for at the time the service was delivered will be shown to you.

This is described in more detail in the Invoice Entry Alerts & Validation section below.

Support Item

The selection of the Support Item will depend on what Support Category was selected, all associated Support Items (which are managed as Salesforce Products) will be shown to you and are available for selection. Here is an example of what a Support Items might look like when configured in Salesforce as a Product.

Claim Type

The Claim Type is automatically set from the selected Support Item (Product) as you can see in the above screenshot, so there is no need to enter/change this unless this is required.

Most of the time, we expect this value to be simply read from the Support Item and preset for an Invoice Line Item.

Quantity

The Quantity captures how many of a particular Support Item is being captured, for example a Speech Therapy session will have a quantity of 1 but if multiple sessions are being invoiced, you can use quantity to set this.

Rate

The Rate is determined by Maica based on the Service Date and what Price Book the Support Item was (or continues to be) associated with. If only a single Price Book was associated with the Support Item, the rate will be preset but can be changed.

Based on the Participant, Maica attempts to default the Price Book based on the logic below. The Price Book can still be changed, this is just to help streamline your Invoice Line Item entry.

• If the Participant has an Active Service Agreement with the Invoice Provider

  • That Price Book will be set as the default

• If no Active Service Agreement

  • Default the Price Book based on Participant's State (Contact.MailingState)

• If > 1 Price Book records are returned (based on the State example)

  • Default the most recent Price Book based on Last Sync Date (this is generally CreatedDate)

  • Please note: this does not support the REMOTE and VERY REMOTE Pricebook as these cannot be mapped to the Contact Mailing State

If the Support Item exists in multiple Price Books at the time of service, a dropdown to the right of the rate will be available for you to select the Price Book you wish to use. You can see an example of this in the image below.

GST Code

The GST Code is automatically set from the selected Support Item (Product) as you can see in the above screenshot, so there is no need to enter/change this unless this is required.

Most of the time, we expect this value to be simply read from the Support Item and preset for an Invoice Line Item.

Adding Multiple Invoice Line Items

There may be a scenario where you need to create multiple Invoice Lines for the same Support Item that has been delivered over consecutive days. Rather than creating a single Line Item and cloning it, the Add Multiple button on the Invoice Entry allows you to generate multiple Line Items with shared characteristics.

Clicking the Add Multiple button presents the modal below:

Click confirm and watch Maica do the following:

• Generate the Line Items based on the Number of Lines value

• For each Line Item, the Service Date will increase sequentially from the First Service Date based on the Number of Lines

• For example, if you entered:

  • First Service Date = 05/09/2022

  • Number of Lines = 5

• A total of 5 Invoice Lines would be added for the dates 05/09 to 09/09

• All Invoice Lines will have the same attributes (Quantity/Rate/Support Item/Claim Type)

When using the Add Multiple option, there are some very important things to note:

• No alerts based on budget/agreement are displayed in the modal, these can only be seen after the Line Items are added

• If any of the dates fall on a weekend or public holiday - the normal validation will not apply and will need to be manually corrected

• The max date range will be 1 month (31 days)

• The default filter applied to the Support Item lookup is:

  • IsActive = TRUE

  • The Product has at least one Active PricebookEntry