Creating Purchase Item Debit Notes

Facilitating the entry of Credit Notes received from Suppliers in respect of Goods returned or Services not required.

Written By Grainne Reidy (Super Administrator)

Updated at November 2nd, 2023

Introduction

You receive Credit Notes from your Suppliers for Items you returned or Services you no longer require. If you receive a Credit Note from a Supplier which does not relate to Products or Services, enter it using the Batch Debit Note Entry program. 
 

Item or Service Debit Notes differ from Batch Debit Notes. They allow you to enter Debit Notes and Invoices for specific Items (Stock and Non-Stock) that you purchase. These Items and Services can be set up and maintained in the system using the Item Maintenance functions. You can track the Stock Count of Items that you Return using the stock control functions of the system. 

See:

Edit and Credit Purchase Item Invoice (4.3) - AIQ Academy
 

Creating Batch Purchase Debit Notes‍ 

Delete

Creating Purchase Item Debit Notes

  1. Go to Purchases > Item Invoices. The grid displays all previously entered Invoices and Notes and their statuses. By default, the window hides Posted Invoices and Debit Notes and shows only Processed Purchase Item Invoices & Debit notes. If you want to see all Purchase Item Invoices and Debit Notes, then click Clear.
  2. Click New Debit Note to open Purchase Item Debit Note. The screen has three tabs: Supplier (Vendor) Item Debit, Additional Details, and Notes

Graphical user interface, application

Description automatically generated

Delete

Supplier Item Debit: Supplier Details 

Graphical user interface, text, application, email

Description automatically generated

 

In the upper section of Supplier Item Debit, enter the following:

 

  • Debit Note No: Assign a number to this Debit Note. It can contain alpha and numeric characters.
  • Supplier (Vendor):  Click the dropdown or type to search. When you click the relevant Supplier (Vendor), this updates some fields with values from the Supplier (Vendor) Master Records. Set up detailed Supplier (Vendor) Master Records to reduce data entry. 
Delete

Note

If you override any of this information during Debit Note entry, it applies only to this Debit Note and will not alter the Supplier (Vendor) Master Record.

  • Debit Note Date: This defaults to today, but you can change it to the date on the Suppliers Credit Note or any prior or future date. If you enter a Debit Note date that is beyond the current period in the General Ledger, you will receive notification.
  • Order No: Populate this field as you wish. You could use it to record the Supplier's Credit Note No.
  • Order Date, Expected Delivery Date: Both default to today's date but you can override it. You could use these Dates to record the Return Date of the Items you sent back from the Supplier's Credit Note.
  • Use Acc VAT Code:  You can ignore this field as the Tax Code comes from the Supplier.
  • Acc Tax Code: Ignore this field.
  • BI Code: If the Supplier (Vendor) Master Record contains a BI Code, it will default here. Otherwise, enter or select a code or leave it blank. This assigns it to all lines of the Debit Note. If needed, you can override it on each line prior to posting. 
  • Supplier (Vendor) Area: This defaults from the Supplier (Vendor) Master Record. This field is for analysing Supplier (Vendor) Purchases, for example into Areas or Groups, and in the Purchases Analysis data warehouse.
  • Billing Address, Address 2, City, County/State, Postcode, Country: These details default from the Supplier (Vendor) Master Record but you can change them here. This will not alter the default Address on the Supplier (Vendor) Master Record.
  • Supplier (Vendor) Contact: The contact name for this Supplier (Vendor) defaults from the Supplier (Vendor) Master Record but you can change it for this Debit Note.
Delete

Supplier Item Debit: Line Details

How to enter data

  • To create a new Line: Tab off the first line to display a second line.
  • To delete a line: Press 'F8' on the keyboard. This marks the line for deletion at the Debit Note processing stage.
  • To display Lines only: Click Display Lines Only to remove the Debit Note header fields from view for the Tab you are in. You can see more lines on your screen if you have many lines to enter.

Completing Line details

 In the lower section of Supplier Item Debit, enter the following:

  • Line: This is the line number on the Debit Note.
  • Item: Select the code from the dropdown menu or enter all or part of the code to return a list. The description and item price will auto-fill with the values set up in the Item Master Record.
  • Description: The Description for the item that displays here but you can override it here.
  • Sales GL Acc No: This is the default GL Acc No of the Item. You can override it here or before posting.
  • BI Code: This defaults from the Debit Note header field (if used) or the Supplier (Vendor) Master Record. You can override it here or before posting.
  • Qty: Enter the quantity credited by the Supplier on your Credit Note. For partial quantities, enter them in decimal form. 
  • Unit Price: The default Unit Price for the Item auto-fills when you select the Item Code. If it does not correspond to the Supplier's Credit Note, change it. 
  • Net, VAT, (Tax) Amt, Line Total All these values are based on the Quantity and Unit Price.
    • Net: The net price represents the total price for that line excluding Tax but including the default Discount for the selected Supplier. Entering a new Amount will automatically reset the Net and Tax amounts to total the new value.
    • VAT (Tax): This value is based on the Tax code associated with the Item, but you can override it with the Tax Code from the Supplier's Credit Note. If the amount calculated is incorrect, override it by double-clicking on the Line Total field and entering the required amount in the message box. If the amount you enter is more than 110% of the originally calculated value, you will receive a warning. 
  • Disc. Rate: Enter the percentage Discount given by the Supplier. You can override the discount rate here.
  • Disc. Amount: Enter the Discount value taken by the Supplier on his Credit Note to you.
  • Line Note: Enter extra line notes you wish to appear on the printed Debit Note.
  • Exchange Rate: This field displays the default Exchange Rate currently associated with the chosen Supplier. You can override it here.
  • Sub Total, VAT (Tax) Total, Total: These are the sum of all the lines you have entered. The Sub Total is the sum of each line entered and is a Net (without tax value). The VAT (Tax) Total sums all the lines that have a VAT (Tax) value on them. The Sub Total and the VAT (Tax) total give the Total. 

If the Supplier (Vendor) uses foreign currency, both the foreign and Base Currency amounts appear. If you change the Exchange rate, the Supplier (Vendor) Currency total will remain the same, but the Base Currency amounts update.

Delete

Supplier Item Debit: Additional Details 

Graphical user interface, application

Description automatically generated

 

In the Additional Details tab, enter the following:

 

  • Delivery Address: The delivery details default from the Supplier (Vendor) Master Record but you can override them here. If you choose to print the Debit Note, these details will appear.
  • Ship Via: The Ship via field defaults from the Supplier (Vendor) Master Record but you can override it here to any valid shipper code.
  • Discount: This displays the default discount associated with the Supplier. Ignore it, as any Discount will be on the Supplier's Credit Note to you.
  • Account Credit Limit: This displays the credit limit agreed with this Supplier (Vendor) for information purposes only.
  • Account Balance: This displays the current Supplier (Vendor) Account balance for information purposes only.
  • Payment Method:  For information purposes only.
  • Forecasted Payment Date: Ignore.
  • Note Printed on Invoice: Record a note here to appear on the header of the Debit Note.
Delete

Supplier Item Debit: Notes 

Graphical user interface, text, application, email

Description automatically generated


Store notes against your Item or Service Debit Note here. 

You can view all notes entered against your Item Debit Note. 

To view a Note, find the Note and click View.

To create a Note, click Add New Note, type the required note, and click Save.

Delete

Saving the Debit Note

  1. After you have entered all your information, click Save
  2. A confirmation message will confirm the processing of the Debit Note and clear the screen to create another new Debit Note. Click Close
  3. You will then be returned to the Item Invoices grid.
Delete

Posting a Debit Note from the Item Invoice grid

To update the Supplier's (Vendor’s) Account and the relevant General Ledger Accounts with the values on the Debit Note you need to post it:

  1. In Purchases > Item Invoices, find your Debit Note.
  2. Tick Post to flag a Debit Note or Invoice for posting. Click Post Selected to post the flagged Invoices and Debit Notes.

Graphical user interface, text, application

Description automatically generated

Delete

Viewing Debit Note status

  1. Go to Purchases > Item Invoices.
  2. In the grid, under Status, the Debit Note displays as one of three options. 
    • New: The Debit note is not processed or stored in the database. 
    • Processed: The Debit Note has returned Items against it. It has updated the On Hand Quantities for each of the line items.
    • Posted: The Supplier's (Vendor’s) account and the General Ledger have been updated with the values from this Debit Note. 
Delete

Viewing Previously Entered Debit Notes

To view or edit an existing Invoice or Debit Note:

  1. Go to Purchases > Item Invoices.
  2. Enter your search criteria in any of the column headers. It defaults to Processed Invoices. Click Clear to view New and Processed Debit Notes. To view Purchase Item or Service Debit Notes only simply type PN into the Type column.
  3. Click the Number (highlighted in blue). If the Debit Note has been posted, then all fields in the Debit Note will be greyed-out and you cannot edit them. Otherwise, make any required changes and click Save.
Delete

Duplicating a Debit Note

You can duplicate or copy a Debit Note at any time:

  1. Go to Purchases > Item Invoices.
  2.  Under Actions, select Duplicate. Alternatively, click on the reference to open it and click on Duplicate. This will copy the contents of the Debit Note. 
  3. You can change the details of the duplicated Debit Note as required. The duplicate Debit Note may have completely different line details if you just want the original header information.
  4. Create a new number and click Save.
Delete