Leading system and Business Central
The leading system is the program in which your master data lives. fineelik also works without one.
You find the setting under Settings, Leading system. At the top you choose the type:
- Without ERP: You maintain accounts, vendors and cost centers in fineelik, by hand or by CSV. This is the simplest way to try out fineelik, and it also works permanently.
- Business Central: fineelik fetches vendors and master data from Business Central.
- ERPNext: fineelik fetches vendors and master data from ERPNext and posts approved invoices there as purchase invoices. See ERPNext.
A switch asks for confirmation. When you switch to Business Central, the dialog with the credentials opens. When you switch back to “Without ERP”, fineelik asks whether the connection should be removed. Vendors, master data and learned rules are kept.
What happens to your data when you switch
Section titled “What happens to your data when you switch”A switch does not touch any invoice. Open and finished invoices keep their vendors and their coding, because both ways show the same coding fields.
- From “Without ERP” to Business Central: From the first sync, Business Central leads the vendors and accounts. You then create new vendors there and sync. In the review they can no longer be created directly.
- From Business Central to “Without ERP”: The sync and learning from Business Central end, the client secret is deleted. After that you maintain vendors and accounts in fineelik, and new vendors can be created from the invoice in the review. The additional dimensions belong to the connection: Your values on the invoices stay stored, and you adopt the dimensions again with a new connection.
Connecting Business Central
Section titled “Connecting Business Central”Choose “Business Central”. There are two ways to sign in. Both can be done later if you need your IT.
Via the eelik app (recommended)
Section titled “Via the eelik app (recommended)”No app registration of your own. For this, fineelik must first be connected to your Microsoft organisation, see Users and access.
- An administrator of your organisation allows fineelik to access Business Central once. You can also send the link to your IT. Who may consent is described under Microsoft consent.
- In Business Central, open the page Microsoft Entra Applications and add an entry with the client ID shown, state Enabled, with the permission set D365 BUS FULL ACCESS. If you have installed the fineelik Connector (see below), also assign FINEELIK LESEN.
- Choose the environment and the company and click Save and test.
Own app registration
Section titled “Own app registration”For experts. Prerequisites:
- in Microsoft Entra, the permission Dynamics 365 Business Central / API.ReadWrite.All (application) with admin consent
- in Business Central, an entry under Microsoft Entra Applications, state Enabled, with a permission set for the standard API (for example D365 BUS FULL ACCESS)
Then enter Entra tenant ID, Client ID, Client secret, Environment and Company ID and click Save and test. The test shows the available companies. The secret is stored encrypted in the database and never appears again in plain text.
The sync fetches vendors with payment terms, G/L accounts, cost centers, cost objects, posting and tax groups, units and further dimensions. With the fineelik Connector, deferral templates and bank details are added.
It runs every night at 03:15 and on request: Sync now on the Leading system page or with the vendors, each for one company. On the “Dimensions and sync” card you also set an interval of 15 to 120 minutes under Automatic sync. There you also define which accounts and values are adopted, for example only unblocked accounts. These filters need the fineelik Connector.
Bank details from Business Central
Section titled “Bank details from Business Central”For more than the basic functions you install the small extension fineelik Connector (eelik supplies the file). With it, the bank details of the vendors, the deferral templates, the business posting groups and the VAT assignments also come from Business Central. Without the connector, this data is missing. Upload it in the Business Central admin center for the environment under Apps, give the fineelik application on the page “Microsoft Entra Applications” the permission set FINEELIK LESEN, in addition to the set for the standard API, and click “Test connection” in fineelik. The card then shows “fineelik Connector: connected”. Without the connector, you maintain the IBAN in fineelik. In both cases a changed IBAN only takes effect once a second person confirms it.
Learning from Business Central
Section titled “Learning from Business Central”“Learn from Business Central” reads the posted purchase invoices of the last months and compares G/L account, cost center and cost object per line with the coding rules: matching values confirm a rule, deviating values become a conflict showing both values, unknown values become a new rule. In the dialog you choose which postings count: the last months (default 24) or everything from a fixed date. A fixed period then also applies at night. After that it continues every night for changed invoices. The run works in the background and can take a few minutes. You may leave the page, the result appears there.
Posted differently in Business Central
Section titled “Posted differently in Business Central”If an invoice is posted in Business Central with a different coding than it had in fineelik, or with different amounts, fineelik shows the notification “Posted differently in Business Central” with both values. If the posting is right, adjust the learned rule so that the next invoice is correct. Who receives this is described under Notifications.
Additional dimensions
Section titled “Additional dimensions”Besides cost center and cost object, further dimensions from Business Central can be adopted as coding fields (at most ten), on the line or on the header. To do so, choose the button “Add dimension” on the “Additional dimensions” card.
Further systems
Section titled “Further systems”If your tax advisor posts in BMD or DATEV, you set this up under Settings, Further systems. See Handover to the tax advisor. For any other program there is the File export. The full overview is under Connecting systems.