Hello. I am trying to add a custom "Attachment Indicator" field on the G/L Entry table that shows "yes" if the posted entry included attachments and "no" if it did not. I believe I have to create a code unit for this with modify permissions for the G/L entry table. I noticed there are a couple of tables for attachments, but can someone please let me know which attachment table I should check to find if the posted entry had attachments. Also, can someone please advise the best way to trigger the procedure in the custom code unit? Any help/suggestions will be greatly appreciated. Thank you.
Check Document Attachment table (that’s what the Attachment FactBox uses).
Don’t store a flag on G/L Entry—calculate it (page field or FlowField) by checking if attachments exist for Rec.RecordId.
If you must store it, update via Document Attachment insert/delete events, not on posting.
Regards,
Oussama Sabbouh
1 people found this reply helpful.
Was this reply helpful?YesNo
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.
140
Share
Report
All responses (
Answers (
