Creating Purchase Invoices (Purchase Order Process)

Creating Purchase Orders on your Suppliers.

Written By Grainne Reidy (Super Administrator)

Updated at December 12th, 2024

Introduction

The Purchase Ordering System has three modules:

  • Sales Orders: This lets you record receipts of goods or services against a specific Purchase Order.
  • Deliveries: The listing grid allows you to view all Purchase Orders received which have not been matched to an invoice. You can then record an invoice for matching against that PO. Unmatched POs where they have been marked as "Received" can then be the basis for your accruals.
  • Item Invoices

It is or can be, integrated with:

Invoicing without a prior Purchase Order

Not all Orders need to be entered into the system. Small low-value Items such as stationery or refreshments can be processed using Batch Invoicing‍, without the necessity of a preceding Purchase Order. This, however, can be a security risk as it bypasses the Ordering process. If this is a concern, remove the Batch Invoicing option as a menu option‍, or severely restrict its usage. This will mean that all Invoices are processed using Item Invoices. 

Enforcing a prior Purchase Order

Item Invoices for things like electricity, water, or rent can still be entered without a preceding Purchase Order. 

However, you have the option to enforce the entry of prior Purchase Orders against selected Suppliers by checking Order Required in their master record. The Invoice will subsequently undergo an Invoice/Order Matching process. If the Invoice exactly matches the Order in respect of all Lines, Quantities, and Prices, then the Invoice is automatically processed without the need to enter it into the system.

Best Control Practices

To introduce the strictest possible control over your Purchasing System:

  • Limit access to the Batch Entry facility.
  • Enforce Order Entry against most Suppliers.
  • Ensure that only authorised personnel have access to the Supplier Master record maintenance function.

Setup Prerequisites

The Purchase Ordering facility has several prerequisites. These include setting up the:

See:

Purchase Orders Overview (17.0) - AIQ Academy

Purchase Order Entry - Pre-requisites (17.1) - AIQ Academy

Purchase Order Entry (17.2) - AIQ Academy

Purchase Deliveries (17.3) - AIQ Academy

Purchase Orders /Delivery Queries (17.4) - AIQ Academy 

 

New Workflow Approval - New Look UI‍ 

Creating Batch Purchase Invoices‍ 

Setting Up System Users‍ 

 
 

Create a Purchase Order 

Go to AP> Purchase OrdersNew Order. This opens the Purchase Order screen.

Purchase Order Details

In the header:

  • Purchase Order No: This is controlled in Company Details and Settings. If auto-numbering is on, then the P.O. Number will auto-generate. Otherwise, supply a unique Order No.
  • Supplier (Vendor): Select from the dropdown provided. This populates the Supplier’s (Vendor’s) details on the Order Header. 

Note

When entering the Supplier Code or Name, if you receive a message, "This Account is over the Assigned Credit Limit of xxxx.xx by xxxx.xx", do not proceed with the Order as you will not be able to save it. Instead, choose another Supplier, or leave the Order, resolve the Credit Limit issue, and return to it later. 

 
  • Order Date: This defaults to today’s date, but you can change it using the dropdown. Note that this date will place this order into the correct financial period. This is done automatically to ensure that the transactions go to the correct period.
  • External Ref: This is your own reference number to help you keep track of your Orders. It could, for example, be the Supplier’s (Vendors) Inventory Code.
  • Expected Delivery Date: This defaults to today’s date, but you can change it using the dropdown. This is the date you expected this order to be delivered (i.e. received). This can be used to track orders that are due or overdue using the filter options in the Orders Listing grid.
  • Use ACC VAT (Tax) Code: Checking this box means that any items entered will use the supplier account's default tax code instead of the product's tax code. For example, if a particular product has a default tax code of 21%, but a particular Supplier is an overseas Supplier and is exempt from tax. This field can be modified to allow you to account for the difference.
  • BI Code: Some Suppliers (Vendors) always deliver to the same part of the Company which they represent with an optional BI Code from the Supplier (Vendor) Master Record. It is not a mandatory entry as you may not want to use Extended Business Analysis, or your Order might use several BI Codes. If a BI Code exists, it will appear on each line of the Order where you can override each individually. However, if you are using Purchase Order approval, then you can only use one BI Code per Order.
  • Supplier (Vendor) Area: This defaults from the Supplier’s (Vendors) Master Record but you can override it here.
  • Requester: This is an optional field. It is the individual that raised this Purchase Order. This person, along with the approver, will be notified by email after this Purchase Order is processed and will receive an attached copy of this order for their information.
  • Billing Address: This is the address of the Supplier (vendor) that this order relates to. This address is read from the Supplier(vendor) record and can be changed at order level.
  • Supplier (Vendor) Contact: This is the Primary Contact from the Supplier’s (Vendors) Master Record. This can be modified for a specific order.

