I need to extract the Sales and purchase contract data out of AX, but I'm getting conflicting data from the reports to the extract. I'm in Sales Contracts, this gives rise to the top part of the screen, my header details and the lower part of the screen, the initial commodity line requirements and subsequent movements. Currently, all I want to do is extract the open order header data and link it to the single line data below, ignoring the movements.
The version is AX2009. I'm sat at the bottom of a Rabbit hole presently as I can't accurately identify 'open orders' or the single line of the original quantity from the tables.
Can anyone help me, please? Once I have done this I need the same for the Purchase ledger.
Thanks
Alan