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 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,086 Super User 2026 Season 1
YUN ZHU 1,290 Super User 2026 Season 1
AndrewThomas81 1,218
