ProSolution > Financials integration documentation
Below you will find the links to the documentation to support the integration of MIS (ProSolution) with OneAdvanced Financials. It is recommended that all documentation is read prior to starting any integration processes.
ProAPI Installation and Set Up Guide 4.pdf
MIS (ProSolution) Financials Integration User Guide 7.pdf
In addition, the checklist and values required for the integration can be seen below. This includes the party responsible for each step and where information on the step can be found within the documentation above:
Checklist
Task | To be completed by | User guide | Page reference |
Install ProAPI | Customer | ProAPI Installation and set up guide | Page 5 |
Edit ProAPI AppSettings.ProSuite.config file | Customer | ProAPI Installation and set up guide | Page 6 |
Create API client in MyWorkPlace for ProSolution/Financials integration | Customer | ProAPI Installation and set up guide | Page 7 |
Create the Organisation Reference if it does not already exist | Customer | ProAPI Installation and set up guide | Page 8 |
Update ProAPI system settings | Customer | ProAPI Installation and set up guide | Page 9 |
Update ProSolution required system settings with appropriate values | Customer | MIS (ProSolution) Financials Integration user guide | Page 5 |
Set up ProSolution GL Code Builder | Customer | MIS (ProSolution) Financials Integration user guide | Page 6 |
Enable and schedule Generate Ledger Codes task in ProSolution | Customer | MIS (ProSolution) Financials Integration user guide | Page 7 |
Create API client in MyWorkPlace for Financials | MIS (ProSolution) Financials Integration user guide | Page 8 | |
Set up Financials systems settings | MIS (ProSolution) Financials Integration user guide | Page 10 |
Values required for integration
Value | Description | System | User guide | Page reference |
Base Advanced Financials URL | URL used to log into Financials | Financials | ||
Financials Token URL | Token URL for the Financials API client | MyWorkplace - Financials API Client | MIS (ProSolution) Financials Integration user guide | Page 8 |
Financials Client ID | Client ID for the Financials API client | MyWorkplace - Financials API Client | MIS (ProSolution) Financials Integration user guide | Page 8 |
Financials Client Secret | Client Secret for the Financials API client | MyWorkplace - Financials API Client | MIS (ProSolution) Financials Integration user guide | Page 8 |
ProAPI Token URL | Token URL for the ProAPI API client | MyWorkplace - ProAPI API Client | ProAPI Installation and set up guide | Page 8 |
ProAPI Client ID | Client ID for the ProAPI API client | MyWorkplace - ProAPI API Client | ProAPI Installation and set up guide | Page 8 |
ProAPI Client Secret | Client secret for the ProAPI API client | MyWorkplace - ProAPI API Client | ProAPI Installation and set up guide | Page 8 |
Initial Integration Date | The date on or after the records created or updated in ProSolution to transfer | TBC by customer | MIS (ProSolution) Financials Integration user guide | Page 14 |
Company code | The company that transactions will be processed into | Financials | MIS (ProSolution) Financials Integration user guide | Page 14 |
Admin Email | The email addresses to which emails generated by the integration will be sent. | TBC by customer | MIS (ProSolution) Financials Integration user guide | Page 14 |
Student Ledger Code | This is the code for the Accounts Receivable Ledger which ProSolution students will be added to. | Financials | MIS (ProSolution) Financials Integration user guide | Page 15 |
Student Invoice Document Type | This is the code for the Sales Invoicing Document Type which should be used to process an invoice in Financials which relates to a student fee from ProSolution | Financials | MIS (ProSolution) Financials Integration user guide | Page 15 |
Student Credit Note Document Type | This is the code for the Sales Invoicing Document Type which should be used to process a credit note in Financials which relates to a student credit note from ProSolution | Financials | MIS (ProSolution) Financials Integration user guide | Page 15 |
Organisation Ledger Code | This is the code for the Accounts Receivable Ledger which ProSolution organisations will be added to | Financials | MIS (ProSolution) Financials Integration user guide | Page 15 |
Organisation Invoice Document Type | This is the code for the Sales Invoicing Document Type which should be used to process an invoice in Financials which relates to an organisation fee from ProSolution | Financials | MIS (ProSolution) Financials Integration user guide | Page 15 |
Organisation Credit Note Document Type | This is the code for the Sales Invoicing Document Type which should be used to process a credit note in Financials which relates to an organisation credit note from ProSolution | Financials | MIS (ProSolution) Financials Integration user guide | Page 16 |
Currency Code | This is the currency code which should be used for invoices, credit notes and payments in Financials. The suggestion is that this should be GBP as ProSolution does not handle multiple currencies | Financials | MIS (ProSolution) Financials Integration user guide | Page 16 |
Tax Code | This is the tax code which should be used for invoices, credit notes and payments in Financials. The suggestion is that this should be a tax code which applies zero tax, as there exists no UK tax on Education spend | Financials | MIS (ProSolution) Financials Integration user guide | Page 16 |
Location Code | This is the location code which should be used for invoices, credit notes and payments in Financials. This is only relevant where the Financials company chosen on the first screen has AR location codes as mandatory | Financials | MIS (ProSolution) Financials Integration user guide | Page 16 |
GL Segment Codes | The Financials General Ledger coding for invoices, credit notes and payments | ProSolution | MIS (ProSolution) Financials Integration user guide | Page 17 |
Student Tuition Fee ID List | This is the Tuition Fee IDs which denote a student in ProSolution. | ProSolution | MIS (ProSolution) Financials Integration user guide | Page 18 |
Invoice Prefix | This is the prefix used to denote an invoice in ProSolution | ProSolution | MIS (ProSolution) Financials Integration user guide | Page 18 |
Credit Note Prefix | This is the prefix used to denote a credit note in ProSolution | ProSolution | MIS (ProSolution) Financials Integration user guide | Page 18 |
Payment Prefix | This is the prefix used to denote a receipt in ProSolution | ProSolution | MIS (ProSolution) Financials Integration user guide | Page 19 |
Refund Prefix | This is the prefix used to denote a refund in ProSolution | ProSolution | Page 19 |
Setting up Document Types in Financials
Below is a link to a useful Financials guide that will help you understand how to create new document types:
Note: opens in a new tab
Further Financials guidance
Below is a link to further Financials guidance which may be useful:
Note: opens in a new tab
