Finance | Project Operations, Human Resources, ...

Sales Contract Data

(0) Share

Report

Posted on by alan.cook@kaleida.c...

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

I have the same question (0)

All responses (6)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Sales Contract Data

Hi Alan,

So the issue is fixed then right?

Best regards,

Ludwig

Was this reply helpful? Yes No
alan.cook@kaleida.c... 17 on at

Like (1)

Report

RE: Sales Contract Data

Hi Steven

Thanks for the response, it appears that the module is completely bespoke. However i have managed to piece together a query that appears to provide me with the inform aion i require. Many thanks for the response, it was appreciated.

Kind Regards

Alan

Was this reply helpful? Yes No
alan.cook@kaleida.c... 17 on at

Like (0)

Report

RE: Sales Contract Data

Hi Ludwig

It would appear that this is a completely bespoke module. I have managed through data minig and review to pirce together a query that on the fac of it pulls out the information i require. So at this point I think the problem has gone away. Thankyou for your response though it was appreciated.

Kind Regards

Alan

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Sales Contract Data

Hello Alan,

Have you been able to review the feedback provided?

Can you provide us more information or let us know what the community can possibly help you with?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Weaveriski 23,616 Moderator on at

Like (0)

Report

RE: Sales Contract Data

I agree with Lugwig, there were sales blanket orders in AX2009 but "Contracts" would either be an ISV add-on or a development.

How are you trying to extract? What are the table names?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Sales Contract Data

Hi Alan,

When you say sales and purchase contract data do you refer to something that has been modified in your system?

Can you possibly share some screenprints and / or additional information on those contract data that you want to extract?

In addition, what does extract mean? Do you need an Excel export or a report or something else?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No

Community site session details

Sales Contract Data

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Sales Contract Data

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates