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?
