Notifications
Announcements
No record found.
Hi,I'm want to check if record/get a record from the Purchase Lines table via the Document number. The SQL table shows these 2 records on the Purchase Lines:I want to find the record with Document Number form the Purchase Line: PCT00049But it can't find the record..Not sure if this has something to do with the trigger that is created as a page extension on the Commodity Receipt screen, where the Document number is linked with the action of the triggerCommodity Receipt Header
Kind RegardsJaco
Hi,
Rec.Setrange("Document No.",'PCT00049');
if Rec.FindFirst then begin
Message(Format(Rec.RecordID.getRecord()))
Message('Order Found');
end;
Regards
Amit Sharma
www.erpconsultors.com
press yes if info is useful.
Hi Amit, thanks
Got itIt is getting this record:
hi,
Welcome
Pls verify the answered. if useful.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,010
Jainam M. Kothari 1,270 Super User 2025 Season 2
YUN ZHU 1,085 Super User 2025 Season 2
