NeerajDynamics

What's the Problem : Customers having a huge number of transactions. The General Journal Transfer ( GJT ) numbers are used in all voucher entries posted in the system. These numbers are getting exhausted in a very short duration let assume in 2 months. Customer having doubt that many number sequences are missing for General Journal Transfer. They want to extract some reports which can provide the missing number sequences for GJT and get surety about missing number sequences. There is an option " Check voucher series " under Ledger setup in the General Ledger module. If we try to put the number sequence code here and extract the report, it comes blank (as this report is for voucher series, not support for other number sequences). A temporary solution can be to use the Table browser, extract data from table GeneralJournalEntry for a particular date range into an Excel sheet. Put the expected number sequences, compare the data and identify the missing number sequences

Document Template for Uploading General Journal lines Basic Setup in dynamics 365  Navigate to General Ledger  à    Charts of Accounts  à  Dimensions  à  Financial dimension configuration for integrating applications. 1.         Click New. Select the Dimension Format type as “Ledger Dimension Format”. 2.         Select the Required dimensions that are to be used while filling the details in the Template for                   uploading the General Journal Lines. Sequence is very much important. 3.         Sequence is reflecting in our example as “Main Account – Business Unit – Employee – Purpose-              Vendor -Customer”. 4.         Change Active for type to “Yes”. Financial Dimension Configuration for Integrating Applications

  Document Template for Uploading Purchase Order Lines   1.    Install the Excel Add-in in Excel Go to Insert Tab à Get Add-ins à Search Microsoft Dynamics Office Add-in à Click Add Then Fill the server information (URL – of Dynamics Environment)   2.    Now Let’s understand the meaning of below option: S. No. Option Use 1 New >> To create new record (like new purchase order, sales order, general journal etc) >> Previous data will be override 2 Refresh >> By refreshing, Data can be exported to the template from Dynamics 365 >> By default it shows the first record available in the data source 3 Publish >> After making changes in the data in template (fill the data), then we publish the data. It updates the values in the Dynamics. >> There is option that to refresh the data after publish