web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Link between items tra...
Microsoft Dynamics AX (Archived)

Link between items transactions and GL entries

(0) ShareShare
ReportReport
Posted on by JauB 352

Hello Everybody

Do we have in AX any link between items transactions and GL entries ?

For example, to link items that we can have in CustPackingSlipTrans and GeneralJournalAccountEntry ?

My need is to link amounts in GeneralJournalAccountEntry with there origine in CustPackingSlipTrans like in this scenario :

some times we have for example 2 items in CustPackingSlipTrans  with the same Product Group Item1 (with Amount = 100) and Item2 (with Amount = 200) in my GeneralJournalAccountEntry  i will get 300 as amount, but I want to have an automatic explanation for this last Amount from CustPackingSlipTrans using SQL Query.

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The linkage is established in the inventory posting matrix that you can find under inventory/setup/posting/posting.

    What is it that you want to achieve actually?

    Best regards,

    Ludwig

  • JauB Profile Picture
    JauB 352 on at

    Hi Ludwig and sorry for the delay because I didn't see that you asnwered to my question !

    So, I'm not looking for the posting profiles but the link between Items Transactions and the entries that are generated in GL.

    My example was  : 

    some times we have for example 2 items in CustPackingSlipTrans  with the same Product Group Item1 (with Amount = 100) and Item2 (with Amount = 200) in my GeneralJournalAccountEntry  i will get 300 as amount, but I want to have an automatic explanation for this last Amount from CustPackingSlipTrans using SQL Query.

    ==> What ill be the SQL Query for linking CustPackingSlipTrans   and GeneralJournalAccountEntry  to explain this amount in GL (300 which is agregated) refering to their original transactions in CustPackingSlipTrans  ?

    I hope it's clear :)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans