Skip to main content

Posts

how to run SSRS Report through Report server URL

 how to run SSRS Report through Report server URL(in browser/3rd party application) in D365 F&O like in AX 2012 R3. In AX2012 R3 for  integration, we provide the corresponding URL along with credentials. third party app will pass the respective parameters to the report and that will generate the report. This same process possible in D365FO? Some suggestion here in this link. https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/194803/run-ssrs-report-from-report-manager-url

Certification Active till Jun 30,2021 and Jun 30,2022

 Certification Exam Active till June 30, 2021 AI-100: Designing and Implementing an Azure AI Solution MB-600: Microsoft Dynamics 365 + Power Platform Solution Architect MB-901: Microsoft Dynamics 365 Fundamentals Certification Exam Active till June 30, 2022 98-349: Windows Operating System Fundamentals 98-361: Software Development Fundamentals 98-364: Database Fundamentals 98-365: Windows Server Administration Fundamentals 98-366: Networking Fundamentals 98-367: Security Fundamentals 98-368: Mobility and Devices Fundamentals 98-375: HTML5 Application Development Fundamentals 98-381: Introduction to Programming Using Python 98-382: Introduction to Programming Using JavaScript 98-383: Introduction to Programming Using HTML and CSS 98-388: Introduction to Programming Using Java

sales order Totals option getting error in Axapta

Problem: On  click sales order Totals option getting below error. Please help me how to solve it. Microsoft.Dynamics.Ax.Xpp.ClrErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ClrErrorException' was thrown. at Microsoft.Dynamics.Ax.Xpp.CLRInterop.MakeReflectionCall(Object instance, String methodName, Object[] parameters) at Dynamics.Ax.Application.TaxDocumentProxy.Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String taxType, String taxComponent, Boolean , Boolean , Boolean ) in TaxDocumentProxy.sumByTaxAccountingProvider.xpp:line 15 at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String _taxType, Boolean , Boolean ) at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide,

Dynamics 365 Opening balances at data migration there is good news for Functional consultant-D365

 Are you a Microsoft Dynamics 365 consultant importing opening balances using "9999" accounts? I understand you may have worked with other ERP or Accounting systems where you have had no choice but to use "9999" accounts. Or, another D365 consultant told you this was the only way to establish opening balances in D365. It really doesn't matter how you got here, just know there is a better way!   When importing opening balances, instead of using these fake numbers as offset, use the associated Control Account for that entity.   For example, importing open invoices to establish AR balances in D365, the entry would look like this: Account Type = Customer Account = [Customer's Account number] Debit = Invoice Amount Offset Account Type = Ledger Offset Account = [ AR Control Account defined in your posting profile]   The resulting entry to General Ledger: DEBIT: AR Control Account   = Invoice Amount CREDIT: AR Control Account   = Invoice Amount Yes! The net change

General Ledger Error on Posting journal in Axapta

 Problem: if you are  posting journal in GL. then you can get this warning. Account number for Transaction type sales tax does not exist. Reported from company account 'xxxx' Solution : You can check in below areas: - 1) If main accounts are selected in the "Ledger posting group" form in Tax module! 2) check in inventory posting profile setup and select the main account for sales tax posting type. this is for PO or SO? 3) Check in main account which posting type you have selected. this should be "Sales tax". point 3 will be cleared if you already set point 1 as without selecting posting type as "Sales tax" in main account level, system will not allow you to select any account in "Ledger posting group" form.

Case resolution for the ERP system

Dear Friends, The XYZ company have multiple branches (A,B,C,D): 1/ The A,B branches are independent accounting (have separate legal and manager) 2/ The C,D branches are dependent accounting (don't have separate legal and manager) 3/ The supplier, customer can have business with 4 branches 4/ The each of branch have own warehouse 5/ The 4 branches can use same some of items. 6/ The A,B branches can create separate Balance sheet, P&L reports. 7/ The C,D branches can't create separate Balance sheet, P&L reports. Question: 1/ Can the ERP system support this case?. Thank you. Answer: Yes it is, you need to follow procedure for legal entity and branch.  Customer,  vendor etc can be shared between legal entities