Expense Allocator for Microsoft Dynamics 365 Business Central 

This tool allows to set up rules and parameters for creating journal lines.

Please find solution description below. In case any questions arise, please feel free to email us: info@awara-it.com
Other contact details can be found at our Contact us page.

 

To close period, open Task in Financial Management – Closing Periods:

In each closing batch there are predefined lines with settings and parameters on how to calculate amounts for closing and which GL accounts should be used in entries:

 

Set lines

Batch name. Create several Batches with settings for closing period. E.g. if it is necessary to transfer amount to account and after that transfer amount from account.

Account. Analyses amount on this account according set ups in lines, Date range, and put this account to journal line.

Bal. Account. Put this account as balance account to journal line.

Global Dim. Set up dividing amount by dimension set. If fields Global Dim1… Shortcut Dim5 have checkmark “Yes”, system will check amount on account by dimensions and will create journal lines for amounts by dimension set.

Dimensions (Region code, Profit center code…). Filter fields, it is possible to specify value for filter amounts.

Close with Account.  If you specify account to this field system will replace account in journal line.

Close with Dim. if you specify dimension value to this field system will replace value for this dimension in journal lines.

Net change. If you put checkmark to this field system will check turnover for account for Data range, if not system will check balance by account to the end of Data range.

Correction. Set “yes” if you want to have correction checkmark for journal line.

How to run

  • Run Closing period by every STEPS: For month closing: STEP1, STEP2, For year closing:STEP1..STEP6
  • Create in Gen. Journal – choose GL journal for entry creation
  • Closing Period – period of closing, for month ex.01.04.18..30.04.18, for year ex.01.01.18..31.12.18
  • Posting date – posting date for entries, last date of period, it is possible to use Closing date.
  • Document no. – document number for closing entries

After setups and adding parameters for calculation click “Prepare Closing Operations”:

Chosen journal will be open automatically. Please check and post prepared entries: