Posts

Showing posts from February, 2022

Reason Codes for the Audit Trails in Dynamics 365 Business Central

Image
As we discussed in the previous blog post,  audit trails in Business Central begin with two trail codes:  Source  and  Reason.   Reason codes supplement the source codes and are used to indicate why an entry was created.  To set up  Reason  codes On the Reason Codes page, enter the first code in the Code field. In the Description field, enter an explanatory text.  To assign reason codes to journal templates On the line with the selected journal template, in the Reason Code field, specify the relevant code. The selected reason code will be copied to new journal batches created under this journal template.   Note: Reason codes also provide opportunities for problem patterns analysis. To use reason codes on sales and purchase documents   On the sales or purchase header, enter the code in the Reason Code field. Using Reason Codes allows the posted ledger entries to be filtered by reason code. Hope you enjoy the reading. In next blog post, we discuss Change Logs for Audit Trails. #busi

Source Codes for the Audit Trails in Dynamics 365 Business Central

Image
Auditing trails in Microsoft’s Dynamics 365 Business Central, like with any ERP, is fundamental to ensuring compliance.  In Business Central, audit trails begin with two trail codes: Source and Reason. A source code indicates where an entry was created.  All posted entries in Business Central are automatically assigned a source code so that transactions can be traced to their origin.  To set up source codes Navigate to Source Codes in Tell me and add new codes on the Source Code Page. To define source codes On the Source Code Setup page, for each each posting type and batch job, specify the relevant source code. To define source codes for General Journal On the  General Ledger Journal Template,  Source Code  field is filled in automatically when you select the Type of the General Journal template. Here are some examples: G/L Registers: G/L Entry: In the next blog, we will discuss Reason Codes for Audit Trails. #businesscentral   #msdyn365bc   #erponsulting   #technologythesedays  

How to update an Assigned User List in Business Central?

Image
When there is a new user, how does someone update the Assigned User ID List? Please refer to the screenshot below. Here are the steps: 1. Navigate to the User Set Up and select +New action. 2. Add a new user under User ID field, specify allow posting from and fill in the rest of the fields as necessary. 3.  Assigned User ID list is updated and you can select a new user ID from it. Thank you for reading! #businesscentral #dynamics365 #microsoft #erpconsulting

How to correct FA Subclass on the Fixed Asset Card after the acquisition?

Image
 In Business Central, you cannot make any changes to Fixed Asset Card if there are any associated posted transactions. For an example, I need to change FA Subclass Code and Posting Group from Furniture and Fixture   (FUR&FIX) to Computer Hardware (COMP HW).  The purchase invoice to acquire this fixed asset was posted. When I tried to change the fields, I am getting the following error. To change FA subclass on the Fixed Asset card after the acquisition was posted, you will need to Cancel the acquisition cost. Using Cancel action will create Fixed Asset G/L Journal. After posting it, you can review the results on the  Error Ledger Entries which can be viewed through the Fixed Asset Card, as shown below. Thank you for reading. Hope it helps on your journey with the Business Central. #businesscentral   #msdyn365bc   #erponsulting   #technologythesedays   #microsoft     #dynamics365businesscetral  #fixedasset #fixedassetcorrection #fajournals

How to adjust Exchange Rate from the Purchase Invoice in Business Central?

Image
The businesses often ask how to adjust Exchange Rate on the document level. Here are the steps. 1. On the Purchase Invoice , navigate to Invoice Details Tabs and click on the ellipsis: 2. In the opened window, you can make an adjustment to the Exchange Rate and the changes will be applicable on this document level. 3. The review the result of the updated Exchange Rate, navigate to Invoice and choose Statistics . Hope you find the reading interesting. #businesscentral   #msdyn365bc   #erponsulting   #technologythesedays   #microsoft     #dynamics365businesscetral  #currencies #foreigncurrency #exchangerates 

How to hide G/L amounts from specific users by applying the security filters in Business Central?

Image
A common business scenario is when G/L amount must be hidden for a specific group of users. However, daily tasks performed by this group required users to view G/L accounts and G/L names. Here is the overview how to deliver the solution using the security filters in the Business Central. 1. On the permission set assigned to the users with the limited view permissions, set table15 G/L account and table 17 G/L entry   to Indirect . 2. Under the security filter, set Field Caption   Amount to 0 for the Field Number 17 . Thank you for reading. Hope you find it interesting. #businesscentral   #msdyn365bc   #erponsulting   #technologythesedays   #microsoft     #dynamics365businesscetral  #securityfilters #permissionsets #effectivepermissions #automation