Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Data in Grid

(0) ShareShare
ReportReport
Posted on by

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

  • Sohaib Cheema Profile Picture
    46,614 User Group Leader on at
    RE: Data in Grid

    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.

  • Community Member Profile Picture
    on at
    RE: Data in Grid

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

    Please look at the image it is standard invoice

    7367.INVOICE.png

  • Sohaib Cheema Profile Picture
    46,614 User Group Leader on at
    RE: Data in Grid

    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.

  • Community Member Profile Picture
    on at
    RE: Data in Grid

    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

  • Sohaib Cheema Profile Picture
    46,614 User Group Leader on at
    RE: Data in Grid

    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?

  • Dick Wenning Profile Picture
    8,705 Moderator on at
    RE: Data in Grid

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

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

  • Community Member Profile Picture
    on at
    RE: Data in Grid

    grid1.png

  • Community Member Profile Picture
    on at
    RE: Data in Grid

    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

  • André Arnaud de Calavon Profile Picture
    292,923 Super User 2025 Season 1 on at
    RE: Data in Grid

    Hi Afridi,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,923 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,788 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans