Changes in the Vendor Invoice Journal Lines for Settlement Payments and Purchase Advance

By Levridge staff | Published: Aug 9, 2023 | Product Updates | read

In 2023 R1 and R2, Levridge is changing how transactions work on the vendor invoice journal. You can now add a vendor invoice number to the settlement payment and purchase advance. Not only does this help with documentation, but it also provides that information to the vendor when the payment is made.

Pictured below are the updated forms with the vendor invoice number field.

Screenshot of commodity settlement wizard. Vendor invoice number is circled in red.

Screenshot of Commodity settlement requests. Vendor invoice number is circled in red.

Screenshot of Settlement payments. Vendor invoice number is circled in red.

Screenshot of Purchase advances. Vendor invoice number is circled in red.

Changes in the Vendor Invoice Journal Lines

We have changed the way vendor invoice journal lines are created. In the past, the fee, discount, purchase advance, etc., had their own voucher number and the invoice number was the settlement request number. This was used to differentiate them. All the lines have the same voucher number now; the invoice number is the vendor invoice number inputted by the user. If the user doesn’t provide the vendor invoice number, then the invoice number on the vendor invoice journal line is the Settlement Request ID. The new lines do not have an offset account, and the account type for a fee or discount is no longer vendor. This account type is now ledger, with the account that was previously used in the offset account.

If the fee or discount reduces the amount you owe to the vendor, then it’s a credit. If it’s a premium or adding to what you owe the vendor, then it’s a debit. The gross amount on the settlement is now added as a debit, with the account type as ledger. This uses the account that was used in the offset account before. The net amount line is added as credit to the vendor invoice journal with a vendor type.

If a purchase advance is used on the settlement, it has an account type of ledger and it uses the same account used in the offset account earlier.

In the case of a split payment, an additional voucher is created for each payment. The gross amount on the settlement is subtracted from the total amount of additional split payments on the settlement. The invoice number on the split payments will have unique identifiers to differentiate the split payments from the original settlement.

Pictured below are the changes in the vendor invoice journal lines:

Old Invoice Journal Lines

Screenshot of vendor invoice journal rows

New Invoice Journal Lines

Screenshot of vendor invoice journal rows