Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

BC Payment Journal, Message to Recipient

Posted on by Microsoft Employee

Hi,

I have 2 questions regarding Message to Recipient in BC Payment Journal.

Is it possible to change default message in Description from Payment of Invoice...; to something shorter for example Inv.?

When I use Summarize per Vendor BC shows in Description only our company name. Before I was using NAV, and I know, that payment mapping per vendor, I have got all payable invoice numbers in description.

Thank you in advance!

/Julija

  • Suggested answer
    Joe Pirozzolo Profile Picture
    Joe Pirozzolo 22 on at
    BC Payment Journal, Message to Recipient
    Hi, I have just faced this exact problem actually.
    I think custom AL is the only approach as you cannot reach the MessageToRecipientMsg to modify it.
     
    So I subscribed to the event OnBeforeGetMessageToRecipient which allows you to override the message text.
    In the example below, I am setting the text to the payment reference.  But I suppose you could use Message := 'Inv ' + TempVendorPaymentBuffer."Payment Reference"
     
        local procedure OnBeforeGetMessageToRecipient(SummarizePerVend: Boolean; TempVendorPaymentBuffer: Record "Vendor Payment Buffer" temporary; var IsHandled: Boolean; var Message: Text[140]);
        begin
            If SummarizePerVend = False then begin
                IsHandled := True;
                Message := TempVendorPaymentBuffer."Payment Reference"
            end;
        end;
  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: BC Payment Journal, Message to Recipient

    Having reviewed the code the field remains blank as nothing is passed from the purchase header to populate it. This is a modification that could be done with minimal effort.

    A few ways of achieving, naturally, but I would ask your MS partner or in house developer to create a subscription to the event published in table 81 OnAfterCopyGenJnlLineFromPurchHeader. Could use OnBeforePostVendorEntry (or after) if preferred. An IF statement can be applied for the type of document being created in the vendor ledger entry table i.e. an invoice.

    I would think adding a text field to the purchase & payables setup table for your generic message is wise. You could have it dynamic by adding in characters like %1 so the modification can replace it with a meaningful value like the invoice number or better yet for the supplier their number (external document no.)

    I haven't noticed anything on app source that is taking care of this requirement but these steps to the right audience should get you where you need to be.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BC Payment Journal, Message to Recipient

    Thank your comment!

    I am looking for the solution to perform tasks more efficient. I understand that information in Message to Recipient field can be changed manually. My question is more about possibility to avoid manual change and to take advantages of BC.

  • JAngle Profile Picture
    JAngle 33,159 on at
    RE: BC Payment Journal, Message to Recipient

    If you summarise by vendor it will use the company name. If you don't then it will use the "Message to Recipient" field in the vendor ledger entry. By default it is blank on posting but it is an editable field on the vendor ledger entry page. You have edit in excel here so you can do a mass update for instance.

    Failing that you could look at a customisation so it is set with a specific value on posting of the invoice.

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans