Process multiple purchasing transactions

Use the Process transactions page to convert one transaction into two or more transactions

To convert multiple purchasing documents or purchase line items into a single purchase transaction, see Convert multiple documents into a single purchase transaction).

Convert a transaction into two or more transactions

You can divide a transaction into two or more transactions by line item. Each selected line item will be processed into a new transaction.

For example, if you select three line items from one purchase order and choose to create receivers, Intacct creates three new receivers.

  1. Go to Purchasing > All > Other transaction activity > Process transactions.

  2. In the Filters section, use the selection list to select the applicable Create transaction. For example, if you want to split line items from one purchase order into two or more receivers, you would choose Receiver in this field.
  3. Select the Supplier that's associated with the transaction you want to split.
  4. In the Process by field, select Lines.
  5. In the Process type field, select Individual.
  6. Set other filter criteria as needed.
  7. Select View.

    The Process transactions page displays the default Transaction details and lists the Available line items. If the needed line items do not appear in the Available line items list, select Customize to return to the Filters section and change the filter criteria.

  8. Edit the Transaction details fields as needed.
  9. Select the checkbox to the left of each transaction line item that you want to split into a new transaction.
  10. Edit the selected line item details as needed.
  11. Select Create.

    The system displays the message, "Successfully created <#> transactions."

Field descriptions

The following tables describe each field on the Process transactions pages.

Filters

Filters field descriptions
Field Description

From transaction date and To transaction date

Use the calendar tool to specify the range of dates that include the transactions you want to split or merge:

  • From transaction date: The start of the date range.
  • The To transaction date: The end of the date range.

From item and To item

Use the Item selection list to specify a range of items by which to filter the transactions. For example, you could filter by hardware items that are numbered HW001 to HW299.

Create transaction

The type of transaction you want to create. For example, if you want to split a purchase order into two receivers, select Receiver. This field is required.

From transaction

The type of source transactions you want to use to create new transactions. For example, if you want to split a purchase order into two receivers, select Purchase Order.

The From transaction selection list only displays the transaction types from which the transaction type selected in the Create transaction field can be created. If you do not see the needed transaction type in the selection list, try changing the transaction type in the Create transaction field.

Supplier

Use the selection list to filter transactions for a specific supplier. This field is required.

Transaction currency

Filters the list of transaction items to display only the items that are associated with the selected transaction currency. This field is only applicable to multi-currency companies.

Process by

Indicate whether to act upon transaction line items or the entire transaction.

If you want to merge a transaction, you can choose either Lines or Transactions.

If you want to split a transaction into two or more transactions, you must select Lines.

Process type

Indicate whether you want to merge (Merge) or split (Individual) transactions.

Maximum number of records to select

Displays only records (lines or transactions ) up to the number of specified. For example, if this field is set to 50 and you have 10 transactions containing 10 lines, only the first 5 transactions display.

If you have transactions which contain a high number of transaction lines, it might take some time to generate results.

Transaction details

Transaction details field descriptions
Field Description

Supplier

Displays the supplier selected in the Filters section. If you do not see the supplier that you want, select Customize to reset the filters.

Transaction type

Displays the transaction type selected for the Create transaction in the Filters section. If do not see the transaction type that you want, select Customize to reset the filters.

Processing

Displays the Process by and Process type selected in the Filters section. If you don't see the process type that you want, select Customize to reset the filters.

Document number

Yet to be created. The system generates a new document number when you select Create. This field only appears in the Transaction details section if you selected Process type = Merge in the Filters section.

Reference number

Enter a reference to another document or any text as needed. This field only appears in the Transaction details section if you selected Process type = Merge in the Filters section.

Date

Defaults to today's date. Use the calendar tool to change this date as needed. This field is required.

Payment terms

Select the term from the dropdown list.

Due date

The Ship date (purchase orders or receivers) or Date due (PO purchase invoices) for the new transaction. If you selected a Payment term, this field defaults to the applicable date based on the term.

Pay-to contact

Defaults to the contact that is identified as the Pay-to contact on the selected supplier record. This field label is customizable in the transaction definition and might be something other than Pay-to. If the transaction definition allows editing on this field, you might be able to select a different contact record. This field is required.

Return-to contact

Defaults to the contact identified as the Return-to contact on the selected supplier record. This field label is customizable in the transaction definition and might be something other than Return-to. If the transaction definition allows editing on this field, you might be able to select a different contact record. This field is required.

Currency

Displays the Transaction currency selected in the Filters section. If you do not see the currency that you want, select Customize to reset the filters. This field is only applicable to multi-currency companies.

Exchange rate date

The date the exchange rate used by the new transaction is valid. Defaults to today's date. Use the calendar tool to select a different date. This field is only applicable to multi-currency companies.

Exchange rate type

Defaults to the exchange rate type defined in the transaction definition for the selected transaction type. If the transaction definition is set to allow user override of the exchange rate type, you can use the selection list to select a different exchange rate type. This field is only applicable to multi-currency companies.

Exchange rate

Defaults to the exchange rate for the selected Transaction currency (if that currency is different from the base currency) based on the date entered in the Date field. If the transaction definition is set to allow user override of the exchange rate, you can edit this field. This field is only applicable to multi-currency companies.

Default department

This field only appears if the value of Process by is Lines and the transaction definition allows the user to override department. Use the Department selection list to select the applicable department.

Default location

This field only appears if the value of Process by is Lines and the transaction definition allows the user to override location. Use the Location selection list to select the applicable location. This field is required for multi-entity, multi-currency companies. The Location/Entity base currency must match the transaction base currency.

Default warehouse

Use the Warehouse selection list to select the applicable warehouse as needed. This field is only applicable if your company subscribes to Inventory Control.

Available transactions or line items

Available transactions or line items field descriptions
Field Description

Doc number

Unique identifier for the corresponding transaction. Select the link in this field to view the source transaction.

Date

The transaction date for the corresponding transaction.

Due date

The Ship Date (purchase orders or receivers) or Date Due (PO purchase invoices) for the corresponding transaction.

Total amount

The total value of the corresponding transaction expressed in the transaction currency.

If Process by = Lines and Process type = Merge, the following additional fields display.

Available transactions or line items if Lines and Merge field descriptions
Field Description

Item ID

Unique identifier for the corresponding transaction line item.

Warehouse ID

Might default to the warehouse associated with the corresponding transaction item. Use the Warehouse selection list to select the applicable warehouse as needed. This field is only applicable if your company subscribes to Inventory Control.

Original qty

The initial quantity of the corresponding transaction line item.

Remaining qty

The quantity of the corresponding transaction line item that has not been converted.

Transaction qty

The quantity of the corresponding transaction line item that you want to convert in the split or merge function.

Unit

The unit of measure of the corresponding transaction line item. Learn more about units of measure.

Serial, lot, and bins

Select the plus icon to add serial numbers, lot numbers, expiration dates, or bin information for a line item. This icon only appears if you have enabled tracking in the Configure Inventory Control page.

Price

The price per base unit for the corresponding transaction line item. If the transaction definition has Line-item price enabled (in the User overrides section), you can edit this field.

Department

This field only appears If the transaction definition allows the user to override department. Use the Department selection list to select the applicable department.

Location

This field only appears If the transaction definition allows the user to override location. Use the Location selection list to select the applicable location. This field is required for multi-entity, multi-currency companies. The Location/Entity base currency must match the transaction base currency.

If Process by = Lines and Process type = Individual, the following additional fields appear.

Available transactions or line items if Lines and Individual field descriptions
Field Description

Process to

The transaction type that you want to create from the corresponding transaction line item. This field defaults to the transaction type that you selected in the Create transaction field in the Filters section.

Doc number

If the transaction definition has a Numbering sequence selected, this field displays NEW and is not editable. If the transaction definition does not have a Numbering sequence selected, this field appears in edit mode. Enter a unique identifier for the new transaction.

Supplier doc number

The number by which to reference the AP supplier invoice or other document from a supplier.

Reference number

Enter a reference to another document or any text as needed for the applicable transaction line items.