Step 6b: Synchronization in F&O

It is possible to synchronize the financial accounting entry journal lines from SwissSalary with the payroll accounting of Dynamics 365 Finance & Operations. In addition, the dynamic financial account structure from Finance & Operations can be stored in SwissSalary.

The journals or financial accounting entry journal lines are transferred to the LedgerJournalHeaders and LedgerJournalLines OData entities in Finance & Operations.

The financial accounts, dimensions and VAT codes can initially be maintained manually in both systems. With the following setup steps, the account structures from Finance & Operations can be mapped and the lines from table 81 Gen. Journal Lines can be synchronized:

1.Open page 251 - Financial accounting - Journal names and enter the journal name used in Finance & Operations for payroll accounting in the “Journal header name” field (e.g. “LO”).

2.Go to page 118 - Financial accounting setup and open the “Cloud Connector” section.

3.In the “Account Name Format” field, you can define the account structure using placeholders and a separator (e.g. ACC-ID-COST------). The placeholders are freely selectable.

4.Click on the three dots “...” next to the “Account Name Format” field to make the placeholder assignment.

5.Enter the desired placeholder in the “Placeholder value” column. In the “Field no.” column, select the field ID of the corresponding field from table 81 Gen. Journal Lines.

6.Optional: You can also define the account structure individually for each financial account in SwissSalary. To do this, open the "Financial account card" page and define the account structure there in the same way as steps 1-4.

7.If a separate logic is defined for an account, this logic is always used for postings to this account.n. You can do this on the "Financial account card" page for the corresponding account in accordance with the logic described in points 1-4. If you define a logic for an account, the logic defined for the account is used for the bookings for this account.

On the "Entity setup" page under "Cloud Connector administration", the following entities must be set up in the following order:

Sequence	Table ID	Table name	Source
1	3069141	SwS CC Journal Header	Business Central
2	3069141	SwS CC Journal Header	Externes System
3	81	Gen. Journal Line	Business Central

Field ID	Table name	Service field name	Activated	The key
1	Internal Header No.	Integration Key	True	False
5	Name	JournalName	True	False
10	Legal Entity ID	dataAreaId	True	True

Field ID	Table name	Service field name	Activated	The key
1	Internal Header No.	Integration Key	True	False
2	External Header No.	JournalBatchNumber	True	False
10	Legal Entity ID	DataAreaId	True	False

Field ID	Table name	Service field name	Activated	The key
5	Posting Date	TransDate	True	False
8	Description	Text	True	False
12	Currency Code	CurrencyCode	True	False
14	Debit Amount	DebitAmount	True	False
15	Credit Amount	CreditAmount	True	False
43	Quantity	Quantity	True	False
76	DocumentDate	DocumentDate	True	False
90	VAT Bus. Posting Group	SalesTaxGroup	True	False
91	VAT. Prod. Posting Group	ItemSalesTaxGroup	True	False
171	Payment Reference	PaymentReference	True	False
3069140	SwS CC Account	AccountDisplayValue	True	False
3069145	SwS CC External Header No.	JournalBatchNumber	True	True
3069150	SwS CC Legal Entity ID	dateAreaId	True	True

A constant value must be entered in the Currency code field. You can find out more about value assignment here.