Electroning Reporting

 This post is about how to extend the standard Electronic report. This scenario might arise if you want to modify the existing mapping or format or need to add any new field. Let's take an example of adding the voucher to GSTR-1 electronic report. Step 1 - Click on the root GST returns model. Click create configuration and then click on the Derive from Name: GST Returns model, Microsoft. Give suitable name and description.     Step 2 - Click on the designer. Expand the GST Returns model(GSTR) and under Report lines add the new field voucher. Change the status to complete. Step 3 - Click on the GST Returns model mapping. Click on the create configuration. Click on the Derive from Name: GST Returns model mapping, Microsoft. Give the meaningful name and description and select target name with the one which you had created in step 1. For me Derive from Name: GST Returns model mapping, Microsoft   Step 4 - Click on the designer and again on the designer. It will...

 This is the second part of my blog of how to create the format designer and mapping to export the Electronic report. If you haven't read my previous blog, please read it  Electronic Reporting - Model Mapping example .  Step 1 -  Click on the node which you have created -CustomerTransactionReport and the click on the Create configuration button.    Now give the name, description. For format you can keep excel for now or leave it empty. Select the data model which you have created from previous post. Now click on the designer which will take you to the page of format designer. Step 2 - Now before mapping you need to create design document for which we will be importing our excel document. One needs to know the excel so I took little help from my friend for creating the excel designs. The way you make this is very important as it will help for multiple customer accounts and transactions. For A1 cell we can give any heading like transactions .  For A3 gi...