AR AutoAccounting Upload  Help

AR AutoAccounting Upload creates and updates the Receivables AutoAccounting definitions from Excel, the same setup as the Automatic Accounting form (Receivables > Setup > Transactions > AutoAccounting). For each account type you define, segment by segment, whether AutoAccounting takes the value from a table such as Transaction Types, Salesreps or Standard Lines, or uses a constant value.

When to use it

• Set up AutoAccounting for a new operating unit, or copy the definitions of one operating unit to another.
• Review all AutoAccounting definitions of your operating units in one sheet.
• Change the source of a segment across several account types in one step, for example after a chart of accounts change.

Before you start

• EBS R12.
• Access to the upload from the AutoAccounting form, or from a responsibility with Blitz Report upload access. Your responsibility must have access to the operating units you maintain.
• Receivables system options are defined for each operating unit, so its chart of accounts is known.

Choose a template

The default template is Default.

Step 1 – Set the parameters

Open AR AutoAccounting Upload in Blitz Report, choose the template and set the parameters:

Step 2 – Run to download the Excel file

Click Run. The Excel file opens with one row per segment of each AutoAccounting type, in the order of the chart of accounts segments.

Step 3 – Enter or change the definitions

• Operating Unit, Type and Segment identify the row. Segment is the name of a segment of the operating unit’s chart of accounts.
• Enter either a Table Name or a Constant, not both. The Table Name list offers only the tables allowed for the type, as in the form. The Constant list offers the values of the segment’s value set, and Description shows the description of the constant.
• To define a new type, enter one row for every enabled segment of the chart of accounts.
• The descriptive flexfield of a type is taken from its first row.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and that each row has either a table name or a constant, then saves the file.

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request.

Step 6 – Review the result report

When the request completes, a result report opens listing every row with its status and message, and the values as they are now stored, for example “AutoAccounting type created. Segment Company created.” or “No change.”.

What’s produced

• New or changed AutoAccounting definitions, exactly as the Automatic Accounting form stores them.
• A result report listing every row with a status (success or error) and a message.

Common questions

Why were rows not saved that had no error of their own?
Each AutoAccounting type is saved as a whole. When one row of a type fails, or the type is incomplete after the upload, none of its rows are saved and the other rows show “Not saved because of errors in other rows of type …”.

Why did the balancing segment of my Tax and Freight definitions change?
As in the form, changing the balancing segment of the Revenue or Receivable type also changes the balancing segment of the Tax, Freight, Unbilled Receivable, Unearned Revenue and AutoInvoice Clearing types. The message of the changed row says so.

How are dependent segments handled?
A segment whose value set depends on another segment must use the same table name as its parent segment, or, when the parent has a constant, a constant that is valid for the parent value.

Can I delete an AutoAccounting type?
No. Delete types in the Automatic Accounting form.

Troubleshooting