Document Template for Uploading General Journal lines
Document Template for Uploading General Journal lines
Basic Setup in dynamics 365
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 |
Download the Template from General Journal Form
1. Go to General ledger > Journal entries > General journals.2. Create a sample entry with multiple dimension so that after downloading the template it would be easy to understand the format and values to be filled.
3. Come back to General Journal Form. Select the created journal and click on the Button “Open in Excel”. There select the “General Journal template” and press ok.
Let’s understand about the generated template and its columns.
S. No. | Column Name | Description |
General Journal Header | ||
1 | Journal Batch Number | Journal Batch number is auto-populated. |
2 | Description | Description of Journal Names |
3 | Name | Journal Name (Here lookup of journal names is not available so we need to check the same from the Dynamics 365 and put it manually in case we are creating new entries) |
4 | Posted | Status of Posting (Yes or No) |
Journal lines | ||
1 | Date | Transaction date or Posting Date |
2 | Company | Legal Entity in which entry is being posted |
3 | Account Type | Ledger, Vendor, Customer, Bank, Fixed Assets, Project etc.  |
4 | Non-Ledger Account | When we select the Account type other than the “Ledger”. Here we get the lookup for the selected Account type.  |
5 | Main Account | Here select the main account only when the Account type is selected as “Ledger”. |
6 | Description | Narration of the Journal Entry |
7 | Currency | Select the currency from Lookup. |
8 | Debit | Debit Amount |
9 | Credit | Credit Amount |
10 | Offset Company | Legal Entity |
11 | Offset Account type | Similar to Account type (explained earlier) |
12 | Offset Non-Ledger | Similar to Non-Ledger Account (explained earlier) |
13 | Offset Main Account | Similar to Main Account (explained earlier) |
14 | Line Number | This is very important in order to give the correct sequence of the entry and this must be unique. |
· Journal batch number is available in the header but not in the lines.
· Main account are showing but related dimensions are not reflecting in the template
· Similarly offset main account is reflecting but its dimensions are missing.
5. To Get the missing columns we need to do some basic changes in the design.
a) Click on Design button in the Data connector
b) Edit the Journal Lines Table
c) Add the Required fields (Journal Batch Number, Account Display Value, Offset Account Display Value)
d) Click Update. Columns will be added after the last column in the Template.
Refresh the data source and data is auto-filed in the newly added fields.
6. Save a copy of the file.
7. Now data can be filled in the template. Click on New in the Data connector
Fill the data for uploading (publishing)
Keep in Mind:
Ø Here lookup for various fields like Account type, Main Account , Non-Ledger account, Currency etc. are available for doing correct entry.
Ø But for the Dimensions, there is no lookup or tooltip is available (for getting the same there needs to be make small changes in backend and add some methods). This is not explained in the document (for Details, you can refer:
https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/financial/dimensions-overview
Ø Journal Batch Number should be matched with next sequence in the Dynamics 365. It should be filled same in the Header and Lines as well.
Ø Line number should be unique.
8. Click on Publish.
9. If data is successfully updated. It shows below message as “Data refreshed”. In case of any errors , error can checked by click on the Flag showing in the below pic.
6. Creation of Simple template
The download template can be used for making entries. But in case we download the template again from the Dynamics 365, fields that we have added will not be available there. So to keep the required fields after every download. We can make a new template, add it in the Document template so that the same can be accessed from the Open in excel button in the General Journal Form.
Steps for Creation:
a) Make a copy of saved template that we have completed above.
b) Rename the File by removing the suffix (number) by Some new character. Here we used “L1”
Old Name
New Name
c) Repeat the same steps that we have used above to create a new template of Purchase Order Headers and Lines.
· Go to Document Templates
· Click New
· Browse the File
· Press Ok
· Here By default Template Name would be the name of file that is being uploaded but we need to remove the suffix “_L1” so that template can be accessed from the General Journal Form. Here we have made this template Company specific in order to make the template unique from original one.
· Name of Temple display can be renamed for identification.
· Template can now be accessed from Open Lines in Excel on General journal Form.
Thanks for Reading!
Comments
Post a Comment