Go to the Supplier Invoices page to create supplier invoices and credit memos for inventory or non-inventory items that you purchase from suppliers, or if you simply have a bill to pay. You can do the following:
Supplier invoices and credit memos are source documents from which you can generate accounting. See Accounting for Supplier Invoices below.
Before you process supplier invoices, you must have the following records set up in Kenandy:
| Field | Descriptions |
|---|---|
| Create RTV Credit Memo |
If you select a supplier’s Create RTV Credit Memo checkbox, Kenandy creates a credit memo automatically when you return goods to a supplier for credit. If left blank, you need to manually record credit memos. |
| Default Currency | If you enter a remit to supplier and it has a default currency, this currency is displayed on the invoice entry page if this differs from the default currency set for your company. If you enter a purchase order rather than the remit to supplier, the currency defaults from the PO's currency. |
| Payment Terms | The selected payment terms for a supplier default to purchase orders, purchase agreements, and invoices for the supplier. Kenandy references the payment terms to calculate invoice discounts. We cover payment terms in greater detail in the Suppliers course. |
| Remittance Method |
The selected preferred method for a supplier to receive payment. The value defaults to the Payment Method field on the supplier invoice when you select the remit to supplier. |
Go to the Supplier Invoices page, then click New to create a new supplier invoice. The image illustrates the New Supplier Invoice Page, which has a header section and a line section.
We describe the default fields displayed in each of these sections below.
Company and Currency
Your default company populates the Company field, and your company’s default currency populates the Currency field. The currency changes to match the PO currency if you enter a PO, or the supplier default currency if you enter a remit to supplier.
Invoice Type and Status
Remit To Supplier and Purchase Order
Invoice Number, Invoice Amount, and Invoice Date
These are required fields.
Payment Method and Payment Terms
Payment method and payment terms default from the selected remit to supplier. When you select a PO, payment terms default from the PO if different from the supplier’s payment terms.
Payment Due Date, Discount Date, Discount Override Date
Kenandy calculates the payment due date and discount date based on payment terms when you enter the invoice date. You can override the discount date.
Hold and Memo
The image below illustrates most of the default fields displayed on an invoice line. System administrators can use the Supplier Invoice Line field set to add or remove fields or change the field order in this section. Go to the Supplier Invoice Line object to locate this field set.
Purchase Order, Line
When you match the invoice to POs, Kenandy populates these two fields. Otherwise, they’re blank.
Quantity, Order Quantity, Quantity Matched, and Quantity Received
When you match the invoice to POs, Kenandy populates these fields.
Unit Price, Purchase UOM, Amount
For invoice lines matched to a PO, Kenandy populates the unit price and purchasing UOM. For invoices not matched to a PO, you must enter a unit price, and you can enter a Purchasing UOM if you have specified an item.
Item, Description, Memo
For invoice lines matched to a PO, Kenandy populates the item and description. For invoices not matched to a PO, you can enter an item or a description if no item. You can enter a reference for the line in the Memo field.
Other Fields Available on Supplier Invoice Lines
We’ll discuss tax-related fields later in this topic.
See the supplier invoice entry scenarios below.
The image below illustrates the steps to match a new supplier invoice to a single purchase order.
Validate the invoice for approval.
The image below illustrates the steps to match a new supplier invoice to multiple purchase orders.
Validate the invoice for approval.
The image below illustrates the steps to create a supplier invoice not matched to a purchase order.
) to add an invoice line.Validate the invoice for approval.
The image below illustrates the steps to manually create a supplier credit memo. If the Create RTV Credit Memo checkbox is selected for a supplier, Kenandy generates credit memos automatically when you return goods to the supplier for credit.
Credit Memo as the invoice type.Validate the credit memo for approval.
You must validate supplier invoices before you can pay them. When an invoice is successfully validated, its status changes to Approved. You can manually validate invoices or run scheduled batch jobs to automatically validate them.
To manually validate an invoice, select Validate from the Actions menu. The image below illustrates an approved invoice, which is now eligible for payment.
If exceptions result from the validation process, Kenandy displays them on the page. Hover your mouse over the warning icon to view a summary of the issue. After you resolve the issues, you can run validation again.
Supplier Invoice Validation Batch Jobs
You can schedule the following batch jobs to automatically validate supplier invoices:
Pay the invoice. To learn more, see Supplier Payments.
Use Kenandy’s Tax Service API to connect with tax services for automatic tax calculations, or use a custom tax table to calculate tax manually.
Enter Tax Amounts
When you create a supplier invoice, you can enter the tax amount your supplier has charged you. You can enter this amount in the Charged Tax field at the invoice header level or the invoice line level.
The image below illustrates tax and VAT fields that are available on supplier invoice lines:
Kenandy's Vertex Connector supports sales tax and VAT calculations for supplier invoices. If you're using Vertex, you can do the following:
You can also estimate tax on purchase orders for approval and budgeting purposes.
Verify Tax Amounts
Verifying tax for a supplier invoice doesn’t change the tax amounts entered on the invoice. Vertex doesn’t record any information about the invoice until after you save and validate it. The amount entered in the Charged Tax field is the amount that Kenandy sends to Vertex when you verify tax amounts or record calculated tax amounts.
Record Calculated Tax Amounts and Rates
When you validate a supplier invoice, Vertex calculates the tax for the invoice and returns only the tax amount that exceeds the charged tax amount (not the total tax amount for the invoice).
On supplier invoice lines:
On the supplier invoice header:
Accrue Liability for Additional Taxes Owed
If the tax amount that Vertex calculates for a supplier invoice line is more than the amount in the Charged Tax field for that line, then Kenandy populates the difference in the Sales Tax Amount or VAT Amount fields as a positive amount. You can set up accounting rules for supplier invoices to create an accrual for this liability in a taxes payable account. For example:
If the tax amount that Vertex calculates for a supplier invoice line is less than or equal to the amount in the Charged Tax field for that line, then Kenandy doesn’t populate an amount in the Sales Tax Amount or VAT Amount fields.
Kenandy finalizes a supplier invoice when you approve it. The invoice is now ready for accounting.
Kenandy uses the term source document for transactions that are finalized, accounted, and inspected in an audit as representing the facts. Kenandy generates accounting entries from finalized source document lines, based on preconfigured accounting rules. These accounting entries are the official records of your financial transactions.
Accounting for supplier invoices differs based on these scenarios:
Kenandy provides an Accounting Workbook that illustrates these scenarios in more detail. For each scenario, the workbook shows examples of the expected accounting and the generated accounting.
You can schedule the Supplier Invoice Accounting batch job to automatically generate accounting entries for finalized supplier invoices at a specific interval and time. You configure this batch job from your company’s Scheduled Jobs page.
You can also run accounting manually on an ad hoc basis.
These drop-down menus provide several options:
| Option | Description |
|---|---|
| Save |
Saves the invoice and remains on the New Supplier Invoice page. |
| Save and Return | Saves the invoice and opens the Supplier Invoice Detail page for the invoice. |
| Save and New | Saves the invoice and opens the New Supplier Invoice page for you to create another invoice immediately. |
| Save and Validate | Saves and validates the invoice in one action. |
| Option | Description |
|---|---|
| Clone |
To expedite invoice entry, you can clone an invoice. Kenandy populates the cloned invoice with your entries from the original invoice. If a purchase order is closed for invoicing, Kenandy will not populate the purchase order or create any matched invoice lines. |
| Validate | Allows you to manually validate the invoice for approval rather than waiting for the validation batch jobs to run. |
| Unfinalize | Allows you to unfinalize a finalized invoice if it is in an open period. This option is not available if the invoice is not yet finalized or the period is closed. Kenandy finalizes supplier invoices when you validate them. |
| Cancel | Allows you to cancel the invoice if it is in an open period. |
| Void | Allows you to void the invoice if it has already been finalized and accounted. |
| Pay Invoice | Allows you to pay this specific invoice via the Create Supplier Payments page. This option is not available unless the invoice is approved. |
Note: You cannot unfinalize, cancel, or void a supplier invoice if it has been paid or partially paid.
We describe default header fields above. The following tables list additional fields that Kenandy provides. These fields display on the Supplier Invoice Detail page after you save the invoice, or are available for selection on the page layout. Your system administrator uses the page layout to select the fields that are displayed.
| Field | Description |
|---|---|
| Accounting Segments CR |
Use to specify segment values. |
| Accounting Segments DR | |
|
|
An indication of whether the document is final. An accounting entry is automatically generated for the source document in the next scheduled batch process. |
| Finalized Date | The date that the invoice was marked as final. |
|
|
This field is no longer used. |
| Historical |
An indication of whether this document was processed and accounted for before it was loaded into Kenandy. It does not generate any accounting entry lines and does not affect the GL. |
| Posting Date |
The date and time that the transaction is posted to a GL account. This field value is automatically updated with the finalized date and time. If you backdate this document by selecting a transaction date and time for a prior period, then this field value is automatically updated if the GL area for the prior period is currently open.
|
|
|
The transaction date is used for accounting purposes. It is the same as the invoice date. |
| Transaction Type | The transaction type for the supplier invoice. You use this field in accounting rules to generate the accounting entry for the supplier invoice. |
| Void | A check mark indicates that the supplier invoice has been voided. |
| Void Date | If voided, the date and time stamp indicates when the void transaction occurred. |
| Field | Description |
|---|---|
| Apply to Invoice | This field is available in the page layout but should not be displayed on the page. |
| Credit Memo Amount | The credit amount that the supplier issues. |
| Credit Memo Amount Applied | The amount of credit applied to the selected invoice. |
| Credit Memo Balance |
This field is calculated as follows: Credit Memo Amount − Amount Applied. |
| Field | Description |
|---|---|
| Always Take Discount |
An indication of whether to take the discount earned on payment terms regardless of the discount due date. The default value is inherited from the Remit To Supplier. |
| Discount Amount | The discount amount that applies to the invoice. |
|
|
Kenandy calculates this date as follows: Supplier Invoice date + Payment Terms Discount Days. |
|
|
This field triggers Kenandy to recalculate the earned discount amount. If the Discount Override Date is later than today, the Discount Earned is calculated as follows: Early Payment Rate x Invoice amount. |
| Discount Taken | The total discount taken against the invoice. |
|
|
The discount (percent) specified by the early payment terms. |
| Field | Description |
|---|---|
| Exception |
A check mark indicates that there is an error on the invoice that you must resolve before the invoice can be approved for payment. |
| Exception Details |
If the invoice has one or more exceptions, this field displays a brief description of the issue(s). Review the Exception Tasks for more information. The default supplier invoice page layout includes a section dedicated to displaying all exceptions. |
| Exception Count | The number of exceptions found on all lines. |
| Has Exceptions |
A check mark indicates that there is an error on the invoice that you must resolve before the invoice can be approved for payment. |
| Has Line Exceptions |
A check mark indicates that there is an error on an invoice line that you must resolve before the invoice can be approved for payment. |
| Line Exception Count |
The number of lines that have an exception. Review the Exception Tasks for more information. |
| Field | Description |
|---|---|
| Amount Due | This field is no longer used. |
| Amount Paid | The amount currently paid to the supplier. |
| Balance Due | The balance due on the supplier invoice. |
| Date Paid | The date that the invoice was paid in full. |
| Date Received | The date that the invoice was received, if different from the invoice date entered. |
| Days Outstanding | The number of days since the invoice date. If unpaid, this is the current date minus the invoice date. If paid in full, this is the date paid minus the invoice date. |
| Days Past Due | The number of days between due date for the supplier invoice and the date that the supplier invoice is paid. |
| Forecast Bucket |
The forecast bucket for the supplier invoice. This field indicates whether the forecast payment date for the supplier invoice is in the past or the future. Past amounts are amounts that were due, but that are not yet paid. Future amounts are amounts that you expect to pay out on dates in the future. |
| Subtotal | The invoice subtotal. |
|
|
The number of days from today to the Payment Due Date. |
| Total Extended Price | A roll-up of the Extended Price fields on the supplier invoice lines. |
|
|
The total amount due. This field is calculated as follows: Invoice Amount − Discount Amount. |
| Total Number of Lines | The total number of lines associated with the supplier invoice. |
Fields Related to Remit To Address
These fields include the supplier's Remit-to City, Country, State, Street, and Zip Code. Remittance Address is also available for display on the page layout.
| Field | Description |
|---|---|
|
Bill From and Bill To City, Country, State, Street, Zip Code |
These fields support tax calculations. |
| Charged Tax |
You enter charged tax at the invoice header level or the invoice line level. The amount in this field is sent to your tax service. |
| Charged Tax |
The total amount of tax included in the invoice that you received from the supplier. This value is aggregated from the supplier invoice lines. |
| Sales Tax Amount | The sales tax amount for the supplier invoice. This value is aggregated from the supplier invoice lines. |
| Ship From and Ship To City, Country, State, Street, and Zip Code | These fields support tax calculations. |
| VAT Amount | The VAT amount for the supplier invoice, aggregated from the supplier invoice lines. |
| Field | Description |
|---|---|
|
|
A check mark indicates that a supplier invoice is automatically generated by the Supplier Invoice Automation batch job upon receipt of goods. |
| Autonumber | An auto-generated ID that identifies the supplier invoice. |
| Batch Job ID | This field is not currently used. |
| External Id | An external ID that is used for data loading. |
| Last Visited By Batch | Displays the date and time that the Supplier Invoice Validate Draft batch last validated the supplier invoice. |
| Return To Vendor | Used by the return to vendor page. This field is available in the page layout but must not be displayed on the page itself. |
| Sales Order | Displays the sales order related to the supplier invoice, if applicable. |
| Supplier and Invoice |
A unique ID that identifies the supplier and the invoice. Supplier invoice numbers are validated against the supplier to ensure that each invoice is unique. The workflow rule: Supplier and Invoice Unique ensures that each supplier invoice is unique by validating the supplier and the invoice number. The feature can be turned off by disabling the workflow rule. |
| Supplier Invoice | The auto-generated ID for the supplier invoice. |
| Visited Last By Batch | An indication of whether a batch validated the supplier invoice. |
The following table lists the fields that Kenandy provides. Your system administrator selects the fields that are displayed on your user interface.
| Field | Descriptions |
|---|---|
| Accounting Segment |
If the subtransaction type is set to Miscellaneous, or the item is not entered, a segment is required. |
| Amount | The unit price multiplied by the number of items that were purchased. |
| Asset Adjustments | The total of the fixed asset adjustments. |
| Autonumber | An auto-generated ID that identifies the supplier invoice line. |
| Charged Tax |
The amount of tax that is shown separately on each invoice line of the invoice that you received from the supplier. You enter charged tax at the invoice level or the invoice line level. Use this field to enter charged tax at the invoice line level. The amount in this field is sent to your tax service. |
| Currency | The currency for the supplier invoice line. |
| Description |
The description of the item on the supplier invoice line or another description applicable to the supplier invoice line. For a supplier invoice with a purchase order, this field is automatically populated from the purchase order line. Otherwise, this field is automatically populated from the value of the Description field on the Item master data record. |
| Exception Details |
Issues found during the validation process. Exceptions must be resolved before the line can be processed. Review the Exception Tasks for more information. The supplier invoice page layout can be set up to include a section dedicated to displaying all header and line exceptions. |
| Exceptions Count | The total number of issues on the selected line. |
| Extended Cost | The extended cost is the unit cost multiplied by the number of items that were purchased. |
| Extended Price | The extended price is the unit price multiplied by the number of items that were purchased. If a tax amount is included in the extended price, select the checkbox for the Tax Included field. |
| External Id | An external ID that is used for data loading. |
| Finalized |
An indication of whether the document is final. An accounting entry is automatically generated for the source document in the next scheduled batch process. |
| Has Exceptions | A check mark indicates that the line has exceptions which must be resolved before the invoice can be processed. |
| Historical |
An indication of whether this document was processed and accounted for before it was loaded into Kenandy. It does not generate any accounting entry lines and does not affect the GL. |
| Invoice Line | The supplier invoice line. |
| Invoice Quantity |
The quantity billed for the supplier invoice line. For three-way matching, this field is automatically populated with the purchase order line quantity that was received less the quantity from other purchase order lines already matched to the supplier invoice line. |
| Invoice Quantity To Stock | The quantity to be moved to stock. |
| Item |
An item is not required. For invoices matched to a purchase order, Kenandy populates the item from the purchase order. For invoices without an item, the subtransaction type is automatically updated to Miscellaneous when you save the record. If tax amounts are not included in the extended price for supplier invoice lines, a line with miscellaneous item can include the total tax for the supplier invoice. If you use a tax service, this miscellaneous item must be tax exempt. |
| Line Type |
The type of supplier invoice line. In accounting rules, you can set up different accounting for different line types. |
| Matched |
A check mark indicates that the line has been matched to a valid invoice. |
| Memo | An additional note or description for the supplier invoice line. |
| Miscellaneous |
A check mark indicates that indicates a miscellaneous line item. |
| Price Exception |
A check mark indicates that the invoice unit price is greater than the PO unit price. Exceptions must be resolved before the invoice can be processed. |
| Purchase Order | The purchase order associated with the supplier invoice line. |
| Purchase Order Line | The purchase order line associated with the supplier invoice line. |
| Purchase Price |
The price of the goods received, which is calculated as follows: Purchase Order Line Unit Price x Quantity Received |
| Purchasing UOM |
For invoices associated with a purchase order, the purchasing unit of measure is inherited from the purchase order line. You can change the UOM provided the invoice has not been matched. For invoices not associated with a purchase order, you can enter a Purchasing UOM if an item has been specified. |
| Quantity Exception |
A check mark indicates that the invoice quantity is greater than the quantity received. Exceptions must be resolved before the invoice can be processed. |
| Quantity Received |
If the selected line does not have a line, Kenandy assumes a quantity of 1, and the line amount is calculated as follows: Quantity x Unit Price. |
| Quantity Returned for Credit | The quantity of items returned to the supplier for credit. |
| Quantity Returned to Supplier | The quantity of items returned to the supplier. |
| Sales Tax Amount | The sum of all actual sales tax amounts that apply to the supplier invoice line less the Charged Tax field for the supplier invoice line. This field represents the remaining sales tax liability for the line. The value in this field comes from the tax service. |
| Sales Tax Rate | The actual sales tax rate that applies to the supplier invoice line. The value in this field comes from the tax service. |
| Segment Exception |
A check mark indicates that the segment for the selected line is required but missing. |
| Subtransaction Type |
If the invoice line does not have an item, the subtransaction type is automatically set to Miscellaneous. Subtransaction types can be used in conjunction with a transaction type to determine when to generate an accounting entry. To learn more, search Kenandy Help for Accounting Rules. |
| Supplier Invoice | The supplier invoice that the selected line belongs to. |
| Supplier Invoice Line Name | The auto-generated ID for the supplier invoice line. |
| Tax Included | An indication of whether the supplier invoice line includes tax, such as sales tax or VAT, in the extended price. |
| Track as Asset |
An indication of whether the item on the supplier invoice line is tracked as an asset. Options include Yes, No, and Closed. |
| Unit Price | The price of each unit on the supplier invoice. |
| VAT Amount | The sum of all actual VAT amounts that apply to the supplier invoice line less the Charged Tax field for the supplier invoice line. This field represents the remaining VAT liability for the line. The value in this field comes from the tax service. |
| VAT Rate | The actual VAT rate that applies to the supplier invoice line. The value in this field comes from the tax service. |
_________________________________
To search the KnowledgeBase and documentation, ask a question, or log a case, please visit the Kenandy Community. To access our online training, visit the Kenandy Learning Center.
Version: Spring 2017