Integration of BC-FO
Extension - SMART HRP APIs
In the system, it is possible to set up integration between Business Central and FO (Dynamics 365 for Finance and Operations/Axapta) using publication pages via API:
- Ext. Payroll G/L Entries page (70951572), G/L Entries that were created after posting the payroll document (accrual, deduction, employee taxes):
| Business Central field | Description |
|---|---|
| Entry No . | Unique entry number |
| G/L Account No . | Number of G/L financial account |
| Posting Date | Date of posting |
| Document No. | Number of the document. Entries posted from one payroll document have the same document number |
| Description | Payroll document line description |
| Currency Code - General Ledger Setup.LCY Code | Entries are always posted to the General ledger in LCY of the system. There is no such field in the table, it's a default one in General Ledger Setup.LCY Code |
| Amount | The amount |
| Debit Amount | The debit amount |
| Credit Amount | The credit amount |
| Transaction No. | Number of the entry within which multiple entries were posted. Entries posted from one payroll document have the same entry number. Within the entry, entry correspondence is generated |
| Source Code | Entry source code. Value from the setup. You can set a filter and display entries by one or several sources. Payroll document entry source – PAYRDOC (may vary depending on the setup of a specific company) |
| Employee No. | Number of the employee is filled in only for the entries that have 'passed' through Person Vendor card. This is the debit and credit part of the accruals, debit part of deductions. |
| Bal. Account Type | Information about the type of the balancing account used when posting the entry |
| Bal. Account No. | Information about the number of the balancing account used when posting an entry |
| Source Type | Entry source type. For credit entries with Person Vendors and tax authorities, it's Vendor |
| Source No . | Source number |
| Vendor Type | Type of the Vendor |
| Vendor VAT Registration No. | VAT registration number (RNOKPP) of the Vendor |
| Last Modified DateTime | Date and time of entry posting |
| Dimension 1 (від Dimension Set ID ) | Dimension 1 |
| Dimension 2 (від Dimension Set ID ) | Dimension 2 |
| ... | |
| Dimension x (від Dimension Set ID ) | Dimension Х |
- Ext. Employee Payment Entries (70951571) page, Vendor Ledger Entries with Employee No . >'', Vendor Type=Person filters. The Document Type = Payment | Refund filter.
| Business Central field | Desccription | |
|---|---|---|
| Entry No . | Unique entry code | |
| Posting Date | Posting date | |
| Document Type | Type of the document (Payment | Refund) |
| Document No . | Number of paysheet | |
| Description | Entry description (full name of the employee) | |
| Amount | Amount | |
| Currency Code | Code of the currency (original) | |
| Amount (LCY) | Amount in the local currency | |
| Debit Amount | Debit amount | |
| Credit Amount | Credit amount | |
| Debit Account No | Debit account number | |
| Credit Account No | Credit account number | |
| Bal . Account Type | Balancing account type - Bank account | |
| Bal . Account No . | Bank account number (the one money came from) | |
| Transaction No. | Entry number | |
| Payment Assignment | Payment assignment | |
| Employee No. | Employee number | |
| Employee.Full Name | Full name of the employee | |
| Employee.Taxpayer Identification No. | Taxpayer Identification number (RNOKPP) of the employee | |
| IBAN Code | IBAN accounts of the employee | |
| SWIFT Code | SWIFT accounts of the employee |
- Ext. Vendor Payment Entries (70951573) page, Vendor Ledger Entries with the Employee No.='', Vendor Type=Person or Vendor Type=Tax Authorities filters. The Document Type = Payment | Refund (payment of taxes and deductions to other persons) filters.
| Business Central field | Description | |
|---|---|---|
| Entry No . | Unique entry number | |
| Posting Date | Posting date | |
| Document Type | Type of the document (Payment | Refund) |
| Document No . | Number of the paysheet or payment number | |
| Description | Entry description (name of the tax authority or a person) | |
| Amount | Amount | |
| Currency Code | Code of the currency (original) | |
| Amount (LCY) | Amount in the local currency | |
| Debit Amount | Debit amount | |
| Credit Amount | Credit amount | |
| Debit Account No | Debit account number | |
| Credit Account No | Credit account number | |
| Bal . Account Type | Balancing account type - Bank account | |
| Bal . Account No . | Bank account number (the one money came from) | |
| Vendor Type | Type of the Vendor (Tax authority | Person) |
| Transaction No . | Entry number | |
| Payment Assignment | Payment assignment | |
| Vendor Type . No | Type of Vendor | |
| Vendor Name | Name of Vendor | |
| Vendor.VAT Registration No. | VAT Registration number (RNOKPP) of the Vendor | |
| IBAN | IBAN accounts of the Vendor | |
| SWIFT Code | SWIFT accounts of the Vendor |