AIM

BR.100 CASH MANAGEMENT APPLICATIONS SETUP

Agilent Technologies
Cash Management

Document Control and Approval

VersionsofthisdocumentpriortoitsimportintotheKnowledge
Portalareconsidereddraftversions.Toaccessrevisionhistory
anddocumentownershipinformation,clickhereandthenselectthe

Contents

Application Setup Control Sheet - Cash Management.......................................1

CE: Define System Parameters.........................................................................2
CE: Define Bank Transaction Codes.................................................................4
Open and Closed Issues for this Deliverable......................................................9
Open Issues..................................................................................................9
Closed Issues................................................................................................9

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page ii of 16
Rev 2

Application Setup Control Sheet - Cash Management

Environment Name:

WorkFlow
Sub Workflow
Name

Setup Task

Machine:

Type (definition, execution, or both):

Responsibility

Due
Date

QA Responsibility QA Due
Date

Signature Approval

Cash
Management
Setup
CE: Define System
Parameters
CE: Define Bank
Transaction Codes

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 1 of 16
Rev 2

CE: Define System Parameters

Cash Management>Setup>System Parameters
Business Area:
<Customer Short Name> Process:
<Business Area>
<Process Name>
Control Number:
Priority(H, M, L):
<Priority (H, M, L)>
<Control Number>
Description: Use this form to define System Parameters for cash management reconciliation.
<System Parameters> For all OUs
OU respective
Set of Books

Date:
<Date>
Process Owner:
<Process Owner>

Show Cleared Transaction No (uncheck)

Begin Date

01-JAN-1991

Add Lines to Automatic

Statement

No (uncheck)

Use Open-Interface

No (uncheck)

Show Void Payments

Yes (check)

Float Handling

Ignore

Transaction

AR

Transaction

Yes

Archive

Yes

General
Main:
Receivable Activity
Matching Order:
AP
Archive/Purge:
Purge

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 2 of 16
Rev 2

100

Lines per commit

Automatic Reconciliation
Tolerance:
Amount

Percent

1%

Charges

Foreign

Gain/Loss

Corporate

Exchange Rate Date

Statement Line

Tolerance Differences:
AP
Foreign Currency Bank
Exchange Rate Type

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 3 of 16
Rev 2

CE: Define Bank Transaction Codes

Cash Management>Setup>Bank Transaction Codes
Business Area:
<Customer Short Name> Process:
<Business Area>
<Process Name>
Control Number:
Priority(H, M, L):
<Priority (H, M, L)>
<Control Number>
Description: Use this form to define system parameters for cash management reconciliation.

Date:
<Date>
Process Owner:
<Process Owner>

<Bank Account> FOR ALL Citi AP ACCOUNTS OTHER THAN FUJI AND BANK OF AMERICA ! *
Number

Name

Bank Name

Bank Branch

Currency
Type
Receipt

Code

Description

Receipt

109 Check Deposit/Wholesale

Lockbox
142 Giro Credit

Receipt

175 Check Deposit

Receipt
Receipt

191 Individual Incoming

Internal Money Transfer
195 Incoming Money Transfer

Misc Receipt
Receipt

196 Money Transfer Adjustment

212 Foreign Letter of Credit

Start

End

Float
Days

Trans
Source

Matching
Against

Create

Activity

AR
Receipts
AR
Receipts
AR
Receipts
AR
Receipts
AR
Receipts
Misc
AR
Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 4 of 16
Rev 2

Pay Method

Type

Code

Description

Start

End

Float
Days

Trans
Source

Matching
Against

Create

Activity

Pay Method

Treasury
Sweep
Interest
on Bank
Account

AP_
Transactions
AP_
Transactions

Receipts
AR
Receipts

Receipt

213 Letter of Credit

Misc Receipt

275 ZBA Credit

Misc

Yes

Misc Receipt

354 Interest Credit

Misc

Yes

Receipt
NSF
Receipt

366 Currency and Coin

Deposited
395 Check Reversal
399 Unidentified Item Credit

Payment

463 ACH Payment Total

Payment

470 Paylink Check

Payment

475 Check Paid

Payment

491 Individual Wire Payment

Payment

495 Bulk Wire

Payment

500 Total Direct Debits

Misc Payment

564 Overdraft Fee

Misc

Yes

AP Bank
Charges

AP_
Transactions

Rejected
Misc Payment

566 Return Item

577 ZBA Debit Transfer

Misc

Yes

Misc Payment

654 Interest Debit

Misc

Yes

Treasury
Sweep
AP Bank

AP_
Transactions
AP_

AR
Receipts
AR
Receipts
AP
Payments
AP
Payments
AP
Payments
AP
Payments
AP
Payments
AP
Payments

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 5 of 16
Rev 2

Type

Code

Description

Misc Payment

698 Miscellaneous Fees

Payment

699 Unidentified Item Debit

Start

End

Float
Days

Trans
Source

Matching
Against
Misc

Create

Activity

Pay Method

Yes

Charges
AP Bank
Charges

Transactions
AP_
Transactions

AP
Payments

Receipt

121

EDI Transaction Credit

AR
Receipts

Receipt

147

Individual Bank Card

Deposit

AR
Receipts

Receipt

174

Other Deposit

AR
Receipts

Receipt

206

Book Transfer Credit

AR
Receipts

Receipt

218

Foreign Collection Credit

AR
Receipts

Receipt

222

Foreign Checks Deposited

AR
Receipts

Receipt

252

Debit Reversal

AR
Receipts

NSF

255

Check Posted And

Returned

AR
Receipts

Receipt

266

Return Item

AR
Receipts

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 6 of 16
Rev 2

Type

Code

Description

Start

End

Float
Days

Trans
Source

Receipt

357

Credit Adjustment

Misc Receipt

398

Miscellaneous Fee Refund

Payment

450

Total ACH Debits

AP
Payments

Payment

451

ACH Debit Received

AP
Payments

Payment

471

Total Checks Paid

AP
Payments

Payment

506

Book Transfer Debit

AP
Payments

Payment

552

Credit Reversal

AP
Payments

Payment

555

Deposited Item Returned

AP
Payments

Payment

557

Individual ACH Return

Item

AP
Payments

Misc Receipt

567

Return Item Fee

Payment

631

Debit Adjustment

Matching
Against

Create

Activity

Pay Method

Yes

AR Bank
Charges

Manual
Payment

AR Bank
Charges

Manual
Payment

AR
Receipts

Misc
AP
Payments
Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 7 of 16
Rev 2

Type

Code

Description

Start

End

Float
Days

Trans
Source

Payment

694

Deposit Reversal

AP
Payments

Payment

901

WHT/GST/VAT/EXCISE

AP
Payments

Receipt

369

Clearing Settlement Credit

AR
Receipts

Matching
Against

Create

Activity

Pay Method

Create

Activity

Pay Method

<Bank Account> FOR ALL Citi AR ACCOUNTS OTHER THAN FUJI AND BANK OF AMERICA ! *
Type
Receipt
Receipt

Code

Description

Start

End

Float
Days

109 Check Deposit/Wholesale

Lockbox
142 Giro Credit

Trans
Source

Matching
Against

AR
Receipts
AR
Receipts

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 8 of 16
Rev 2

Type

Code

Description

Start

End

Float
Days

Trans
Source

Matching
Against

Create

Activity

Pay Method

Treasury
Sweep
Interest
on Bank
Account

Manual
Payment
Manual
Payment

Receipt

175 Check Deposit

AR
Receipts
AR
Receipts
AR
Receipts

Receipt
Receipt

191 Individual Incoming

Internal Money Transfer
195 Incoming Money Transfer

Misc Receipt
Receipt

196 Money Transfer Adjustment

212 Foreign Letter of Credit

Receipt

213 Letter of Credit

Misc Receipt

275 ZBA Credit

Misc

Yes

Misc Receipt

354 Interest Credit

Misc

Yes

Receipt
NSF
Receipt

366 Currency and Coin

Deposited
395 Check Reversal
399 Unidentified Item Credit

Payment

463 ACH Payment Total

Payment

470 Paylink Check

Payment

475 Check Paid

Payment

491 Individual Wire Payment

Payment

495 Bulk Wire

Misc
AR
Receipts
AR
Receipts

AR
Receipts
AR
Receipts
AP
Payments
AP
Payments
AP
Payments
AP
Payments
AP
Payments
Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 9 of 16
Rev 2

Type

Code

Description

