Introduction

Sales Item Invoicing is integrated with the Inventory Management system, either fully in the context of quantities management, or partially in the context of non-stocked goods and services. It is not mandatory to use Sales Orders with Sales Order Invoicing. Even if you use Sales Ordering, there may be certain Invoices that you do not want to create and issue a Sales Order for, such as bills for Extras, Transport, or on-the-spot Services. 

You can also create Sales Invoices through the Batch Entry facility, without the necessity of a preceding Sales Order. Batch Invoices do not use the Inventory Management tables and consist of single line entries only, whereas Sales Item Invoicing can have multiple lines, one for each Product. 

Prerequisites

Make sure the following are complete:

• Customer Master Record.
• Inventory Master Record (Stock and/or Non-Stock).
• Code tables including General Ledger Codes, Taxes, and Currencies.

Keyboard Shortcuts

• TAB: Advances to the next cell in the grid
• TAB + SHIFT: Goes back to the previous cell in the grid
• ENTER: Advances to the next cell in the grid
• F6: Use to make a copy of the current line and insert a new line with the same details. This is a useful function if you are creating payment records with similar details, such as recording several Receipts to the same General Ledger account but with different cheque references. 
• F8: Use to delete the current line. If this does not work, try FN+F8.

Creating a New Sales Item Invoice

To create a new Sales Item Invoice either:

• Go to Sales > Item Invoices > New Item Invoice:
  
  
   
• Go to Sales > Customers > Actions and select Create > Item Invoice:
  
  

See:

Sales Overview (3.0) - AIQ Academy

Sales Item Invoices / Credit notes (3.2) - AIQ Academy

 

How does Sales Order Entry Work?‍ 

How does Sales Batch Invoicing Work?‍ 

How do I Maintain Customer Master Records?‍ 

How do I Maintain Product and Service Type Items?‍ 

  How do I Use the Recurring Sales Invoice Feature? ‍ 

Creating a Sales Item Invoice

Invoice Details Tab

Complete the header details:

• Invoice No: You must enable Autonumbering if you have integrated with third-party sales systems, or plan to. To do this, go to Setup > Company Details & Settings. Under the Settings tab, tick Auto Order Numbering. 

Alternatively, enter an invoice number here. The system will check for duplicate Invoice Numbers for this Customer and will warn you if it has found any. You will still be able to save the invoice, but you will not be able to post it until you change the Invoice Number. 

• Customer: Select the customer from the dropdown. This adds their details to the Invoice header. If you have the correct permissions, you can also add a new customer by clicking + Add New Account. 
• Invoice Date: This defaults to today’s date, but you can override it using the calendar. 
• Save as Recurring Invoice: Tick if you want to repeat this Item Invoice at regular intervals.
• Order No., Order Date, Expected Delivery Date: These are not mandatory. If you create an Invoice from a Sales Order, the Order No. will be added automatically. Alternatively, enter an Order No., Order Date, and Expected Delivery Date. 
• External Ref: This is not mandatory. However, it can be beneficial to help identify the Invoice. If entered, it will appear on the printed Customer Invoice (for example, JUL 20 Licence). 
• Use Acc Vat Code: You can set a default VAT code for both Customers and Items. If both are set, the Invoice will use the Item VAT code. If you want to use the Customer default VAT code for all lines, tick Use Acc VAT Code. This can also be set in the Customer Master Record. 
• BI Code: If the customer has a default BI Code in their Master Record, this will appear on all lines. However, you can override it at the header or line level. 
• On Hold Status: You can create invoices for customers Not On Hold or Deliveries On Hold but not for Orders and Deliveries On Hold.
• Sales Area, Sales Rep: Complete if using. 
• Billing Address: These come from the Customer Master Record, but you can override them.  

Line navigation tips

These shortcuts speed up the Invoice entry process:

• The enter, tab, and down cursor keys allow you to move between fields and select from dropdowns.
•  F6 copies the line above.
•  F8 deletes the current line. 

To temporarily hide the header:

• Click Display Lines Only, Display. Then click Display All to restore.
   

Complete the Invoice Line details:

• Item: Select the Item from the dropdown or by typing the Item name. This will retrieve its Description and default General Ledger Posting Code. You can override these if required. 
• BI Code: Select the relevant code. If the BI Code came from the Invoice Header, you have the option to change it at line-level.
• Qty, Unit Price: Enter the Quantity and Unit Price of the Item.
   
  Delete

  Info

  The Unit Price comes from the Item Master Record as well as the Price List linked to this Customer Account. 

• VAT: This comes from either the Item VAT Code or the Customer Account VAT Code if you select Use Acc VAT Code. 
• Disc. Amount: If there is a Discount Percentage on the Customer Master Record, then this will apply automatically. If not, you can enter a fixed amount in the field and the system will calculate the percentage. This will cause the Net, VAT amount and Line total to be recalculated.
  
  
  Delete

  Info

  The system recalculates the Net Amount based on the Discount entered. Only Net of Discount is posted against nominal ledger accounts. 

  
   
• Description: This comes from the Item defaults, but you can edit it here if necessary.
• Line Note: This will appear on the Invoice for the Customer.
• Exchange Rate: If the Customer is a Foreign Currency Customer, the current Exchange Rate from the Currency table will appear. You can override it here if necessary.  

Additional Details Tab 

• Delivery Address: This comes from the Customer Master Record, but you can override it. 
• Ship Via: This comes from the Customer Master Record, but you can override it.
• For Collection: This will appear on the printed Invoice. 
• Discount:  This comes from the Customer Master Record and applies to the Invoice as a whole. However, you can change it here. You will be asked to confirm that it applies to all Lines on the Invoice. This will cause the Net, Tax, and Line Total will be recalculated. 
• Payment Method:  You can change the default here.
• Forecasted Payment Date: This defaults to today's date on saving. This is useful if you are using Cashflow Forecasting as you can estimate when to expect a receipt from the customer. 
• Printed Note: Add text to appear on the header of the PDF invoice for the customer. 

Notes Tab

Here you can add internal Notes specific to this Customer Invoice. These notes will not appear on the printed invoice and are only visible to system users. 

Saving, Posting, and Printing Invoices at entry

Clicking Save creates a draft or Pro-Forma invoice.
 

Only posted invoices will have accounting entries posted against the debtor and the GL ledger accounts. There are four options when you click Save: 

• Save Invoice: This will process but not post the Invoice to the ledger.
• Save and Print Invoice: This will save and print a Pro-forma Invoice.
• Post Invoice: This will post the Invoice to the ledger, meaning you cannot delete it and can only edit certain fields.
• Post and Print Invoice: This posts and prints a copy of the posted Invoice. 

Maintaining Sales Invoices

Viewing Invoices in the grid

To view item invoices, go to Sales > Item Invoices.
 

When you enter a Customer Invoice, it becomes available to view in the grid. By default, only open invoices appear. You can clear this filter by clicking Clear or selecting a different one from the list. 
 

These invoices are not yet posted and so you can still edit or cancel them. Unposted Invoices do not update the Customer Account in the Accounts Receivables Ledger or General Ledger. However, the Invoice does update the Inventory Management System with Quantities and Costs. This means that if you delete Lines from the Invoice now, these Quantities will be reversed.

Posting Invoices from the grid

Go to Sales > Item Invoices. 

To post the saved Invoice you can either:

• Under the Post column, select the relevant Invoice/s. Click Post Selected. 
• Open the Invoice by clicking its Number. Click Save > Post Invoice.
   

The Invoice will now disappear from this grid and will appear in the Customer Account grid which you can access by clicking the Balance in the Total column.
 

Emailing Invoices from the grid

For the relevant Invoice, click the email icon, complete the message in the screen and click Send Message.

Printing Invoices from the grid

For the relevant Invoice, select the required format from the Print dropdown.

Duplicate, Auto Credit, Mark as Disputed, or Cancel an Invoice

1. Go to Sales > Item Invoices and find the relevant Invoice.
2. From the Actions dropdown, or in the Invoice, select one of the following:

• Duplicate: For edits that you cannot make, for example, if the Invoice has already been posted, you can instead duplicate the Invoice. Click Duplicate. Add a new External Ref. and then modify it, including adding new Invoice Lines, as you require. Click Save. The old Invoice will remain in the system as it was, and you can then Auto-Credit it (see below).
• Auto Credit: While you cannot delete an Invoice, you can effectively nullify it by clicking Auto-Credit. This creates and allocates an exact replica Credit Note to the Invoice. It will default to today's date and effectively reverse all the invoice details, GL codes, BI codes, line items, and amounts. 
• Mark as Disputed: For example, if the Customer does not agree with the Credit Note contents.
• Cancel Note 

Editing a Sales Invoice

Go to Sales > Item Invoices and click the Invoice Number to open the Sales Item Invoice screen. 

Invoices with a status of Posted will have all fields greyed out so you cannot make edits. However, if you click on the Edit Details you can update the:

• Line Description.
• Address.
• Delivery Address. 

You can edit Invoices that have a status of Processed. You can:

• Delete or add Lines.
• Change Quantities, Prices, Vat Rates, GL Codes, and BI Codes.
• Add Line Notes and Order Notes.