Kolkata, India Microsoft D365 & Power Community
Kolkata, India Microsoft D365 & Power Community
  • 19
  • 37 282

วีดีโอ

Business Performance Analytics in Microsoft Dynamics 365 Finance and Operations
มุมมอง 4282 หลายเดือนก่อน
Join this channel to get access to perks: th-cam.com/channels/6OigHHgrLKoaMg8fRgPW-g.htmljoin
Part 7:Transaction Type Report Preparation in Electronic Reporting Dynamics 365 Finance & Operations
มุมมอง 3573 หลายเดือนก่อน
Join this channel to get access to perks: th-cam.com/channels/6OigHHgrLKoaMg8fRgPW-g.htmljoin Electronic reporting is essential for Dynamics 365 Finance and Operations due to its powerful, user-friendly, no-code framework. Watch this video to learn and take expert guidance to create transaction types of reports.
Project Management Accounting in Dynamics 365 Finance Part 1
มุมมอง 1.2K3 หลายเดือนก่อน
Join this channel to get access to perks: th-cam.com/channels/6OigHHgrLKoaMg8fRgPW-g.htmljoin The below topics are covered in this session. 1. Why Project Management Accounting? 2. Application of IFRS 15. 3. Project Types. 4. Project Groups. 5. Project Categories 6. Line properties. 7. Cost template.
Part 6: Master Type Reports Preparation in Electronic Reporting Dynamics 365 Finance and Operations
มุมมอง 5093 หลายเดือนก่อน
Electronic reporting is essential for Dynamics 365 Finance and Operations due to its powerful, user-friendly, no-code framework. Watch this video to learn and take the export guidance for the topics below. Guidance on Report Preparation in ER Identification of Main Tables and Joins with Other Tables Sample 1: Master Type of Report
Getting started with Artificial Intelligence :Embarking on the Journey
มุมมอง 1544 หลายเดือนก่อน
In this session, the below topics are covered in detail. Introduction to Python An overview of AI, Machine and deep learning Difference between above processes and postulates Basics of Python Programming Examples of Various Python based interactive programming Quick syntaxes and demos How could we used Python and Machine learning in D365FO
New Modern and Touchless Bank Reconciliation in Microsoft Dynamics 365 Finance and Operations
มุมมอง 1.2K4 หลายเดือนก่อน
Bank reconciliation stands as a pivotal aspect in financial management, and achieving complete automation in this domain can indeed be a boon. Microsoft has introduced several new features in this area over the past two years, from 2023 to 2024. Below are the features we have described in this session. 1. Automatic Import of Bank Statements from SharePoint 2. Automatic Clearing of Bridged Trans...
Learning Session on Petty Cash Accounting in Microsoft Dynamics 365 Finance and Operations
มุมมอง 9055 หลายเดือนก่อน
This session is on Petty Cash Accounting in Dynamics 365, this exciting new functionality, brought to you by the Product team, is showcased through an end-to-end demo where Ramit Paul and Karthik Shriramneni have explained the use case and demonstrate how to utilize these features effectively.
Part 5: Electronic Reporting Extensions for Tax Engine, MT940 AND FIXED ASSET ROLL FORWARD
มุมมอง 9369 หลายเดือนก่อน
Whether you are working in INDIA GST Tax Engine, If you are trying to understand how to modify Fixed Asset Roll forward report in Microsoft Dynamics 365 Finance and Operations. Or if you want to understand how to modify the MT940 Bank Statement format, this session is for you. Topics covered in this video as follows~ India GST Tax Engine Report configuration extensions India GST Tax Engine conf...
Part 4: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations Electronic Reporting
มุมมอง 1.4K11 หลายเดือนก่อน
Welcome to our session number 4 on Electronic Reporting series. Our Speaker Mr. CA Neeraj Kumar & Mr. Dhruv Kumar has explained the below topics and helped to resolve questions in the session. -Prepare Domain specific models -Horizontally expandable reports -Validations at format run -Q&A In case you did not join the previous sessions on Electronic Reporting, below are the links for your perusa...
Budget Control Configuration and System Demo in Microsoft Dynamics 365 Finance
มุมมอง 2.1Kปีที่แล้ว
Welcome to the session on Budget Control Configuration and System Demo by Kolkata East INDIA Microsoft Dynamics 365 & Power Platform community. Concept: Budget Control in Microsoft Dynamics 365 Finance and Operations Agenda : To understand the concept of Budget Control Configuring Budget Control Demo Using Budget Control process Q&A Regards, Kolkata East INDIA Microsoft Dynamics 365 & Power Pla...
Part 3: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations Electronic Reporting
มุมมอง 1.7Kปีที่แล้ว
Part 3: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations Electronic Reporting
Part 2: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations Electronic Reporting
มุมมอง 3.5Kปีที่แล้ว
Part 2: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations Electronic Reporting
(Part 2) Dynamics 365 Finance and Operations Integration using Azure Functions
มุมมอง 518ปีที่แล้ว
(Part 2) Dynamics 365 Finance and Operations Integration using Azure Functions
Part 1: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations
มุมมอง 15Kปีที่แล้ว
Part 1: Electronic Reporting in Microsoft Dynamics 365 Finance and Operations
Session #1 Budgeting And Its Best Practices In Microsoft Dynamics 365 Finance
มุมมอง 2.3Kปีที่แล้ว
Session #1 Budgeting And Its Best Practices In Microsoft Dynamics 365 Finance
Revenue & Expense Deferrals With Subscription Billing in Microsoft Dynamics 365 Finance & Operations
มุมมอง 2.4Kปีที่แล้ว
Revenue & Expense Deferrals With Subscription Billing in Microsoft Dynamics 365 Finance & Operations
(Part 1) Dynamics 365 Finance and Operations Integration using Azure Functions
มุมมอง 967ปีที่แล้ว
(Part 1) Dynamics 365 Finance and Operations Integration using Azure Functions
Credit Management Configurations and End to End Demo in Microsoft Dynamics 365 Finance & Operations
มุมมอง 1.7Kปีที่แล้ว
Credit Management Configurations and End to End Demo in Microsoft Dynamics 365 Finance & Operations

ความคิดเห็น

  • @TheShibumi88
    @TheShibumi88 หลายเดือนก่อน

    Thanks for the video. Why would you use the generate vendor payment action? Why would you not have the vendor payment in your ERP, as this would be the first step to generate payment journal?

  • @zaheerahmad3896
    @zaheerahmad3896 หลายเดือนก่อน

    It is precisely

  • @niklaus4042
    @niklaus4042 หลายเดือนก่อน

    Very usefull

  • @niklaus4042
    @niklaus4042 หลายเดือนก่อน

    great content

  • @santoshsurti30
    @santoshsurti30 2 หลายเดือนก่อน

    Very nice explanation..thank you

  • @prabhusharma3676
    @prabhusharma3676 2 หลายเดือนก่อน

    God of Electronic reporting ❤

  • @ravikarnatak3997
    @ravikarnatak3997 3 หลายเดือนก่อน

    Great work Dhruv and Neeraj. Keep it up 👍

  • @sachindramroy4834
    @sachindramroy4834 3 หลายเดือนก่อน

    Very well explained. Thanks

  • @WelcomeToMyTape
    @WelcomeToMyTape 3 หลายเดือนก่อน

    Hi, can you please create content on how to create a json format using the ER. I have to create a E-Invoice using the JSON format.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 3 หลายเดือนก่อน

      Hi, it is covered in part 3 th-cam.com/video/CdcJ0PmAtek/w-d-xo.htmlsi=EnN9si9I74WrgueU

  • @rajeshnayak6380
    @rajeshnayak6380 3 หลายเดือนก่อน

    This was really really an amazing session. ❤ Thankyou so much for making available this kind important topics. Its really well described and helpful for new commers👍🏻

  • @MuhammadUmarFarooq-ep9zl
    @MuhammadUmarFarooq-ep9zl 3 หลายเดือนก่อน

    WELL EXPLAIND ALL ASPECTS,

  • @muhammadhussainaijaz4872
    @muhammadhussainaijaz4872 3 หลายเดือนก่อน

    Well explained.....

  • @MAHESHKUMAR-se7sb
    @MAHESHKUMAR-se7sb 4 หลายเดือนก่อน

    Hi Neeraj, i have a clarification on, how to add multiple ranges in excel format for ER. i have tried with vertical format, but i need to show the data side by side for different ranges, horizontal is not working. Please advice. Thank you in advance.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 3 หลายเดือนก่อน

      If possible for you, can you please share an screenshot also.. as either vertical or horizontal you need to use.. for horizontal i have covered in one of the video.. Part 4 : th-cam.com/video/3rFYFpZFpyA/w-d-xo.html

  • @lorenamora9780
    @lorenamora9780 4 หลายเดือนก่อน

    Thank you! Great explanation. Do you have any advice on how to work with enums as user input parameters?. I mean, I need that the user select a value form a list prior to generate the report and print it on the report once it is generated. I tried using LISTOFFIELDS and GETENUMVALUE but the system threw the following error. Validation error: The parameter of LISTOFFIELDS function must be a valid path to a datasource of ‘record’ or ‘record list’ data type. Any advice you could give?

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 3 หลายเดือนก่อน

      You can create Enum type field in the model and define the required value. Then, add Enumeration User Input Parameter in model mapping, and select the field (created as enum in model). Then you can utilize this User Input parameters for comparison..

  • @omerahmed2712
    @omerahmed2712 4 หลายเดือนก่อน

    After creating format mapping trying to import excel clicked on > add template. Getting error as Object reference not set to an instance of an object Can you expalin this

  • @ZHA2065
    @ZHA2065 4 หลายเดือนก่อน

    I can't thank you enough ❤

  • @AnuragSingh-qy9bm
    @AnuragSingh-qy9bm 4 หลายเดือนก่อน

    Great learning ❤

  • @muhammadhussainaijaz4872
    @muhammadhussainaijaz4872 4 หลายเดือนก่อน

    Very Informative Session 👍👍

  • @mohammedabdulmajid6846
    @mohammedabdulmajid6846 4 หลายเดือนก่อน

    Great sharing as always guys!

  • @tanonka2023
    @tanonka2023 4 หลายเดือนก่อน

    Great session. Thank you to provide useful information

  • @user-fk6hl3ks5k
    @user-fk6hl3ks5k 5 หลายเดือนก่อน

    How do we migrate or export-import an electronic reporting configuration from one environment to an another environment?

  • @AmeerunnisaBegumMohammad
    @AmeerunnisaBegumMohammad 6 หลายเดือนก่อน

    Can I know how to add a footer image and bind it on the formatting. I have added image on Excel but does it requires mapping?

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 6 หลายเดือนก่อน

      If you have already added image then no binding is required.. if you have added a blank image then it should be binded with some field with datatype: container.

  • @hrutikjadhav9769
    @hrutikjadhav9769 6 หลายเดือนก่อน

    How to create report for report between From Date and To Date range i.e., A report for Customer wise Sales report in which i want to see the sales of the products(with the help of Invoice Date) from 15th March to 15th April.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 6 หลายเดือนก่อน

      You need to add UserInputParameter of FromDate/ToDate with EDT TransDate, use these parameters to filter the Table records

  • @garygong506
    @garygong506 6 หลายเดือนก่อน

    You have done a very good job to explain all the steps in a simple and concise manner! Thank you for your great efforts!

  • @virajsinhparmar1513
    @virajsinhparmar1513 6 หลายเดือนก่อน

    Hi Neeraj, im not able to identify why in Formula designer it is showing me all the fields of vendtable while going to add Data source ? i have created the same report which you have shown in exercise step 1 and working for exercise 2 (wants to use vendor group wise filter)and facing this issue.

  • @abhisheknagar283
    @abhisheknagar283 7 หลายเดือนก่อน

    In mine case, select field option is not coming in popup while editing table.

  • @vishaldobariya1258
    @vishaldobariya1258 8 หลายเดือนก่อน

    This Electronic reporting is something which cannot be learned just by reading Microsoft Documentation. You have explained each and every detail. Learned something new today from this. Thank you.

  • @radhamantri4219
    @radhamantri4219 9 หลายเดือนก่อน

    I have a doubt regarding mapping financial dimensions mapping in ER. I want to pull the value of a financial dimension. When I try to check the data source and data field it shows blank. How can I map that particular financial dimension into my report using ER?

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 8 หลายเดือนก่อน

      I am explaining with an example, see how it helps in your case.. Take purchline as example, if we check the relations (many to one) > . We have defaultdimension relation, expand the same, it will give all the financial dimension values..

  • @muhammadzuhair6177
    @muhammadzuhair6177 9 หลายเดือนก่อน

    Excellent session. Just a little suggestion to remove the background music as it distracting and making it difficult to understand the speaker.

  • @samruddhamedhekar4841
    @samruddhamedhekar4841 9 หลายเดือนก่อน

    Excellent demonstration. I have a query - for deferred revenue, a liability account is used. By that logic, for deferred expenses, will an asset account be used ?

  • @Mohdhameed316
    @Mohdhameed316 9 หลายเดือนก่อน

    Your explanation is awesome 💯 Neeraj. I have a doubt. how to import/integrate an ISO xml return file given by a bank using electronic reporting for vendor payment journals in bank integration.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 9 หลายเดือนก่อน

      First, you need to test it manually from the PaymentTransfer page, we have an option Return File-Vendor to import the payment file. Technically it is to be extended so that it can fetch the records through some batch jobs as no batch job option is available at that place.

    • @Mohdhameed316
      @Mohdhameed316 9 หลายเดือนก่อน

      Could you please provide any vlog or video for the same ?

    • @chinturavi2406
      @chinturavi2406 9 หลายเดือนก่อน

      ​@@learnexcelwithexamples-nee4230even I have the same doubt. I didn't get you. Could you please elaborate in detail?

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 9 หลายเดือนก่อน

      We have option to select the import file in payment method.. So.. Once the payment acknowledgement is received from bank.. That file can be imported from payment transfers page.. A button named as Return file - Vendor .. is available.. But no batch job option is available for setting the recurrence.. I am saying to test from there once.. And then if it works then try to extend the same to read the files in batch jobs..

  • @Mohdhameed316
    @Mohdhameed316 9 หลายเดือนก่อน

    I have a doubt. I have created the field. But, why binding in the model mapping there is no field because the datafield is blank for the field. How we can bind ?

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 9 หลายเดือนก่อน

      Question is not that clear.. Pls also tell which table records are you using and which data field is coming blank.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 9 หลายเดือนก่อน

      Question is not that clear.. Pls also tell which table records are you using and which data field is coming blank.

    • @Mohdhameed316
      @Mohdhameed316 9 หลายเดือนก่อน

      I want the fields of Financial Dimension which is under the line details in purchase orders. The fields are Campaign, LOC and etc. But, I can't find the data field of the same and also I can't find the data source.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 9 หลายเดือนก่อน

      @@Mohdhameed316 Under the purchline, go to the relations >> DefaultDimension table then you can find the values of all financial dimension values.

    • @Mohdhameed316
      @Mohdhameed316 9 หลายเดือนก่อน

      Hi Neeraj, Could you look into my question and reply for the same asap?

  • @sinchanaHC
    @sinchanaHC 10 หลายเดือนก่อน

    how to import a excel for custom report

  • @mianumer2706
    @mianumer2706 10 หลายเดือนก่อน

    Sir why are you not uploading more video about electronic reporting. kindly make playlist from A to Z. JAZAKALLAH

    • @mianumer2706
      @mianumer2706 10 หลายเดือนก่อน

      and sir kinldy any playlist or tutor about electronic reporting guidance. and can you gave me your contact number for helping electronic reporting

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 9 หลายเดือนก่อน

      Now there are 5 videos for ER. Playlist is also made for ER.

    • @KolkataMicrosoftDynamics365and
      @KolkataMicrosoftDynamics365and 4 หลายเดือนก่อน

      We are planning more sessions on ER. Stay tuned.

  • @ahmedismail7138
    @ahmedismail7138 10 หลายเดือนก่อน

    good session Could you please give me the instructor's contact details?

  • @muhammadzuhair6177
    @muhammadzuhair6177 11 หลายเดือนก่อน

    Is there going be another detailed session on Budget Planning?

  • @tranhien5005
    @tranhien5005 11 หลายเดือนก่อน

    Thanks Neeraj, It's very helpful, I'm able to build my first report by using ER

  • @asrarshaik5109
    @asrarshaik5109 11 หลายเดือนก่อน

    shall I set buget only on Dimension not using any main account?

    • @ramitpaul2893
      @ramitpaul2893 5 หลายเดือนก่อน

      No, Main account is required

  • @muhammedfarookak6308
    @muhammedfarookak6308 11 หลายเดือนก่อน

    How we can control procurement of fixed assets using budget control?

  • @mianumer2706
    @mianumer2706 11 หลายเดือนก่อน

    Sir AOA I followed your lectures and i made join with multiple tables like 1 header and 2 lines table . so it worked it gave all the data against all header id's. but i need specfic id data . sohow i can put range or limitation on it. and other thing when we use join so we we could't make parameters.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 10 หลายเดือนก่อน

      if it's header in it self then.. filter won't be applicable for that header. either use the Ask for query option for first table.. . or you can add one more header table somewhere below the final recordlist.. and use Inner join.. e.g. take headertable1, headertable2.. let's assume both represent the PurchTable.. one headertable1 is used at the beginning and you can use headertable2 at the end... of record list .. and match the recid of headertable1 to recid of headertable2.. and while adding this headertable2.. you can give as much as required parameters.

  • @i-relax7264
    @i-relax7264 11 หลายเดือนก่อน

    Thanks for sharing, Im facing a problem with my GER. I build a customer list and need to show my last contact created, when I did my join , D365 show me always the old one, there a function or way that can help me to retrieve the last contact created? Thanks

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 10 หลายเดือนก่อน

      here, you need to get all the records of the Contact - table.. and then use ORDERBY based on created date time.. it will make the list oldest to newest.. then use REVERSE function to reverse the orderby.. means newest to oldest. and pick the first record

    • @i-relax7264
      @i-relax7264 10 หลายเดือนก่อน

      @@learnexcelwithexamples-nee4230 I tried it but i get some error syntax! Thanks for your help

  • @stevepereira3746
    @stevepereira3746 11 หลายเดือนก่อน

    Hello, I have an issue where my user input parameter field does not show up on the report format but shows when I try to run the report from the model mapping. How do I fix this?

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 10 หลายเดือนก่อน

      This is happening because the model which is using this user input parameter is not used in the format.. Bind the user input parameter value to model and thereafter use that model value in the format somewhere..

  • @azizulpatni7373
    @azizulpatni7373 ปีที่แล้ว

    How to add more than 2 table? Kindly share the steps plzz

  • @chiranjeevim4250
    @chiranjeevim4250 ปีที่แล้ว

    Guys, if you can make more videos on Integrations that would be of great help for Fin &Ops Community as the future of the application is largely dependent on stream lining the data flow from other applications.

  • @didyouknow24816
    @didyouknow24816 ปีที่แล้ว

    how did you add that lines in excel design ?

  • @didyouknow24816
    @didyouknow24816 ปีที่แล้ว

    An error occurred during the 'Format mapping' run. For more information, contact your system administrator.Message detailsEvaluating binding of format component Excel/Vendor/Vendor_Code.Evaluating expression for path 'model/VendTableRecordList/VenderCode'.Path 'VendTableRecordList' is not bound Unable to Lines name in excel designer

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 ปีที่แล้ว

      In the excel file.. first select the complete row and named it .. through name manager.. then re-upload the file.. you will get the Lines range in Format designer as well.. Above error is coming due to non-binding of main record list.. please try to prepare the report from scratch.. for more practice.. hope it will help..

  • @mhharan123
    @mhharan123 ปีที่แล้ว

    @Neeraj, I saw lots of videos developed by many people across the globe, but your video not only clarified the concept but also as a person you won my heart !!!

  • @muhammadzuhair6177
    @muhammadzuhair6177 ปีที่แล้ว

    The background music is a bit too loud and distracting.

  • @abdulshakoor4685
    @abdulshakoor4685 ปีที่แล้ว

    I have excl file "SQLvsERCust" and this excl file have one excl sheet name "Customer" on Excl sheet it show error that there is linked of excl sheet

  • @abdulshakoor4685
    @abdulshakoor4685 ปีที่แล้ว

    i am facing one issue would you please help me Error File Customers.xlsx is linked to no file components and will be removed after changing status of configuration version.

    • @learnexcelwithexamples-nee4230
      @learnexcelwithexamples-nee4230 ปีที่แล้ว

      this is due to multiple attachments uploaded.. whenever you update the template.. use the button Update instead of Import.. so overcome above problem.. go to format designer.. >> then attachments.. there you will see multiple attachments.. identify the latest one with datetime.. and remove all other attachments.. the error will resolve..