web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

SetFilter() getting no result for warehouse shipment line table

(0) ShareShare
ReportReport
Posted on by 82

Hi fellow developers,

I am trying to Post warehouse shipment lines by warehouse shipment line systemId field but my extension code SetFilter is not returning any result.

Below is the code I used

var

whseShipLine: Record "Warehouse Shipment Line";

begin

whseShipLine.SetFilter(SystemId, 'input system ID string');

//rest of the posting code...

end;

I have tried many combinations of SetFilter fields and checked the input system ID against the warehouse shipment line table multiple times but I kept getting empty field from the SetFilter. Can someone please help let me know what is the reason for not filtering properly? Thanks a lot!

I have the same question (0)
  • Verified answer
    Saurav.Dhyani Profile Picture
    14,362 Super User 2025 Season 2 on at
    RE: SetFilter() getting no result for warehouse shipment line table

    if you know the GUID for the record then you should use Get like -

    whseShipLine.GetBySystemId

  • Verified answer
    YUN ZHU Profile Picture
    93,151 Super User 2025 Season 2 on at
    RE: SetFilter() getting no result for warehouse shipment line table

    Hi, hope the following will help.

    How to get a record by its SystemId:

    https://yzhums.com/13242/

    Thanks.

    ZHU

  • Ginger Frog Profile Picture
    82 on at
    RE: SetFilter() getting no result for warehouse shipment line table

    Thanks a lot ZHU. I am missing the FindFirst() in my code and that's why I can't get the filtered result. This solves the problem.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,750

#2
Sumit Singh Profile Picture

Sumit Singh 2,689

#3
YUN ZHU Profile Picture

YUN ZHU 1,987 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans