general journal entry custtrans

this select can  help to connect GeneralJournalEntry to CustTrans.

select DocumentDate from generalJournalEntry
exists join generalJournalAccountEntry
    where generalJournalAccountEntry.GeneralJournalEntry == generalJournalEntry.RecId
exists join subledgerJournalAccountEntry
    where subledgerJournalAccountEntry.GeneralJournalAccountEntry == generalJournalAccountEntry.RecId 
exists join subledgerJournalEntry
    where subledgerJournalEntry.RecId == subledgerJournalAccountEntry.SubledgerJournalEntry
       && subledgerJournalEntry.Voucher == currentTrans.Voucher
       && subledgerJournalEntry.VoucherDataAreaId == currentTrans.dataAreaId;

Advertisements

Preparation for MB6-894: Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations. Understand the architecture and development environment. Part 3

  • Describe the Microsoft Dynamics 365 for Finance and Operations architecture
    • Describe the development environment; describe the components in the application stack; identify cloud architecture components; explain the server architecture; describe the layer architecture

Quote from https://www.microsoft.com/en-us/learning/exam-mb6-894.aspx

Identify cloud architecture components

there are 3 main areas

  • Life cycle service – shared services that include but are not limited to
    • project traacking
    • issue submission
    • issue tracking
    • environment monitoring
    • service level agreement monitoring
    • data managment
    • software deployemnt
  • D365 for Finance and Operations
    • VM instances for D365
      • different topologies
  • Shared services – enable one Microsoft solution, where everything can be managed with single login

 

Preparation for MB6-894: Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations. Understand the architecture and development environment. Part 2

  • Describe the Microsoft Dynamics 365 for Finance and Operations architecture
    • Describe the development environment; describe the components in the application stack; identify cloud architecture components; explain the server architecture; describe the layer architecture

Quote from https://www.microsoft.com/en-us/learning/exam-mb6-894.aspx

Describe components in the application stack

Application stack is divided in 3 distinct models. Actually there are more models involved, but this is for overview purposes only

  • Application Platform -is the core of application.
    • run time and data access framework
    • workflow framework
    • client and presentation framework
    • SSRS framework
  • Application Foundation build upon platform adding things like
    • Organization model
    • Number Sequences
    • Global address book
    • source document framework-
  • Application suite – business logic modules
    • inventory and warehouse managment,
    • HR
    • financial managment

Preparation for MB6-894: Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations. Understand the architecture and development environment. Part 1

In this series of blog posts we will try to walk through the description of the Exam MB6-894. And look through the skills that are required for it. If you find any mistakes or in need of any explanations please do not hesitate to contact me.

  • Describe the Microsoft Dynamics 365 for Finance and Operations architecture
    • Describe the development environment; describe the components in the application stack; identify cloud architecture components; explain the server architecture; describe the layer architecture

Quote from https://www.microsoft.com/en-us/learning/exam-mb6-894.aspx

Describe the development environment.

Development environment for D365 is Visual Studio. I am using version 15

Settings that might be worth to know:

  1. How to make sure elements in the project will be organized by the type
  2. How to make sure that the project are configured automatically to synchronize on build1_1
  3. The Line numbers are shown
  4. Enable word wrap1_2
  5. Disable IntelliTrace for the debugging

Terminology that can be used in test:

Understand difference between:

  • Elements – is the object that can be found in AOT. Together elements define the system, and what will be shown to the users in front end. Elemnts can be customized and added to projectsdis
  • Models – group of elements that are related by a common originator, purpose, or other grouping
  • Projects
  • Packages

Know different AOT views and how to enable them:

  • Classic View
  • Model View

Understand concepts:

  • design time
  • deployable software package
  • run – time

 

 

open task manager from cmd

sometimes when you use the Azure connection to AX, but you have no connection to the environment where AX is run, you can face situations when you have to terminate some kind of process.

For example you accidentally tried to copy all records of the really big table, and everything is hanging, and you can’t continue working because nothing is responsive.

If you have a connection to the cmd on the same environment you cans invoke task manager by entering taskmgr. and then you can terminate everything that you want 🙂

How to know if user has a worker assigned to it

If your user has a worker then you will have connected records in following two table DirPersonUser  and hcmWorker.

In dirPersonUser table you can have a look at the user id, and using PersonParty field, try to find related record in the hcmWorker table,( field Person)

 

Or you can use the easy way ( by using hcmWorker.serid to worker method 🙂