Hello,
Is technically/Customizing possible to link the Posted Approval Entry table with the G/L Entry to Get fields Entry No. and Document No. in to Posted Approval Entry table.
Thank you and Regards,
Eri
*This post is locked for comments
Thank you Alexander for your reply.
Can you please advise on how do I populate the Document No. in G/L Entry in to Posted Approval Entry table.
MoveApprvalEntryToPosted(VAR ApprovalEntry : Record "Approval Entry";ToTableId : Integer;ToNo : Code[20])
WITH ApprovalEntry DO BEGIN
IF FIND('-') THEN
REPEAT
PostedApprvlEntry.INIT;
PostedApprvlEntry.TRANSFERFIELDS(ApprovalEntry);
PostedApprvlEntry."Table ID" := ToTableId;
PostedApprvlEntry."Document No." := ToNo;
PostedApprvlEntry."Document No. 2":=GLEntry."Document No."
PostedApprvlEntry.INSERT;
UNTIL NEXT = 0;
ApprovalCommentLine.SETRANGE("Table ID","Table ID");
ApprovalCommentLine.SETRANGE("Document Type","Document Type");
ApprovalCommentLine.SETRANGE("Document No.","Document No.");
IF ApprovalCommentLine.FIND('-') THEN
REPEAT
PostedApprovalCommentLine.INIT;
PostedApprovalCommentLine.TRANSFERFIELDS(ApprovalCommentLine);
PostedApprovalCommentLine."Entry No." := 0;
PostedApprovalCommentLine."Table ID" := ToTableId;
PostedApprovalCommentLine."Document No." := ToNo;
PostedApprovalCommentLine.INSERT(TRUE);
UNTIL ApprovalCommentLine.NEXT = 0;
Regards,
Aron
The relation between those would be on-to-many, meaning that one posted approval entry might be related to numerous G/L entries. I think it is possible, by adding a field "Posted Approval Entry No." in the G/L Entry table and generate respective logic to het that filled with correct Approval Entry No.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (