Creating Purchase Item Invoices (Unordered Process)

Entering Supplier Invoices which have not been the subject of Supplier Orders.

Written By Grainne Reidy (Super Administrator)

Updated at January 24th, 2024

 Introduction

The Purchase Product Invoicing program allows you to enter Supplier (Vendor) Invoices unaccompanied by an Order. It can be integrated with the following:

  • Inventory Management system: Purchase Invoicing can be integrated either fully in the context of quantities management, or partially in the context of non-stocked goods and services. 
  • Purchase Approval system: Purchasing Approvers and/or Budget Holders can implement Purchase Invoicing.

Uses for Purchase Invoicing

Even if you use Purchase Ordering, there are certain Invoices which you may not want to pre-order, such as bills for electricity, rates, and rent. 


In the case of small low value Items, such as Stationery and Refreshments, you can use the Batch Entry program without a preceding Purchase Order. This, however, is a security risk as it bypasses the Ordering (and Approval) processes. If this is a concern, remove the Batch Invoicing option from your Menus (or severely restrict its use) thereby requiring users to process Invoices via the Item Invoices option. 

Pre-requisites

The Purchase Invoicing facility requires the following pre-requisites:

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

Keyboard Shortcuts

To allow for quick data entry you can use keyboard shortcuts to navigate the invoice:
  • 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.

See:

Purchase Item Invoice (4.2) - AIQ Academy
 

How does the Purchase Ordering System Work?‍ 

How do I Implement Purchase Approval for Budget Holders?‍ 

How do I Implement Purchase Approval for Non-Budget Holders?‍ 

How does Purchase Batch Invoicing Work?‍ 

How do I use the Client Administration facilities to add Users and Control their Access Permissions? ‍ 

Delete

Entering Purchase Invoices 

Step One: Open a Purchase Invoice

Go to Purchases > Item Invoice > New Item Invoice to open the Purchase Invoice screen.
 


Step Two: Enter the Invoice Details (header)

In the Invoice Details tab, complete the following fields where appropriate: 

  • Invoice No: This is the Supplier’s (Vendor’s) Invoice Number. 
  • Supplier: Select the Supplier (Vendor) from the dropdown. Their details will autofill in the appropriate fields. The system checks for duplicate Invoice Nos. from that Supplier (Vendor). If they exist, you will receive a warning. However, this will not prevent you from using the Invoice.
  • Order No: This is not relevant since this is an Invoice without an Order.
  • Order Date,Expected Delivery Date: This defaults to today’s date, but you can change it using the dropdown.
  • Use ACC VAT (Tax) Code: Tick this to use the same Rate of VAT (Tax) on all Invoice Lines instead of the VAT (Tax) Codes associated with the Items. However, you can still override the rate on individual lines. 
  • BI Code: This defaults from an optional entry in the Supplier (Vendor) Master Record. A BI Code is a sub-division of the company. Some Supplier (Vendors) always supply from the same sub-division so you can have a default BI Code for all Invoice lines. If the Invoice will use several BI Codes, you don’t need to add a default here. However, if you use Purchase Invoice approval, you can only use one BI Code per Invoice.
  • Supplier (Vendor) Area: This defaults from the Supplier (Vendor) Master Record but you can override it here.
  • OCR Checked: Tick this if the Invoice has arrived from a third-party system such as EPOS or the Scanning solution. It indicates that the Invoice has been examined and has had its General Ledger Codes and BI Codes added.
  • Supplier (Vendors) Contact: This defaults to the Primary Contact from the Supplier (Vendor) Master Record.

Step Three: Enter the Invoice Details (lines)

To temporarily hide the Supplier (vendor) details:

  • Click Display Lines Only. Click again to restore. 
  • Click the circular button at the start of each line to display/hide details from the Inventory file for the Item nominated on that Invoice Line.

