Offset accounts
This section describes how payment offset accounts are configured
Each collected payment from the mobile device is created as a Customer payment journal entry in D365FO. As a consequential validation and posting process is needed, these journal entries should have a corresponding offset account. Offset accounts can be specified in several ways:
you can specify offset account in Journal name configuration
you can specify offset account in Method of payment configuration
you can specify offset account via Dynamics Mobile settings
Using Journal name configuration
Method of payment configuration
Dynamics Mobile settings configuration
Using Dynamics Mobile settings configuration for specifying offset accounts for imported payments have some benefits compared to the other methods.
you can specify different offset account per payment type (DMPaymentType) which allows to collect all payments from a single mobile device in a single journal
you can specify financial dimensions according to the specified account structure
you can use different placeholders for dynamic values in offset account (for example, you can specify separate offset account per employee or customer)
The Dynamics Mobile settings configuration for offset accounts for payments is controlled via set of three settings:
PaymentType_{DMPaymentType}_OffsetAccountType
PaymentType_{DMPaymentType}_OffsetAccount
PaymentType_{DMPaymentType}_DimensionFormat
where {DMPaymentType} is a placeholder for different payment types supported by Dynamics Mobile.
Example:
the setting which controls the offset account type for cash payments has a name PaymentType_Cash_OffsetAccountType
the setting which controls the offset account for bank payments has a name PaymentType_Card_OffsetAccount
OffsetAccountType settings
This type of settings controls the offset account type that will be used for a specific payment type. The possible values for the settings are Ledger and Bank.
OffsetAccount settings
This type of settings controls the offset account itself. The value of the offset account is specified and handled differently depending on the value of OffsetAccountType.
For Ledger type of offset accounts, you need to specify the value together with the financial dimensions to be used, according to the account structure for the account
For Bank type of offset accounts, you need to specify the bank account id
The value for offset account should use the segmented format used in the regular Dynamics 365 FO account fields e.g. main account, followed by a segment for each financial dimension.
For example, if we want to use ledger account 300120 with financial dimensions having 001 for BusinessUnit and 024 for Department, then you need to specify 300120-001-024 as a value for OffsetAccount setting.
If you need an empty value for a specific financial dimension in the account structure, you need to leave its place blank, but keep the delimiter.
For example, if you want to specify MainAccount and Department only, then the value for the offset account setting should be 300120--024
DimensionFormat
This type of setting controls how the offset account value is handled.
For offset accounts with type Bank, DimensionFormat settings should have value BankAccount.
For offset accounts with type Ledger, the value of DimensionFormat setting should specify the financial dimensions order according to the account structure for the main account.
For example, the ledger offset account specified above should use MainAccount-BusinessUnit-Department as a dimension format.
Please note, that different implementations can have different delimiter for chart of accounts. You can easily check this directly in account fields in journals or refer to the Chart of accounts delimiter in General ledger parameters (see image below).
Last updated
