Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Inserting rows in form...
Finance forum
Unanswered

Inserting rows in form datasource, insert is OK, rows are not visible

Posted on by 477

Basically, I want to insert rows in the form InventJournalTransfer. I added a menuitem button that calls a class which opens a dialog where I fill a WMSLocationId, then I loop on Inventsum table to get all ItemIds with Available qty for this WMSLocationId and insert them into InventJournalTrans Table.

The code I wrote seems to be working as I have correct records inserted in my table(visible in Table browser, correct journalId, linenum itemId, qty etc...) BUT the records inserted do not appear in my form. I tried to refresh my form with or without code, but my grid's still empty.

  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 3,872 on at
    Inserting rows in form datasource, insert is OK, rows are not visible
    Hi,
     
    Did you check the Form Query, maybe your newly added records aren't satisfying the query of the form, are you in the same legal entity that you inserted your records on it? 
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
  • rajborad Profile Picture
    rajborad 249 on at
    Inserting rows in form datasource, insert is OK, rows are not visible
    Hi Sachin,
    Can you please share some screen sorts of Form or X++ code for reference.
     
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans