Dynamicstips

 Previously, an entry with a type of Reversing Variable or Reversing Fixed would automatically reverse on the next day from posting, so a reversing journal entry on 31/01/2022 would reverse on 01/02/2022. Please refer to the screenshots below. Business Central now allows the user to specify a calculation date for the reversal of an entry. Add the column field called Reverse Date Calculation on the Recurring General Journals page. Note: If you cannot see  Reverse Date Calculation field on your screen, please use Personalization to add it.   Hope you find it interesting.  #copygeneraljournals #recurringgeneraljournals #reversedjournals #businesscentral #microsoft #erpconsulting

  When this option is selected, it specifies whether the journal lines to be copied to posted journal lines of the selected journal template. When you enable this field, when posting the journal lines from this template, the program copies the lines to the  Posted General Journal  page. From there, you can copy the lines back to the journal, which can be useful when you want to correct entries.  Select your target journal template, batch, and posting date. In this example I updated the posting date and assigned a new Document No.  You can also choose to reverse the sign if you wish to reverse out the original general journal.  The new general journal batch is now available for review and posting. It has the updated date, document number and negative amount. Thank you for reading.  Hope you find it interesting. #businesscentral #msdyn365bc #erpconsulting #microsoft #businesscentral   #copygeneraljournals #postedgeneraljournal

When you are setting up a new general journal template, the Copy GST set up to Jnl. Lines  is ticked automatically by the system. It is crucial to understand when and why this set up should be selected to avoid further mistake with the GST Reconciliation.  When  Copy GST set up to Jnl. Lines    option is selected, it directs the program to automatically fill in the general posting type and GST posting groups on the journal lines of the selected journal template with the defaults from the accounts and balancing accounts.  So make sure that you enable  "Copy GST set up to Jrn. Lines"  only when it is applicable. #businesscentral #msdyn365bc #erpconsulting #microsoft #businesscentral #GSTsetup #generaljournalstemplates #generaljournals

Change log is a useful tool to track data changes s in your Dynamics 365 Business Central database. Use this feature to record when data is inserted, modified, or deleted on specific tables.  First, on the Change Log Setup Page, select BC tables that you would like to set to record insert, modify and delete logs. You can filter the tables by ID or name.   Once you are all set up, go back to the Edit – Change Log Setup page and click on the Change Log Activated button as shown below. It is important that the BC session to be closed and re-opened so the change log will start recording as per the setup.  To review change log entries, navigate to   Change Log Entries page will show you the change records for the table fields that have been activated. You can also print the change log entries by clicking the Print button.  The following information can be used for filtering purposes and be able to report from it: #businesscentral #dynamics365 #microsoft #erpconsul...

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 readi...

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  ...

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