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

BC Payment Journal, Message to Recipient

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

JAngle 157 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

JAngle 157 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Joe Pirozzolo 24 on at

Like (0)

Report
Copy link

Link copied!

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;

Was this reply helpful? Yes No