Dynamics AX 2012 : SQL Query to find Invoice and How it is Paid / Allocated / Credit Note / Cancellation etc RRS feed

  • Question

  • Hi 

    I am struggling to Track how customer  invoice is settled  through various steps . I want to build query using below tables like 


    CUSTTRANS , CUSTSETTLEMENT   not sure  what tables else  I need  it 

     Say  I have Invoice 0001 , invoiced on 1st Of June 2017 , partially credit noted , partially allocated from Prepayments , Partially Paid , Partially Unsettled / settled Again .  How can i see the entire invoice settlement life cycle from Invoice raised stage to full settlement and How to tie up credit notes issued against invoice  etc 

    Thursday, December 7, 2017 9:45 PM


  • I'd ask for help over here.




    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Richard MuellerMVP Thursday, December 7, 2017 11:38 PM
    • Marked as answer by pituachMVP Wednesday, December 13, 2017 5:43 AM
    Thursday, December 7, 2017 9:57 PM