Start

End

Float
Days

Trans
Source

Matching
Against

Create

Activity

Pay Method

Payment

500 Total Direct Debits

AP
Payments

Misc Payment

564 Overdraft Fee

Misc

Yes

AR Bank
Charges

Manual
Payment

Rejected
Misc Payment

566 Return Item

577 ZBA Debit Transfer

Misc

Yes

Misc Payment

654 Interest Debit

Misc

Yes

Misc Payment

698 Miscellaneous Fees

Misc

Yes

Treasury
Sweep
AR Bank
Charges
AR Bank
Charges

Manual
Payment
Manual
Payment
Manual
Payment

Payment

699 Unidentified Item Debit

AP
Payments

Receipt

121

EDI Transaction Credit

AR
Receipts

Receipt

147

Individual Bank Card

Deposit

AR
Receipts

Receipt

174

Other Deposit

AR
Receipts

Receipt

206

Book Transfer Credit

AR
Receipts

Receipt

218

Foreign Collection Credit

AR
Receipts

Receipt

222

Foreign Checks Deposited

AR
Receipts

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 10 of 16
Rev 2

Type

Code

Description

Start

End

Float
Days

Trans
Source

Receipt

252

Debit Reversal

AR
Receipts

NSF

255

Check Posted And

Returned

AR
Receipts

Receipt

266

Return Item

AR
Receipts

Receipt

357

Credit Adjustment

AR
Receipts

Misc Receipt

398

Miscellaneous Fee Refund

Payment

450

Total ACH Debits

AP
Payments

Payment

451

ACH Debit Received

AP
Payments

Payment

471

Total Checks Paid

AP
Payments

Payment

506

Book Transfer Debit

AP
Payments

Payment

552

Credit Reversal

AP
Payments

Payment

555

Deposited Item Returned

AP
Payments

Matching
Against

Create

Activity

Pay Method

Yes

AR Bank
Charges

Manual
Payment

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 11 of 16
Rev 2

Type

Code

Description

Start

End

Float
Days

Trans
Source

Payment

557

Individual ACH Return

Item

Misc Receipt

567

Return Item Fee

Payment

631

Debit Adjustment

AP
Payments

Payment

694

Deposit Reversal

AP
Payments

Payment

901

WHT/GST/VAT/EXCISE

AP
Payments

Receipt

369

Clearing Settlement Credit

AR
Receipts

Matching
Against

Create

Activity

Pay Method

AR Bank
Charges

Manual
Payment

AP
Payments
Misc

<Bank Account> Trans ID Types FOR BANK OF AMERICA** AP & AR ACCOUNTS *

Type

Code

Description

Receipt

TRFC Transfer Credit

Payment

TRFD Transfer Debit

Misc Receipt

MSCC Miscellaneous Credit

Misc Payment

MSCD Miscellaneous Debit

Start

End

Float
Days

Trans
Source

Matching
Against

Correction
Method

Stmt,
Misc
Stmt,
Misc

Both

Create

AR
Receipts
AP
Payments
Both

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 12 of 16
Rev 2

Activity

Pay
Method

Type

Code

Description

Receipt

LBXC Lockbox Credit

Misc Receipt
Misc Payment

INTC
INTD

Start

End

Float
Days

Trans
Source

Matching
Against

Correction
Method

Create

Activity

Pay
Method

AR
Receipts

Interest Credit
Interest Debit

Misc
Misc

* The list of accounts can be found in the BTC Setup spreadsheet https://aiseroom.corporate.agilent.com/eRoom/everest/Finance/0_f38b
** Fuji statements cannot be autoloaded because field 25 in the MT940 contains additional information to the account number and therefore <> the
account number set up in Oracle.

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 13 of 16
Rev 2

Open and Closed Issues for this Deliverable

Open Issues
ID

Issue

Resolution

Responsibility Target
Date

Impact
Date

Resolution

Responsibility Target
Date

Impact
Date

Closed Issues
ID

Issue

Agilent Technologies Restricted

Any printed copy of this document is an uncontrolled document. The current version is available in the Enterprise Solutions Knowledge Portal at
http://wcosedoc.cos.agilent.com/stellent/groups/support_finance/documents/support_organization/001949.pdf
Effective 1/12/04
Page 14 of 16
Rev 2