Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Fill in large scale
Microsoft Dynamics NAV (Archived)

Fill in large scale

(0) ShareShare
ReportReport
Posted on by Rikarddo 265

Imagine this scenario.

I have the contact table that contains a GUN field, flowfield, which looks for the UN in an X table,
and returns the responsible for this UN.
CACLFORMULA = Lookup ("Dimension Value". "Consolidation Code" WHERE (Dimension Code = CONST (UNEGOCIO), Code = FIELD (UN)))

However, I wanted the field to be filled without changing the current architecture of the table. So I created a GUN2 field that is populated every time a new contact is created. And I put this code in the UN - On Validate field

IF DimensionValue.GET ('UNEGOCIO', UN) THEN BEGIN
GUN2: = DimensionValue. "Consolidation Code";
MODIFY;
END;

My problem is that if I have 1000 contacts associated with that UN, I have to modify one by one, and I wanted to do the opposite. Change in the X table the responsible, forcing my new field in the contact table.

Any thoughts?

*This post is locked for comments

  • Rikarddo Profile Picture
    Rikarddo 265 on at
    RE: Fill in large scale

    Nevermind, got it working.

    My bad

    Contact.MODIFY;  

    Thanks for the help

  • Rikarddo Profile Picture
    Rikarddo 265 on at
    RE: Fill in large scale

    I added this code but somehow not working

    Consolidation Code - OnValidate()

    IF "Consolidation Code" <> xRec."Consolidation Code" THEN

    BEGIN

    Contact.RESET;

    Contact.SETRANGE(UN,Code);

    IF Contact.FINDSET THEN BEGIN REPEAT

     Contact.GUN2:="Consolidation Code";

     MODIFY;

     MESSAGE('Test');

    UNTIL Contact.NEXT=0;

    END;

    END;

    It shows the pop up message with Test, but the field in contact table is not being updated. What am i doing wrong?

    Help? Thanks

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Fill in large scale

    Add code on the validation of Dimension value to check if the code is UN and then loop through the contact records to update the GUN2 field.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans