Unboxing D365 for Finance and Operations – General ledger parameters
Unboxing D365 for Finance and Operations – General ledger parameters
Ms. Dynamic Millennial | Be equipped. | Be informed.
Dhanicca Mae Macatangay
Microsoft Dynamics 365 F&O Functional Consultant
Hello everyone!
In every module in Microsoft Dynamics 365 for Finance and Operations, it is already common for us to encounter the Parameters on where we can setup various rules depending on how we want the system to function or depending on the client’s operation requirements.
And there are times that we tend to overlook these parameters and ending up in using the default setup available in the system.
Having said that, let us together unbox the concepts and purpose of the available fields in the General ledger parameters for us to better understand, utilize and setup these parameters.
MICROSOFT DYNAMICS FOR FINANCE AND OPERATIONS – GENERAL LEDGER PARAMETERS
In D365 F&O, there are seven sections that comprise the General ledger parameters, namely: Ledger, Sales tax, Inventory dimensions, Number sequences, Batch transfer rules, Chart of accounts and dimensions, and Ledger settlements.
In this blog, we will be discussing the entire General ledger parameters and have a deeper and further explanation for the Ledger settlements section on our next blog.
Figure 1.01 - Dynamics 365 F&O – General ledger parameters: Ledger section
The Ledger section comprises the setup for general parameter, accounting rules and fiscal year closing.
GENERAL PARAMETER
|
Fields (General) |
Description |
|
Check for voucher used |
Select how to handle duplicate voucher numbers in journals. |
|
Check continuous numbers |
Select this check box to verify that the number sequences that generate vouchers in the ledger are continuous. |
|
Interrupt in case of error account |
Select this check box to interrupt updates to automatic transactions with a message when the error account is used in the posting process. |
|
Maximum penny difference |
Enter the maximum rounding for a voucher for amounts in the accounting currency. If the penny difference is equal to or less than the penny difference that is specified in this field, the difference is posted to the penny difference ledger account that is specified in the Accounts for automatic transactions form. |
|
Maximum penny-rounding in the reporting currency |
Enter the maximum rounding for a voucher for amounts in the reporting currency. |
|
Allow multiple transactions within one voucher |
Select this option to allow multiple vendor, customer, fixed asset, bank or project transactions to be entered within a single voucher. Microsoft does not recommend using this option because of the accounting impact to various processes and reporting. |
|
Fields (Correction) |
Description |
|
Prior-year correction |
Select this option to allow posting advanced ledger entries in the current fiscal year but as a carryforward entry for budgetary purposes. This allows an entity to segregate current-year budget expenditure from prior-year budget expenditures. |
|
Fields (Journalizing) |
Description |
|
Extended ledger journal |
Select this check box to run extended journalizing, which prints a report that is sorted by the date and time when the journals were created. The standard journalizing report is sorted by journal number. |
|
Start journalizing report at page one |
Select this check box to print the journalizing reports from page one. |
|
Check journalizing |
Select this check box to verify whether periods are journalized before they are put on hold or are closed. The verification is performed in the Ledger calendar form when the Period status field is changed to On hold or Closed. |
|
Fields (Upload Journal) |
Description |
|
Upload journal name |
This is used when uploading journals through Data management framework. |
|
Fields (Project) |
Description |
|
Allow the financial dimensions to be edited on the advanced ledger entry form |
Select this check box to allow the ledger account to be changed in the Advanced ledger entry form. |
ACCOUNTING RULES
|
Fields (Financial dimensions) |
Description |
|
Values used for summary account |
Select the value to use as the summary account when offsetting subledger journal account entries are created for accounting distributions. |
|
|
|
|
Fields (Transaction reversal) |
Description |
|
Correction |
If this check box is selected for transaction reversals, a debit transaction is reversed by adding a minus debit transaction, and a credit transaction is reversed by adding a minus credit transaction. When you reverse a customer or vendor transaction by using a correction, the connected ledger transactions are also reversed by using corrections. |
|
|
|
|
Fields (Accounting rules to use) |
Description |
|
Use posting definitions |
Select this check box to use posting definitions instead of posting profiles and to enable the Commitment accounting options. |
|
|
|
|
Fields (Commitment Accounting) |
Description |
|
Enable budget appropriation |
Select this check box to use posting definitions to record budget appropriations in the general ledger for budget register entries. In the Budget parameters form, you must select a budget journal name for the budget appropriation before you can select this check box. |
|
Enable encumbrance process |
Select this check box to create encumbrances, which record entries in the general ledger for committed or obligated purchases. |
|
Enable pre-encumbrance process |
Select this check box to create both pre-encumbrances and encumbrances. Pre-encumbrances reserve funds for planned expenditures. |
|
General budget reservations |
Select this check box to record general budget reservations, purchase requisitions, and purchase orders in the ledger. |
FISACAL YEAR CLOSE
|
Fields (Fiscal year close) |
Description |
|
Delete close-of-year transactions during transfer |
Select this check box to delete opening transactions and system-generated closing transactions that exist for the year to be closed when the transfer is processed again. |
|
Create closing transactions during transfer |
Select this check box to create closing transactions when the opening transactions job is run. |
|
Set fiscal year status to closed |
Select this check box to display a status of Year closed for all periods for the fiscal year that is being closed. |
|
Voucher number must be filled in |
Select this check box if a voucher number must be entered when opening transactions are created for a new fiscal year. |
|
Use fund dimension for year-end transactions |
Select this check box if fund dimension will be used for year close process. This is applicable for Public sector accounting. |
|
Use fund dimension to carry forward transactions |
Select this check box if fund dimension will be used to carryforward transactions for year close process. This is applicable for Public sector accounting. |
Figure 1.02 - Dynamics 365 F&O – General ledger parameters: Sales tax section
The Sales tax section comprises the setup parameters for general taxes, cash discounts, payments, invoices and special report sales tax.
GENERAL
|
Fields (General) |
Description |
|
Item sales tax group |
Select a default item sales tax group that is used when journal lines are created. |
|
Calculation date type |
Select a calculation date type, which determines the sales tax rates to use if you have set up different rates for different dates: |
|
Legal entity for intercompany tax posting |
Select whether to post intercompany tax amounts to the legal entity accounts where the expense or revenue amounts are being recorded or where the payable or receivable amounts are being recorded. Select Destination to post the sales tax amounts for intercompany transactions to the legal entity where the expense or revenue is being distributed. Select this option if your organization uses U.S. sales and use tax. Select Source to post the sales tax amounts for intercompany transactions to the legal entity where the payable to the vendor, the receivable to the customer or bank account is recorded. |
|
Calculation method |
Select whether sales taxes on invoices are calculated for each line or for all lines. |
|
Amounts include sales tax |
Select this check box to enter gross amounts in journals. Gross amounts include sales tax. |
|
Apply sales taxation rules |
Select this check box if the legal entity follows the sales tax and use tax rules of the United States. |
|
Conditional sales tax |
Select this check box if sales tax should not be reported and paid before the invoice is settled. |
|
Check sales tax groups |
Select the notification to receive if the sales tax group has errors. |
|
Tax direction requirement |
Select this check box to require that a tax direction be defined for a ledger account before tax-related transactions can be posted to that account. |
|
Validate tax code |
Select this check box to validate the sales tax code that is assigned to the ledger account when you post a document. |
|
Auto sales tax search |
Select this check box to allow sales tax groups to be automatically assigned to customer address records |
TAX OPTIONS
|
Fields (Cash discount) |
Description |
|
Reverse sales tax on cash discount |
Select this check box if sales tax should be reversed when a cash discount is granted. |
|
Deduct cash discount before sales tax calculation |
Select this check box to never calculate sales tax on cash discount amounts. |
|
Fields (Customer cash discount) |
Description |
|
Cash discount is calculated on amount including sales tax |
Select this check box if the cash discount for customers should be calculated based on the total invoice amount, which includes sales tax. |
|
Mandatory item tax groups |
Select this check box to require that item tax groups be specified on free text invoices. |
|
Fields (Vendor cash discount) |
Description |
|
Cash discount is calculated on amount including sales tax |
Select this check box if the cash discount for vendors should be calculated based on the total invoice amount, which includes sales tax. |
|
Fields (Payment) |
Description |
|
Sales tax on overpayment or underpayment |
Select this check box to calculate sales tax on overpayments or underpayments. |
|
Fields (Invoice) |
Description |
|
Sales tax amount per invoice line |
Select this check box to update the total calculated sales tax amount on the invoice journal. When this check box is cleared, no sales tax amount is updated. |
|
Fields (Special report) |
Description |
|
Include corrections |
Select this check box to include sales tax corrections in the sales tax payment periodic job and report. |
Figure 1.03 - Dynamics 365 F&O – General ledger parameters: Inventory dimensions section
The Inventory dimensions section is the setup parameter dedicated to select inventory dimensions to display on the lines in the Inventory to fixed assets journal. Before you can make entries on this tab, you must select a default value model on the Fixed assets tab.
Figure 1.04 - Dynamics 365 F&O – General ledger parameters: Number sequences section
The Number sequences section comprises the setup parameters to define the number sequence for General ledger. There are available out of the box number sequences in the system, but you can still create and assign new number sequence. Personalizing the number sequence is one way to easily and uniquely identify transactions.
Figure 1.05 - Dynamics 365 F&O – General ledger parameters: Batch transfer rules section
The Batch transfer rules section comprises the setup parameters for subledger journal accounting entries. These rules include the source document type and transfer mode.
Figure 1.06 - Dynamics 365 F&O – General ledger parameters: Chart of accounts and dimensions section
The Chart of accounts and dimensions section comprises the setup parameter of the segment that is to be used in the system in order to separate main account and financial dimensions.
Figure 1.07 - Dynamics 365 F&O – General ledger parameters: Ledger settlements
The Ledger settlements allows to match debit & credit transactions within the GL and mark them as settled, these settlements may also be reversed in case an error was made. Ledger account settlements is useful in reconciling clearing, prepaid, accrual and/or temporary accounts but can still be used with any account in the GL.
We will have a better understanding on how this feature functions and can be used on our next Ms. DM blog.
I hope that you find this article as a helpful tool for you to better appreciate and understand, everything and anything about Microsoft Dynamics 365 for Finance and Operations.
It will truly be a privilege if you will allow me to know your thoughts and suggestions for me to further improve the coming featured articles on our blog.
This is Ms. Dynamic Millennial blog. Be equipped. Be informed.
For more related articles, kindly click the below link:
https://community.dynamics.com/365/financeandoperations/b/ms-dynamic-millennial
Reference:
https://docs.microsoft.com/

Like
Report
*This post is locked for comments