Skip to main content

Posts

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

Dynamices 365 FO : error "the smtp server requires a secure connection or the client was not authenticated

trying to send test mail through the email parameters in dyn365FO VHD. Its give error "the smtp server requires a secure connection or the client was not authenticated. The server response was 5.7.57 SMTP; client was not authenticated to send anonymous mail during MAIL FROM" Any suggestions??? Solution : Try using same email to login to  DynFO which you configured in smtp setup. If this works go to office email portal and enable 'send as' .

Exam MB-300: Microsoft Dynamics 365: Core Finance and Operations – Skills Measured

Exam MB-300: Microsoft Dynamics 365: Core Finance and Operations – Skills Measured Use common functionality and implementation tools (20-25%) Identify common Microsoft Dynamics 365 Finance and Operations features and functionality • determine when to use work-spaces • identify use cases for Power Platform apps including Power Apps, Power BI and Microsoft Flow • identify and differentiate between the global address book and other address books • demonstrate Work Items functionality • demonstrate Microsoft Dynamics 365 Finance and Operations navigation techniques • identify Inquiry and Report types available in a default installation Implement Life-cycle Services (LCS) tools • identify opportunities to re-use existing assists • analyze Business Process Modeler results and identify gaps in functionality • including creating an Acceptance Testing BPM library and analyzing the results • use the LCS tools including Issue search and analyze results Configure security, proce

Code to record value in customize field on Sales order packing slip in Axapta

Below is a Code to record value in customize field on Sales order packing slip in Axapta. This code is taken form Ax 2012 version but you can try in D365 also. You need to make changes in method of InitHeader of  class SalesPackingSlipJournalCreate . Happy daxing friends. \Classes\SalesPackingSlipJournalCreate\initHeader

Code to filter particular financial dimension in axapta

Below is a sample code to put filter or range for financial dimension region for any form. If you current form has default dimensions set like region and department and you want to filter only region then this sample code can help you. You need to put in init method of the form.  SysQuery::addDimensionAttributeRange(CustInvoiceJour_ds.query(),                             CustInvoiceJour_ds.name(),                             fieldStr(CustInvoiceJour, DefaultDimension),                             DimensionComponent::DimensionAttribute,                             EmployeeRegion_RangeMST1.GOD_Region,                             'Region');