Creating Vouchers or Adjustments Automatically
There are two ways to automatically generate vouchers or adjustments:
- Configure the Auto Voucher feature for each vendor.
- Use the Generate A/P Transactions form, as described here.
To automatically create vouchers or adjustments using the Generate A/P Transactions form:
- Open the Generate A/P Transactions form.
-
To display receipts for purchase order lines:
-
Select the vendor whose invoice you are entering and then click
Filter-In-Place.
In the grid, vendor/currency combinations are displayed, so you can select one to work with. This determines the purchase orders for which receipts will be vouchered and also filters the other activities, such as PO Selection and Additional Material Selection.
-
Do one of the following:
- To create a voucher for received purchase order lines, select the Voucher option.
- To create an adjustment to an existing voucher for returned items, select the Adjustment option.
- If you selected the Adjustment option, in the Voucher field, select the existing voucher number.
- In the G/L Dist field, select a date or accept the default, which is the current date. The date is the record date of the accounts payable transaction.
- To link the new voucher to a voucher pre-register, select the voucher pre-register number, and then select OK.
- Select the Additional Material Selection tab.
-
To voucher purchase order lines:
- Select the Generate from PO check box.
- Select the range of purchase orders you want to use.
- Select the
lines/releases you want to use.
Note: If the unit of measure of a purchase order line item was changed to something other than the original unit of measure listed on the Items form, the Generate A/P Transactions utility uses the original unit of measure to validate the data.
-
To voucher GRN lines:
- Select the Generate from GRN check box.
- Select the range of GRNs appearing in the invoice.
- (Optional) Select the range of GRN line numbers appearing in the vendor's invoice.
- (Optional) Select the range of purchase order numbers appearing in the vendor's invoice.
-
To voucher EDI invoices:
Selecting the Generate from EDI Invoices check box clears any values currently in the Generate from PO and Generate from GRN fields of the Additional Material Selection tab and disables those fields.
- Select the Generate from EDI Invoices check box. This field is disabled if the vendor is not set up for EDI transactions or if there are any pending transactions currently on the Material tab or the Taxes tab.
- Select an invoice.
- To include GRN lines, select the Received via GRN check box and select a GRN number in the GRN field.
- Select Select Matching. Receipts for purchase order lines display in the browser on the Material tab.
-
Select the vendor whose invoice you are entering and then click
Filter-In-Place.
-
Edit the lines to reconcile receipts with the vendor's invoice.
When you edit receipt lines, the amount in the Total field on the Material tab is automatically recalculated.
- Delete any purchase order receipt lines or GRN lines in the Material tab that are not referred to in the vendor's invoice.
- In the To Vch/Adj field, modify (as required) the number of units of each line item to include in the voucher, or accept the default value of the quantity received minus any quantity previously vouched for the purchase order line or GRN line.
- Modify (as required) the unit cost of each line, or accept the default value.
-
Create pending tax transaction lines for the received purchase
orders.
The Taxes tab is enabled when the Active for Purchasing check box is selected on the Tax Systems form for at least one tax system.
If the Taxes tab is disabled, you can enter tax amount(s) from the vendor's invoice, or other amounts as required, in the Sales Tax field(s) on the header.
- Select the Taxes tab.
-
Select
Generate Tax. The
activity calculates the sales tax for each pending voucher line on the
Material tab and creates
a pending tax transaction line for each purchase order on which tax is owed.
The activity displays the total of the line amounts in the
Sales Tax field(s) on
the
Taxes tab and provides
the option of copying the sum(s) to the header.
Note: The label for the Sales Tax field is user-defined.
- To add a tax amount that was not created in the generation process, create a new tax transaction line.
-
Enter payable amounts in the voucher header:
- In the Material field on the header, enter the amount displayed in the Total field on the Material tab. Amounts in the two fields must be equal. The amount should be equal to what is specified on the vendor's invoice.
- In the Freight and Misc Charges fields on the header, enter amounts from the vendor's invoice or as required.
- If you have not already entered sales tax on the header, do so now. Sales Tax amount(s) on the header must equal the total(s) on the Taxes tab.
- If you are creating a non-EDI voucher or adjustment, select the General tab and enter the required information.
-
To generate the voucher or adjustment, click
Generate.
The new voucher number appears in a message when processing is complete.