Skip to main content

Posts

Showing posts from September, 2020

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.