Note the following fields relating to Invoice lines:

  • Item, Description, GL Acc. No: Select the Item from the Inventory Product (Item) file using the dropdown. This autofills the Description and default GL Code but you can override these here.
  • BI Code: If you are using Extended Business Analysis then select a BI Code. If it defaulted from the Invoice Header, you can override it here if desired.
  • Qty: Enter in the Quantity of Product invoiced by the Supplier. The Unit Price defaults from the Last Cost field on the Inventory Master Record. If the Supplier’s (Vendor’s) Invoice has a different Price, you can use that instead if acceptable.
  • VAT: The VAT (Tax) Rate is either inherited from the Invoice Header (which in turn comes from the Supplier (Vendor) Master Record) or from the VAT (Tax) Rate associated with this Item on the Inventory file. In both cases you can override it here if the Supplier’s (Vendor’s) Invoice differs.
  • Discount: If there is a Discount Percentage on the Supplier (Vendor) Record, then this will be the default. You can either accept this Rate and Calculation or you can input a fixed amount in the Disc. Amount field and the system will calculate the percentage. If the Supplier (Vendor) hasn’t allowed Discount (or has given a different amount) and this is acceptable, then you can enter it in the “Disc. Amount” field. The VAT (Tax) and the Line total will then be recalculated.
  • Line Note: You can add a Note to each Order Line.
  • Exchange Rate, Line Total:  If the Supplier (Vendor) is a Foreign Currency Supplier (Vendor), an Exchange Rate will display. You can override it if necessary. Invoice Line Total takes account of this rate. However, you can still override the foreign currency Price to match the Supplier’s (Vendor’s) Invoice for each Line. The totals for both Currencies will appear at the bottom of your system Invoice.

    Graphical user interface, application, Word

Description automatically generated

Adding more lines

If there are additional lines on the Supplier’s (Vendor's) Invoice, such as Carriage or Duty, then you can add  a new Service Type to your Item/Service Table: 

  1. Press the Enter key to create a new line. 
  2. From the Item dropdown, click +Add New Item... This will open the Item/Inventory maintenance screen.


     
  3. Complete the details as necessary.

If the extra charges are related to a particular Line on the Invoice, then you can add a new line with the same Item Code, a quantity of 0.00, and put the extra charge under Net. This additional cost is used to calculate the Item's overall Average Cost.

  1. Click Save.

    Graphical user interface, text, application

Description automatically generated

Step Four: Enter Additional Details

  1. In the Additional Details tab, complete the following fields as necessary:
  • Forecasted Payment Date: This is calculated (at the end of all Invoice Lines) based on your Company’s payment history with this Supplier (Vendor). You can change this date using the dropdown. The system uses Cash Flow Forecasting to predict when this Invoice will be paid.
  1. Click Save.


Step Five: Enter Notes

  1. In the Notes tab, you can enter internal Notes for the Supplier (Vendor) Invoice.


     
  2. Click Save.

See:

How do I Implement Extended Business Analysis?‍ 

Delete

Editing a Purchase Invoice

You can amend an Invoice any time prior to Posting.

  1. Go to Purchases > Item Invoices.
  2. In the grid, click the Invoice No. to open it.

    Graphical user interface, application

Description automatically generated
     
  3. In the Purchase Invoice screen, you can do any of the following:
  • Delete Lines
  • Add new Lines
  • Change Quantities, Prices, Vat (Tax) Rates
  • Add Line Notes
  • Amend General Ledger Codes and BI Codes. 
  1. Click Save.

Delete

Posting Invoices to the Accounts System

When you have entered your Supplier (Vendor) Invoice, it is available to view as well as attach Documents and Notes. It has not yet been posted to the Supplier’s (Vendor’s) Account in the Creditors Ledger or to the General Ledger. However, Quantities and Costs have been updated in the Inventory Management system. If you delete Lines from the Invoice now, these Quantities will reverse.

Posting the Invoice to the Ledgers

  1. Go to Purchases > Item Invoices.
  2. In the grid, find the Invoice.
  3. Under Post, tick the selected Invoices and then click Post Selected.

    Graphical user interface, text, application

Description automatically generated
     
  4. The Invoice will now disappear from this Grid and will appear in the Supplier’s (Vendor's) Account Grid which you can access by clicking on the Balance field.

See:

How Do I Amend, Cancel or Delete Transactions?‍ 

Delete

Searching for Item Invoices

  1. Go to the Purchases > Item Invoices.
  2. Enter your search criteria in any of the column headers. 
  3. This screen defaults to Processed Invoices, but you can clear this by clicking Clear next to the Filter.

Delete

Duplicating Item Invoices

  1. Go to Purchases > Item Invoices screen.
  2. Find the Invoice.
  3. Under Actions, go to Duplicate. Alternatively, click on the Invoice No. to open it, then click Duplicate
  4. Modify the Invoice as desired.
  5. Give it a new Invoice No. and click Save.

    Graphical user interface, text, application, email

Description automatically generated
Delete