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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 774 Super User 2026 Season 2
YUN ZHU 569 Super User 2026 Season 2
AndrewThomas81 296 Super User 2026 Season 2