In the lines:

Click Display Lines Only to hide the Supplier (Vendor) Detail in the upper half of the screen. Click again to restore. 

Similarly, click the arrow icon at the start of each Order Line to display/hide details from the Inventory file for the Product nominated on that Line.

  • Item: This comes from the Inventory Product file. Use the dropdown together with its Description and default GL Posting Code which you can change if required.
  • GL Account Code: This comes from the Supplier’s (Vendors) Master record (if any) and then the GL Account Code from the Product file overrides it. You can override it using the dropdown or by keying in a GL Code.
  • BI Code: If you are using Extended Business Analysis then supply a BI Code. It might come from the Order Header; in which case you can still override it here.
  • Qty: Enter the Quantity of Items required from the Supplier (Vendor).
  • Unit Price: This comes from the Last Cost field on the Inventory Master Record, but you can override it here.
  • VAT (Tax): This either comes from the Order Header (which in turn comes from the Supplier’s (Vendors) Master record) or from the VAT (Tax) Rate associated with this Item on the Inventory file. In both cases, it is a default rate, but you can override it here.
  • Disc. Rate, Disc. Amount: If there is a Discount Percentage on the Supplier’ (Vendor) Record, then this will apply. You can either accept this Rate and Calculation or you can put in a fixed amount in the Disc. Amount field and the system will work out the percentage. 
  • Line Note: You can add a Note to each Order Line.
  • Exchange Rate: If the Supplier is a Foreign Currency Supplier, this field displays the default exchange rate currently associated with the chosen Supplier (vendor). This can be overwritten if necessary and will be used when posting the order to calculate the base currency value of the order.
  • Status: The status of the order is displayed here. An order can be 'Reserved' when initially recorded and the items have a reserved quantity against them, 'Partial Delivery' when part of it has been delivered, 'Full Delivery' when all of it is delivered, 'Complete' when it has been delivered and invoiced and finally 'Closed' if the user has decided to close it and not deliver.

Additional Details (Optional)

In this tab, you can modify the Delivery Details inherited from the Supplier’s Master Record such as:

  • Discount: This displays the default discount associated with the Supplier (vendor). This can be overwritten for the specific order and will update any lines entered. If you update the default in the supplier record, any prices and quantities recorded prior to modification would need to be re-entered to include the modification.
  • Payment Method: This specifies how this order will be settled by your company. If you select a payment method that has been set up as an 'online' payment method in codes maintenance, then related orders will be available to pay through the Online Batch Payments function.
  • Note Printed on Purchase Order: Here you can also add a Note to appear on the Supplier’s (Vendor's) Order for them to see.

Notes (Optional)

The Notes tab allows you to add internal Notes to the Order. 

  1. Click Add New Note.
  2. Enter your note.
  3. Click Save.

See:

Using Extended Business Analysis‍ 

 
 

Workflow Approval

For full details on our new workflow approval, see New Workflow Approval - New Look UI and Workflow Scenarios.‍ ‍ 

Disabling Workflow Approval (Legacy Workflow only)

After saving, the Order will bypass approval if:

  • Untick Purchase Approval Enabled Company Details & Settings.
  • If you tick Exclude from Approval in Supplier Accounts.

Workflow Approval Statuses (New and Legacy Workflow)

If you enable approval:

  • The initial Status will be "Reserved." 
  • The relevant Approval Status will appear. See New Workflow Approval - New Look UI for f‍ull details of legacy vs new workflow statuses.
  • In the Actions dropdown, Receive All & Invoice will NOT be available until the order has been approved.

If you disable approval:

  • The initial Status will be "Reserved".
  • The Approval Status will be “Approval Not Required” if the PO is excluded from approval. If the entity does not use approval, there will be no Approval Status column.
  • In the Actions dropdown, Receive All & Invoice will be available immediately.
 
 

Edit Orders

Once you reserve an Order, it is saved. You can recall the Order at any time before full delivery to amend and/or re-issue it.

  1. Go to AP Purchase Orders and find it in the listing grid.
  2. Click the Order No. to open the Purchase Order. 
    • If the Order delivery is complete, all fields will be greyed out meaning you cannot edit them. 
    • If they are not greyed out, make any required changes. You can delete lines, add new lines, change Quantities and Prices, Vat Rates, add Line Notes, and amend GL Codes and BI Codes. Click the arrow or the Item Code dropdown to make any edits.
  3. Click Save.
 
 

Cancel, Duplicate, and Print Orders

The Orders listing grid lets you:

  • In the Print column, print orders to a range of formats including PDF Order.
  • In the Email column, email orders to your suppliers.

The More Actions grid lets you:

  • Cancel Orders: Alternatively open the order and click on Cancel Order. This will update the status of the order to Cancelled.
  • Duplicate:  Alternatively open the order and click on Duplicate Order. Both open and closed orders can be duplicated. Add a new External Ref and modify it as required, including adding new Order Lines, as you require. Click Save. The original Order will remain in the system as it was.
 
 

View Deliveries 

In the Purchase Deliveries Listing Grid

  1. Go to Purchase Deliveries .
  2. In the relevant Actions dropdown, select View Deliveries.

In the Purchase Orders Listing Grid

  1. Open the relevant Purchase Order in PO listing grid (status ‘Delivered, Not Yet Invoiced’).
  2. Click on View Deliveries.
 
 

Receive All Orders and Invoice (Non-Stock Items)

When you obtain services from a Supplier (with approval where relevant), you need to receive and invoice them (in full or partial). 

  1. In the Purchase Orders listing grid, find the relevant transaction.
  2. In the Actions dropdown, select Receive All & Invoice. This creates a Purchase Invoice with the current date and the status of Full Delivery.
  3. Complete the Purchase Invoice. See Creating Purchase Invoices (Non PO Process) for more details. For a partial delivery, change the quantities.
  4. Click Save. The status will update to Complete.
 
 

Receive Orders and Match Invoices (Stock Items)

When your Supplier (Vendor) delivers goods, you need to receive and invoice them (in full or partial).  

Step One: Receive Orders

  1. In the Purchase Orders listing grid, find the relevant transaction.
  2. In the Actions dropdown, select Receive. This opens the Purchase Deliveries screen.
  3. In the This Delivery column, enter the appropriate quantity or click Receive All. To undo the Delivery Quantities, click Reset.
  4. Click Save or from the Save dropdown, select Save and Print to produce a Goods Receipt Note for your records. 

Step Two: Create Matching Invoices

  1. Go to Purchases > Deliveries and find your delivery.
  2. In the relevant Actions dropdown, select Invoice.
  3. The invoice will open. Check if its details agree with your Delivery Records:
    • If quantities differ, change the Quantity on this Invoice to match your quantities.
    • If there are price differences and you’re willing to accept them, adjust the Unit Price.
    • If there are additional charges against a Line, add a new line with the same Item Code, a quantity of 0.00, and put the extra charge in the Net column. This additional cost will be used in the calculation of the overall Average Cost for the Item.
    • If you receive more than you ordered, then you cannot increase the quantity. You must go back to the Order first and increase the quantity there and then deliver it.
  4. Click Save. If the saved Invoice now matches the Delivered Order, then the Order will be fulfilled and disappear from the system. You can Cancel an Order at any time. If there are partial Deliveries in the system, you can still cancel the remainder of the Order.

To view complete details, you can run a "Goods Received Listing" Report in the Report Manager‍. This gives a full view of the status of the originating Purchase Order through to the Purchase Invoice stage.