Vendor Invoices Overview

The vendor invoice system integrates tightly with the purchase/media order system so that  order details can be easily pulled onto a vendor invoice. It helps the Accounts Payable processing system for recording expenses to projects as well as administrative invoices.

Each vendor invoice has an approval status on it. Only approved vendor invoices can be paid using the check or credit card processing system.  It is possible to set up your system to bypass the approval process if desired. In the System Setup screen, Transaction Preferences options, you're able to set your approver options which allow you to automatically approve vendor invoices when they are created. In order to use this functionality, you must also have the ability to edit accounting transactions after they have been approved. Once a vendor invoice has been approved, you may select it for payment and add individual line items onto client invoices.

Vendor credits are also entered as vendor invoices to the system. To create a vendor credit, you only need to make the vendor invoice amount negative. If the total amount of the vendor invoice is negative, you'll be able to apply this vendor invoice to other vendor invoices as a credit or add the vendor credit onto payments to reduce the overall amount of payment.

If you are posting WIP and creating vouchers that are not connected to orders, please be aware that you are able to select Purchase Items, Expense Report Items and Media Items from the drop-down menu. Even if contained on the same Voucher, the amounts will be sorted according to specific categories based upon the where the items are set up in Workamajig.

New Vendor Invoice

Menu>Purchasing>Today-Purchasing>+ >Vendor Invoice
Top right corner: + >Purchasing>Vendor Invoice

 

The initial entry screen for a vendor invoice is to enter the header information of the vendor invoice:

Vendor: select vendor from dropdown list

Order Number: (optional) after selecting a vendor, the  dropdown list will contain open orders for the vendor. This will restrict the next screen to open order lines for the select order. If left blank, the order line select will contain all open orders for the vendor

Invoice Number: enter the number provide by the vendor

Invoice Date: enter the invoice date on the vendor invoice. This will also be used to set the Posting Date of the vendor invoice.

Overhead: (optional) this defines the invoice as overhead, thus eliminating the requirement to have a project associated with the line

Project: (optional) select project from dropdown list. Typically the order will define the project connection. This is used for vendor invoices that will be created with connection to an order. Each line added to the invoice will use the selected project.

Click NEXT to move onto the Line entry or order line selection.

Depending on the what was selected in the initial step, the next screen will either be blank for you to begin manually adding invoice lines or selecting order lines

Add Invoice Lines

Manual

Click Insert Line: this will allow you to enter in the fields related to project, task, item, etc.

Click SAVE or click outside of the line to save the line.

NOTE: when in grid entry mode, you can tab to the next field. When you tab past the last field the system will auto-add a new line.
Admin NOTE: click on ...more>System Settings to define the column/column order of the grid.

Select Orders

If an order was not selected on the initial screen, click the LINES: + icon to select Add Insertion Order/Add Broadcast Order/Add Purchase Order/Add Labor (for contractor labor)

If an order was selected the "Next" screen will display the open orders lines as seen below

 

Selecting Orders

The Select "xx" Order screen will allow you to select a specific open order line to add to the Vendor invoice.  There are a number of fields that are editable, but there are 4 main fields that should really be of concern

1) check box (far left): select the order line that you wish to connect to the vendor invoice.

2) Close: if this is the final invoice for the open order line, check the box. NOTE: If the open net entered is equal to or more than what is displayed in open net field, the system will auto-close the order line.

3) Open Net: enter the value sent on the vendor invoice.

4) Amount To Bill: enter an amount to bill. NOTE: The system will auto calculate this field based upon if the order line was prebilled or not and the commission/markup defined on the order.

Other Fields to Consider

Quantity: enter the quantity found on the sent vendor invoice. The system will use this number to calculate the Open Net and Amount to Bill fields.

 

SAVE: after selecting and editing the lines as needed, click SAVE

 

Prior to Approval/Posting

Before the vendor invoice is approved/posted, in the top right corner under Summary, any available unapplied payments and/or credits will be available to apply towards the invoice.

Click on the blue 0.00 value to see a list that can be selected and applied

 

Once selected, from the main vendor invoice page, click on Approve or Submit.

 

Applying Credit To Invoice

 

RESTRICTIONS

Only Credits from the same company are visible in the list.

VALIDATIONS

The total amount applied to the vendor invoice must be less than or equal to the total of the Credits and the applied payments.

The amount available to apply is the total amount of the Credit less the amount applied out to other invoices. The total applied to other invoices cannot exceed the total amount of the credit.

 

Vendor Credits

Vendor credits are input into the system as negative invoices. The system allows you to select purchase orders onto a vendor invoice and still put in a large negative line item to create an overall vendor credit. When the total amount of a vendor invoices negative, you'll be able to apply the open amount of the credit to other invoices.  You can also take a vendor credit on a payment to a vendor. This will reduce the overall amount due to the vendor. The system allows you to apply a part of the credit directly to another invoice and another part of the invoice to be taken on a payment to a vendor.

Schedule Vendor Invoice

From the main vendor invoice page, click ...more>Schedule

This will allow you to setup a time interval, etc. for the invoice to be replicated in the system.

The invoice date of the current invoice is used as the starting point for generating future invoices. 

After the invoices have been generated, the system will show all invoices and will allow you to perform several actions and give you quick access to all related recurring invoices.

Initially, all invoices are created with the same status as the initial invoice. You only need to submit the first invoice for approval and all other invoices will be approved with it.  You can then go to any other invoice in the list, un-approve it and change it if needed. There is no difference between a recurring invoice and a normal invoice. Once changes have been made, that invoice will need to be approved separately.

If you change one invoice, you can select to apply these changes to selected invoices if they have not been posted or have been modified to be linked to purchase orders applied to them. Select the Update Using this Invoice from the drop-down list, check the invoices you want to update and click on the GO command button. The system will update these selected invoices with the details from the current invoice.

You can also delete selected invoices by clicking the checkbox next to each invoice to delete and then select Delete from the drop-down box and click on GO.

Payments 

The Payments tab has two sections, the Applied Prepayments section and the Applied Payments. The applied prepayments show up when there are any payments for the vendor with unapplied open amounts but have been posted to the GL to an Unapplied Payment Account.

To apply a prepayment or cash advance to an invoice, you can select the payments tab. Any posted payments will appear in this list. To post a payment without applying it to an Invoice, the user will have to select an Unapplied Payment Account. The users can then select payments and apply them to the invoice to reduce the open amount.

RESTRICTIONS

• Only posted payments are visible.
• Only payments for the same company are visible.
• You can only select prepayments before the vendor invoice is posted.

VALIDATIONS

• The total amount applied to the vendor invoice must be less than or equal to the total amount of credits applied and the total amount of payments applied (either as prepayments or as payments).
• The total amount applied from a particular payment must be less than or equal to the total amount of the payment less the amount already applied to vendor invoices.

The applied Payments section will show any payments that have been applied to this vendor invoice.