How to set default values for coding lines in D365? How to utilize those coding defaults in Dooap?
By setting default values for coding lines in D365, these will automatically populate on coding lines in Dooap, significantly reducing the manual effort required by your team. Default values for coding lines can be configured in D365, either under the main account or the vendor. This is especially useful, if your main accounts are typically associated with specific dimensions, or you frequently code a particular vendor to the same dimensions.
Coding defaults: Main accounts
To se default dimension values for the main accounts, follow these instructions:
- In D365, navigate to General Ledger > Charts of accounts > Accounts > Main accounts.
- Select the main account that you want to add default dimensions.
- If necessary, limit legal entities that should NOT use default dimensions.
Limiting legal entities can be completed in the Legal entity overrides section, by clicking +Add.
You can also set a timeframe if you want these settings to be active only for a specific period of time. - Then set default dimensions for all other legal entities (or all if you didn't limit any), by clicking Default dimensions. Fill the necessary fields and click OK.
- Then open Dooap and navigate to Admin > AX Import to bring the set values into Dooap.
- Select only MainDimension active from the left side, and click Import.
- All legal entities, except those specified in the Legal Entity Override section, will automatically populate with these default financial dimensions upon selecting the main account in Dooap.
Example:
In D365, default values were set for a main account 600170.
Company DEMF was selected, and the default dimensions auto-populated in Dooap, once the main account was selected.
If company USMF would be selected as a company instead, default dimensions would not have auto-populated because USMF was on the Legal entity overrides list in D365.
Coding defaults: Vendors
To se default dimension values for a vendor, follow these instructions:
- In D365, navigate to Accounts Payable > Vendors > All Vendors.
- Click open the vendor that you want to add default dimensions for and scroll to the bottom of the vendor's page.
- Expand the Financial dimensions section and add default values that you want to use in coding.
- Click the Save button at the top of the page.
- Then open Dooap and navigate to Admin > AX Import to bring the set values into Dooap.
- Select only Vendor active from the left side, and click Import.
- Once the import is completed, the default dimension values that have been set in D365, will auto-populate on coding lines in Dooap, when invoices are imported for that vendor.
Example:
Default dimension values were set for vendor 104: Best Supplier - Europe in D365.
After adding a coding line in Dooap for this vendor, the values have auto-populated regardless of the chosen main account.
However, dimension values can always be changed manually if needed.