/
Invoice Linking in TDEU001

Invoice Linking in TDEU001

Search the Qbyte Financial Wiki
 

 

Enhancement Summary – Release 11.5

Introduction

In Release 11.5, Qbyte Financial has introduced enhanced invoice linking capabilities. This will allow for users to see all lines coded to an invoice through its lifecycle.



Screen

Users can link any line coded in the Voucher Entry Upload (TDEU001) to an invoice using the Source Invoice ID column.

Enter the following information in the TDEU001 spreadsheet. All fields will require entry in order to link offsetting lines to an invoice:

IN THIS FIELD...

ENTER THIS INFORMATION...

IN THIS FIELD...

ENTER THIS INFORMATION...

Source Invoice ID

  • Enter a numeric value

  • Numbering typically starts with '1'

  • If this invoice is new, Qbyte Financial will assign an invoice ID from a sequence

  • Required for linking offsetting line items to invoice lines for the duration of an invoice



Process

To link an offsetting line to an invoice, enter a numeric value in the Source Invoice ID column. Multiple invoices can be coded to in an upload voucher. Lines coded to each invoice must balance to $0 in the voucher.

When adjusting an invoice, if a value does not exist in the Source Invoice ID column, a warning message will occur during validation alerting the user that the invoice will not be linked:



Validations

The following errors may arise upon validating the voucher:

If all lines coded to an invoice do not balance to $0, users will receive the following error:



Appendix A – Examples

Creating an Invoice with Invoice Linkage

Step 1 – Enter the invoice line. The Enter ‘Y’ to create New Invoice column must have either a Y or be blank, and the Source Invoice ID column must have a numeric value.

Step 2 – Enter expense line information related to the invoice. To link the expense lines to the invoice, the value in the Source Invoice ID column must be the same as the invoice.

Step 3 – Repeat for additional invoices. Any additional invoices will have a different value in the Source Invoice ID column

When submitting a Voucher Coding Report, note each invoice has all lines linked:

Adjusting an Invoice with Invoice Linkage

Step 1 – Enter a $0 invoice line. The invoice line is required to link to the original invoice. The Enter ‘Y’ to create New Invoice column must have N, and the Source Invoice ID column must have a numeric value.

Step 2 – Enter expense line information related to the invoice. To link the expense lines to the invoice, the value in the Source Invoice ID column must be the same as the invoice.

Step 3 – Repeat for additional invoices. Any additional invoices will have a different value in the Source Invoice ID column

When submitting a Voucher Coding Report, note each invoice has all lines linked:


Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.