Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / SetFilter() getting no...
Small and medium business | Business Central, N...
Answered

SetFilter() getting no result for warehouse shipment line table

(0) ShareShare
ReportReport
Posted on by Ginger Frog 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!

  • Ginger Frog Profile Picture
    Ginger Frog 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.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 85,329 Super User 2025 Season 1 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

  • Verified answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,316 Super User 2025 Season 1 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

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans