-
Getting started with Aico
- Logging into Aico for the First Time
- Creating your first journal
- Creating your first request
- Creating your first payment
- Creating your first Intercompany Invoice
- Working with Closing Tasks
-
Working with Journals
- An overview of Aico journals
- How to create a manual journal
- Create a journal by copying existing journals
- Import new journals from Excel
- How to import multiple journals from one Excel spreadsheet
- What are recurring journal entries?
- How to create Recurring Duplicate Journal entries
- How to create Recurring Allocation journal entries
- Create recurring journals with automatic reversals
- Reversing documents
- Import data to existing journals
- Working with Reconciliations
- Universal Settings
- Dashboards
- Closing Tasks
-
System Manager
-
Users and User Groups
- Overview of Users and User Groups
- Add user accounts
- Edit user account data
- Manage user groups
- Manage user roles
- Copying roles at the company level
- Copy user roles from individual users
- Create a user report
- Manage administrative user rights
- Super user mode
- Additional super user global admin rights
- User and User group export and import
- Value sets
- Currency Amount Groups
- Mail notifications
- Tax codes
- Maintenance
- Periods
- Companies
- Archiving
- Managing PDFs
-
Users and User Groups
-
Automation Manager
- Introducing Automation Manager
- Core Set Up
-
Task Templates
- Introducing task templates
- Creating task template details
- The Aico Document
- Aico document headers
- Preparer and Approver workflow settings
- Overriding parameters at a company level
- Master data export and import
- Set a custom schedule
- Dependent tasks in Aico
- How to use Smart tags in Aico
- How to add an attachment to a task template
- How to create a preparer start time
- Cross company dependent tasks
- Related link types
- Task Generation
- Companies
- Administrative tasks
- Staging API
-
Aico Announcements
-
Announcements
- NEW: Journal Entry Automation Deep Dive
- Aico Skills Lab: Journal Entry Configurations Tricks & Tips (Rescheduled)
- NEW: Aico Skills Lab Tips & tricks for Aico Journal Entries configuration
- NEW: Account Reconciliation Skills Lab Exclusively for Super Users!
- Public holiday dates 2024: Aico Support Unavailable.
- NEW: Software Release Presentation: Enhancing User Experience 24.1
- Public holiday dates 2023: Aico Support Unavailable.
- Release notes
- Maintenance Schedule
- Support Alerts
-
Announcements
- Aico Reviews
Configure the staging client
Modified on Tue, 18 Feb at 10:45 AM
The client is where you configure the staging to use different Aico document templates, mappings (between the staging data fields and the Aico document headers and rows) as well as where to send the Aico documents in the workflow. Once the client is configured, you can then send batches of data through the API to the client from which the staging service will create the Aico documents.
For example, a client might wish to not import any documents from a given batch, if even a single document fails the Aico validation of the document. Later the client can re-send all the documents in the batch once the source data has been fixed in the source system.
Another example would be that all documents in a batch should be saved into Aico as documents even if they have validation errors, and users are expected to fix the data in the Aico documents.
Follow the steps below to set up a Client:
Set the Details
- Go to Staging - Clients and select Add New
- Complete the details page
- Name - Set a unique name for the client.
- Contact emails - Set a csv list of email addresses who should be notified when a batch sent to the client goes into error.
- Active - When the client is not active the staging service that generates the Aico documents will not consider any batches sent to the client.
- Invalid documents allowed - When invalid documents are allowed then the staging service will save Aico documents even though they fail the validations set on the staging import validation tasks.
- Retry allowed - When the batch goes into error and retry is allowed then it is possible to retry the staging process on the original batch data once the error has been corrected. If retry is not allowed then the batch must be resubmitted once the error has been corrected.
- Default currency - Where the currency code header in the Aico document is either not mapped or empty, it will use the default currency set here.
- Default document template - Where the document template header in the Aico document is either not mapped or empty, it will use the default document template set here.
Default target workflow phase - The staging service will automatically send the created documents to the workflow phase set in the target workflow phase header e.g. preparation, approval etc. Where the target workflow phase header is either not set or empty, it will use the default target workflow phase set here.
Set the Mappings
The mappings determine which staging fields are mapped into which headers and rows of the Aico document template(s). It is possible to use multiple Aico documents templates within a single staging client however it may be simpler to have separate clients when creating documents with multiple templates.
The staging API offers 40 text fields, 10 integers, 10 decimals, 10 date/time and 10 Boolean for both Headers and Rows i.e. 40 text headers AND 40 text rows etc. Each of these has a generic name Text01, Text02, Integer01, Integer02, DateTime01 etc.
In the mapping you select a staging field e.g. (Header) Text01 and select which Aico document header this should be mapped to e.g. (Header) documentType.
Note: there are fewer staging fields than are available in the Aico document templates. This is intentional to keep the interface simpler as the vast majority of headers and rows are set automatically by the Aico document template configuration (formulas, tasks etc.)
- Go to the Mapping tab in the Client and select Add new.
- On the general tab, select the field type (header or row) and the field you want to map e.g. Text01 or Decimal01.
- Move to the mappings tab and press Add new.
- Select the document template and then the corresponding header or row column.
You can add mappings for more than one document template for the same staging header or row however you can only add ONE mapping for each template e.g. Text04 can be mapped to Document Type for JOURNALSAP and Document Name for JOURNALSAP2
Note: You do not need to map either the company code or the Aico document template to TextXX headers, there are dedicated fields in the API in which set those values.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article