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