Overview
This article provides instruction for creating new customers and editing existing customers in the CIPERB application.
CIPERB is a new tool that will provide full functionality for individuals to manage customers under the Accounts Receivable module in the OFC application. Customer data created and updated via CIPERB will be updated real-time in Oracle to improve customer experiences and increase operational efficiency.
Essential Information
Definitions
CIPERB is utilized to create customer accounts in Oracle.
- In Oracle, invoices are sent to customers and payments are sent to Suppliers.
- A Customer is a person or business that UCSD needs to bill for services that UCSD provided.
- A Supplier is a person or business that provided UCSD with a service that UCSD needs to pay the business for.
- If a supplier account is required instead, please use PaymentWorks.
Customer: A party, either an organization or person, with whom you have a selling relationship. This selling relationship can result from the purchase of products and services or from the negotiation of terms and conditions that provide the basis for future purchases.
Customer Account: A customer account represents the attributes of the business relationship that a customer can enter into with UCSD. The account has information about the terms and conditions of doing business with UCSD.
You can create multiple customer accounts for a customer, to maintain information about different categories of business activities. For example, to track invoices for different types of sales, you can maintain an account for sponsored research, service agreements, consulting services, etc.
Contact: A person who communicates for or acts on behalf of a customer or customer account. Contacts are added at the customer level internally and can be assigned at the account or address/site level. Multiple contacts can be added.
Sites/Addresses: A site is where the customer is physically located. Party sites are added at the customer level internally but are created at the account level. An account site is a customer site used in a context of an account. Multiple sites can be added under an account.
Roles and Access
- 5 primary roles defined for CIPERB application:
|
|
|
---|
UCSD CIPERB Read User JR
|
User can View any data in CIPERB
|
No Workflow-anyone can have this role
|
UCSD CIPERB Manage GP User JR
|
User can only view Non-SP Data (non-sp customers, no FER, etc)
|
Non Sponsored data access
|
UCSD CIPERB Manage Customer ALL JR
|
User can create/edit Customers (Parties)
|
Department Approval + AR Team Approval
|
UCSD CIPERB Manage Customer Accounts Only JR
|
User can create/edit Customer Accounts
|
Department Approval
|
- UCSD CIPERB Manage GP User JR + UCSD CIPERB Manage Customer ALL JR = Manage Customer & Others Customers (Parties and accounts) (GP Super User)
- UCSD CIPERB Manage GP User JR + UCSD CIPERB Manage Customer Accounts Only JR = Able to add/edit Other Accounts
Please note, the Oracle & Concur Role Request Form in Services & Support has been updated to require users requesting OFC inquiry roles and higher-level access to complete specific training courses in UC Learning.
- To learn more about training requirements, please go to the Finance Training Program in Blink.
- For information about Oracle and Concur role requests, see
- Internal Controls Checklist Updated: The internal controls checklist has been updated to reflect the release of the new Consolidated Exceptions Report. Please download the latest version of the checklist from Blink: Best Practices in Internal Controls.
Specific Training Requirements for Role Request Form Submissions:
Oracle Foundationsfor the following roles:
- All standard roles for all business units, except for UCSD BI Consumer JR
- All financial unit approver roles [UCSD WF XXXXXXX Approver JR]
- All cost transfer approver roles [UCSD WF XXXXXXC Cost Adjustment Approver JR]
- All elevated roles for all business units
CIPERB: Customers, Invoices, Project Expenses Report & Billing for the following roles:
- CIPERB Manage Customer Accounts Only
- CIPERB Manage GP User
- CIPERB Manage Customer ALL
Additional CIPERB Requirements
**Access to CIPERB requires VPN connection**
The implementation of Tax IDs for new Customers is a requirement for the CIPERB application. Having a customer tax identification number (TIN) [domestic & foreign] is important for various reasons, both for the customer and the entity they're transacting with. The following key points elaborate on this implemented customer account policy:
- Identification and Verification: TIN helps in uniquely identifying customers for tax purposes. It provides a reliable means of verifying a customer's identity, especially for financial transactions and regulatory compliance.
- Tax Reporting and Compliance: For businesses, having customers' TINs is crucial for tax reporting and compliance. It ensures accurate reporting of income and helps in fulfilling tax obligations such as issuing 1099 forms (in the United States) for certain types of transactions.
- Preventing Tax Evasion: TINs help in preventing tax evasion by ensuring that income earned by individuals or entities is properly reported to tax authorities. Without TINs, it would be easier for individuals or businesses to conceal income and evade taxes.
- International Transactions: In international trade and transactions, TINs are often required for customs clearance and tax purposes. They help in identifying parties involved and ensuring compliance with tax regulations of respective countries.
- Credit and Financial Transactions: TINs are sometimes used by financial institutions for credit checks and assessing the creditworthiness of customers. They can be part of the information required when opening bank accounts or applying for loans.
- Legal and Regulatory Requirements: In many jurisdictions, there are legal and regulatory requirements mandating the collection and use of TINs for certain types of transactions. Failure to comply with these requirements can lead to penalties and legal consequences.
- Business-to-Business Transactions: In business-to-business transactions, TINs are often required for invoicing and accounting purposes. They help in tracking transactions, managing accounts receivable and payable, and facilitating smooth business operations.
Overall, having a customer tax identification number is important for ensuring transparency, accountability, and compliance in financial transactions and tax matters. It helps in building trust between parties involved and contributes to the integrity of the financial system.
Next Steps
I. Creating a New Customer
- Log in to the CIPERB application, which defaults to the Dashboard > select Search
- Initiate a search of the customer name by entering it into the Customer Name field > Search
- Under Customer Type, select Organization or Person (First Name, Last Name) as needed
- The search will default the inquiry to "Contains", but the Customer Name search can be substituted to the following:
- Contains
- Starts with
- Exact Word Match
- Full Match
- or the Filter Result field can be utilized
- Search parameters only include Customer Name, Party Number, and Account Number (the account description is not available for historical records)
- IF a customer match is found, the name will populate below to reveal all associated Accounts under that Customer Name
- If the desired Account is not found (i.e. the accounts do not match the Department Type), and one is still required for the department, skip ahead to the section Creating a New Account
- If a match is not found at all, select the CREATE Button
- Enter the Customer Name (validate spelling - best practice is to use the Customer Name listed on their W-9 form for organizations)
- Select the CHECK button to fully validate the customer is NOT in the system. You will need to select every word-button that appears, and review them individually before the CREATE button becomes accessible
- Pop-up window will ask for confirmation of New Customer > select Yes
- New window pops up requiring the following information
- Approved By: Select Department AR Person that approves this action (Last Name, First Name)
- Reason: enter reason for new customer
- Submit
- In the Account: Account page, enter the following information:
- Tax ID Number
- Account Description
- Search/Select Owning Org
- Select Business Types
- Conference and Event Services
- Consulting Services
- Donations and Contributions
- Facility Rentals
- Licensing and Intellectual Property
- Memberships
- Product Sales
- Real Estate Rentals
- Service Agreements
- Customer Class
- Federal
- Foreign
- Local
- Private
- Public Sector Companies
- State
- UC Campus
- Select Next
- In the Account Contact: Account Contact page, enter the following information:
- First Name
- (Middle Name - if desired)
- Last Name
- Email and Purpose
- If a phone number is provided, enter the Country Code, Area Code, Phone Number, Ext. (if provided), and Purpose
- If a website is provided, enter the Web address and Purpose
- Contact Responsibilities
- Primary Responsibility will automatically be defaulted to Bill to (leave as is)
- All Assigned Responsibility will automatically be defaulted to Bill to and Ship to (leave as is)
- Select Next
- In the Profile: Profile/Settings page:
- Under Invoicing, the Preferred Delivery Method is required:
-
-
- E-Mail (invoices will be automatically delivered by the system to the customer)
- Paper (departments will be responsible for sending invoices to the customer)
- Select Next
- In the Site: Site page, enter the following information:
- Site Name: Account Description can be entered here if desired (e.g. BFS - service agreements)
- Address, City, State, Postal Code
- Address Purpose: purposes are automatically generated
- Ship to: from Select bill to address, select the address from the dropdown
- In the Site Contact: Site Contact page, the contact information entered at the Account-level will populate the Site Contact fields
- Contact Responsibilities
- Primary Responsibility will automatically be defaulted to Statements (leave as is)
- All Assigned Responsibility will automatically be defaulted to Dunning and Statements (leave as is)
- Finalize Customer
- New window pops up to Please review and confirm customer creation. If everything was properly entered, the customer will be Ready to create
- Review the Customer and Account details, Account Contact, Account Profile, and Account Site
- Select CREATE if all the data is confirmed to be valid and correct
- Account Number and Site Number are provided, copy for reference
II. Creating a New Account
- After initial search for customer reveals the Customer exists, but the desired Account does not, highlight desired Customer line, and select New Account button
- Page updates to reveal a 2nd NEW ACCOUNT button, enter Owning Org and Business Type, and select NEW ACCOUNT button > Confirm: YES
- New window pops up requiring the following information
- Approved By: Select Department AR Person that approves this action (Last Name, First Name)
- Reason: enter reason for new customer
- Submit
- In the Account: Account page, enter the following information:
- Customer Class
- Federal
- Foreign
- Local
- Private
- Public Sector Companies
- State
- UC Campus
- Select Next
- In the Account Contact: Account Contact page, enter the following information:
- First Name
- (Middle Name - if desired)
- Last Name
- Email and Purpose
- If a phone number is provided, enter the Country Code, Area Code, Phone Number, Ext. (if provided), and Purpose
- If a website is provided, enter the Web address and Purpose
- Contact Responsibilities
- Primary Responsibility will automatically be defaulted to Bill to (leave as is)
- All Assigned Responsibility will automatically be defaulted to Bill to and Ship to (leave as is)
- Select Next
- In the Profile: Profile/Settings page:
- Under Invoicing, the Preferred Delivery Method is required:
-
-
- E-Mail (invoices will be automatically delivered by the system to the customer)
- Paper (departments will be responsible for sending invoices to the customer)
- Select Next
- In the Site: Site page, enter the following information:
- Site Name: Account Description can be entered here if desired (e.g. BFS - service agreements)
- Address, City, State, Postal Code
- Address Purpose: purposes are automatically generated
- Ship to: from Select bill to address, select the address from dropdown
- In the Site Contact: Site Contact page, the contact information entered at the Account-level will populate the Site Contact fields
- Contact Responsibilities
- Primary Responsibility will automatically be defaulted to Statements (leave as is)
- All Assigned Responsibility will automatically be defaulted to Dunning and Statements (leave as is)
- Finalize Customer
- New window pops up to Please review and confirm customer creation. If everything was properly entered, the customer will be Ready to create
- Review the Customer and Account details, Account Contact, Account Profile, and Account Site
- Select CREATE if all the data is confirmed to be valid and correct
- Account Number and Site Number are provided, copy for reference
-
III. Editing an Existing Customer Account
- Log in to the CIPERB application
- Initiate a search of the customer via the following search criteria (Organization or Person)
- Customer Name
- Party Number
- Account Number
- Owning Org
- Business Types
- Find and highlight desired customer account
- Select Edit Customer button
- New window pops up requiring the following information
- Approved By: Select Department AR Person that approves this action
- Reason: enter reason for new customer
- Submit
- Account details generate for editing
To Add Contact at Account-level
- Select Add Contact button
- In the Account Contact: Account Contact page, enter the following information:
- First Name
- (Middle Name - if desired)
- Last Name
- Email and Purpose
- If a phone number is provided, enter the Country Code, Area Code, Phone Number, Ext. (if provided), and Purpose
- If a website is provided, enter the Web address and Purpose
- Contact Responsibilities
- Primary Responsibility will automatically be defaulted to Bill to (leave as is)
- All Assigned Responsibility will automatically be defaulted to Bill to and Ship to (leave as is)
- Select Save
To CC (copy) a Contact
- Select Add Contact button
- In the Account Contact: Account Contact page, enter the following information:
- First Name
- (Middle Name - if desired)
- Last Name
- Email and Purpose
- If a phone number is provided, enter the Country Code, Area Code, Phone Number, Ext. (if provided), and Purpose
- If a website is provided, enter the Web address and Purpose
- Contact Responsibilities check only Bill to under "All Assigned Responsibility" section
- Select Save
To Add Site
- Select Add Site button
- In the Site: Site page, enter the following information:
- Site Name: Account Description can be entered here if desired (e.g. BFS - service agreements)
- Address, City, State, Postal Code
- Address Purpose: select one of the following
- Dunning
- Ship to (from Select bill to address from dropdown)
- Statements
- Select Save
To Edit Contact
- Select the Explorer View from left-hand task pane
- Open Account dropdown to reveal additional details
- Select desired Contact
- Edit contact details as necessary:
- Name
- Email
- Phone
- Website
- Select Save
To Edit Profile/Settings
- Select the Explorer View from left-hand task pane
- Open Account dropdown to reveal additional details
- Select Profile/Settings
- Update the Preferred Delivery Method as desired: E-Mail or Paper
- Select Save
To Edit Site
- Select the Explorer View from left-hand task pane
- Open Account dropdown to reveal additional details
- Select Site name
- In the Site page, edit any of the necessary information:
- Site Name: Account Description can be entered here if desired (e.g. BFS - service agreements)
- Address, City, State, Postal Code
- Address Purpose
- Select Save
To Edit Site Contact
- Select the Explorer View from left-hand task pane
- Open Account dropdown to reveal additional details
- Open Site dropdown
- Select Site Contact
- Edit contact details as necessary:
- Name
- Email
- Phone
- Website
- Select Save
To Delete Contact (there must be more than one contact on the account)
- Select the Explorer View from left-hand task pane
- Open Account dropdown to reveal additional details
- Select the contact to be deleted
- Select the Delete Contact button
- Select Save