Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Page List with a Varia...
Small and medium business | Business Central, N...
Answered

Page List with a Variable Field, Sorting and Filtering?

(0) ShareShare
ReportReport
Posted on by Greg Kujawa 627
So we are on BC 365 SaaS v23.3. Using VS Code I have created a new list page to display all on-hand items we have in inventory. This list page looks at the Item Ledger Entry table. And displays a combination of:
 
  • Any available items that came in against Purchase Receipt.
  • Any available items that came in against Positive Adjustment (since will be importing in existing on-hand items that we've already paid for when we go-live with BC 365 for our inventory management).
 
The result rows pull as required. But my one small problem revolves around the Vendor No. field in my new list page. This field value is present in the ILE's Source No. field, when it comes to Purchase Receipt. But when it comes to the Positive Adjustment ILE's, the Source No. field is blank. So I fall back to looking at the Item card to determine the /default/ Vendor No. Hence why the Vendor No. field in my list page is a variable. 
 
I can't sort or filter against this Vendor No. field in my list page. Is there a recommended solution path I can look to in order to code that functionality? 
  • Greg Kujawa Profile Picture
    Greg Kujawa 627 on at
    Page List with a Variable Field, Sorting and Filtering?
    Thanks for the response! Yes, that's what I wound up doing. Creating a temporary ILE table for the list page's source, and inserting the rows based on my calculated interpretation of the real ILE rows. Works fine. :) 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    Page List with a Variable Field, Sorting and Filtering?
    Just add some information, if your data is very different from the Item Ledger Entry table structure, creating a new table may have better performance. You can add only the fields you need and define your primary key. And it will be simpler when processing the data.
    When creating a table, you can add the TableType property to Temporary.
     
    Hope this helps.
    Thanks.
    ZHU
  • Verified answer
    Greg Kujawa Profile Picture
    Greg Kujawa 627 on at
    Page List with a Variable Field, Sorting and Filtering?
    As a workaround, I implemented the page list to use a temporary ILE table for its data source. I iterate through the matching ILE records, and for the Positive Adjustment records I determine the default Vendor No. from the item card. And populate that value in the Source No. on the temporary table's ILE record. Seems to work okay, now that I don't have the Vendor No. field as a variable.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans