Microsoft Dynamics AX (Archived)

Data in Grid

(0) Share

Report

Posted on by Community Member

Dear Expert

I have a grid on form which is bound to data source "TableA"

Now I want to populate this grid Column "itemId" From table SalesLine column (itemid).

As the user enter invoice no in text box i want to populate the grid and create rows in grid

automatically.

Thanks in advance

AFRIDI

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Afridi,

Can you please elaborate? I'm not getting the complete requirement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Andre

I want to create A form with

A Grid bound to table "MTable" with colum ItemId from "MyTable"

I want a text box on form when user enter SalesOrder Number

it brings all itemid for that "Sales Order Number" from salesline table

and display on grid.

later user will enter data on grid second colum like "Toll Tax ", "Over Time"

Thanks

Afridi

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report
Copy link

Link copied!

add your datasource to the form, with inner join , to salesline

it should work from that point, similar like salesline with inventdim table

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Let’s keep your technical requirement aside & Discuss business scenario.

Are you trying to do something such as charges on top of Sales Order Invoice?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Sohaib

Yes i want to add additional charges on Sales Order, In my Sales Order normally contains more than 100 rows

to create logistics invoice and each row represent one trip for vehicle. and in that trip i have to enter

1. Toll Tax 2. Meal Amount 3. Over Time, if I enter all this in Sales Order It will be (100 Trips * 300)

So I want to create separate form let user to enter all these expenses. this will help us to create our P & L

and we can print invoice as per client requirement.

Thanks & regards

Afridi

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

what are the problems at "Using Existing functionality of charges", which allows you to allocate charges. in addition it also allows you to maintain charges after invoice.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Than every Line in Sales order will be having 3 lines of charges minimum

Please look at the image it is standard invoice

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

you can allocate charges line-wise in dynamics ax

kindly study how these are working at standard ax. if those does not work for you, share with us the reasons so we can further help you.

Was this reply helpful? Yes No