Download Mass Additions

You can download transactions using either Download by Sheet or Download by Form. Simply enter the criteria to filter the transaction you are after.

Filter

Description

Book (Required)

Single Book Processing: You can only download and process data for one Asset Book at a time.

Security Restricted: Access is limited to only those Asset Books assigned to your Security Profile.

Corporate Books Only: The Payables-to-Assets interface exclusively supports Corporate Books; Tax Books are not directly accessible for mass additions from AP.

Queue

You can download the following queues: New, On Hold, Post, Merged and Error.

Queues Posted, Delete and Split have been excluded since they cannot be updated by the Intergrator.

Category

This list will be limited to categories that have been enabled for the Book.

GL Segment1

This will enable you to filter by the first segment of Source line Clearing account (See Mass Additions Limitations section).

GL Segment4

This will enable you to filter by the fourth segment of Source line Clearing account (See Mass Additions Limitations section).

Source

This will default with ORACLE PAYABLES, but you can select others if required.

Mass Additions ID From/To

From/To using Id’s. Note: It is not possible to enter a range in Download by Sheet. It is possible to enter multiple ID’s as a list.

Which records are downloaded?

The system pulls records from the Error, New, On-Hold, Post, and Merged queues.

However, please note the following exceptions:

  • Posted/Deleted: These are never included in the download.

  • Zero-Amount Merged Records: If a record is in the "Merged" queue but has an amount of zero, it will be skipped. These are normally Tax lines.

  • System Source: While the source is set to Oracle Payables by default, you can override this setting if necessary.