Integration Setup
Integration Setup defines how IMS connects to the current financial system, maps the main accounting functions and, when VAT is enabled, maintains the Purchase VAT / Tax Codes used by purchasing.
Financial-system connection
| Field | Purpose |
|---|---|
| DSN | ODBC Data Source Name used for the current financial-system connection. |
| User ID | Login used by IMS for the financial-system connection. |
| Password | Password for the financial-system login. IMS stores the saved credential in encrypted form. |
| Test Connection | Tests the entered DSN/User/Password and confirms when the financial connection succeeds. |
Users without the Financial Database Setup permission cannot change DSN/User/Password or run Test Connection. Other financial setup fields remain subject to the user's applicable permissions.
Core account mappings
The Accounts section stores the account numbers IMS uses when it constructs financial journals.
| Setting | Used for |
|---|---|
| Cash Sales | Cash-sales accounting entries. |
| Credit Sales | Credit-sales accounting entries. |
| Cash Returns | Cash-sale return/refund accounting entries. |
| Credit Returns | Credit-sale return/refund accounting entries. |
| Sales Discount | Sales discount accounting. |
| COGS | Cost of Goods Sold posting. |
| Discount Earned | Earned/purchase discount posting, including the purchase-journal workflow. |
| Depreciation | Stock Depreciation expense account. |
| Discrepancies | Negative Stock Adjustment / inventory discrepancy account. |
| VAT | VAT/output account mapping used by applicable financial-posting logic. Purchase tax codes can also carry Input and Counter account references. |
| Gift Issue Center | Controls the configured handling of the center used when gift-voucher issuance is posted. |
Purchase VAT / Tax Codes
When Enable Value-Added Tax is active in System Settings, Integration Setup expands to show a Purchase VAT / Tax Codes panel. Use New to create a treatment or select a code and click Edit to change it.
| Field | Purpose / validation |
|---|---|
| Tax Code | Required unique code. It can be entered only when creating the code and becomes read-only afterward. |
| Description | Required description displayed to users in the Purchase Tax Treatment list. |
| Tax Type | DOMESTIC, ZERO, EXEMPT, IMPORT_PAID, IMPORT_DEFERRED, RCM or OUTSIDE_SCOPE. |
| Tax Rate % | Required numeric rate from 0 to 100. |
| Base Mode | NET_INVOICE, MANUAL or NONE. MANUAL permits entry of taxable/VAT values on a new purchase; non-manual modes are calculated from Net Local. |
| Posting Mode | SUPPLIER, COUNTER, VAT_OUT or NONE. The Purchase screen includes VAT in Supplier Total only for SUPPLIER. |
| Recoverable % | Required value from 0 to 100; used to split saved Purchase VAT into recoverable and non-recoverable amounts. |
| Input Account / Counter Account | Account references stored with the tax code for tax-posting configuration. |
| Effective From / Effective To | Optional dates. Effective To cannot be earlier than Effective From. |
| Active | Controls whether the code is available to the current Purchase workflow. |
New tax codes start with DOMESTIC, 10%, NET_INVOICE, SUPPLIER, 100% Recoverable and Active selected. Review these defaults before saving.
Where these settings are used
Save the setup
- Confirm the DSN/User/Password if you are authorized to manage the financial connection.
- Use Test Connection before saving changed connection details.
- Review the financial account mappings.
- Click Save.
If no financial setup exists yet, IMS requires the DSN connection information before creating the first setup record. Later saves update the existing configuration and record an audit-log entry for the financial-integration settings change.
Current integration and future connectors
For current users, Al-Shamel is the financial system connected to IMS. The business mappings on this screen represent accounting intent rather than a permanent dependency on one financial product, making the setup easier to adapt when another approved financial connector is introduced later.