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

Not all lines are not printed on ProForma report

(1) Share

Report

Posted on by User365

Hi all,

Cant figure out how to print lines with type other than Item on ProFormaInvoice report.

Any ideas?

Best regards

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (0)

Report

Hi

Is this the report? Well, it makes a filter for only the product lines, you could try and subscribe to the event mentioned there, but I'm not sure what could appear in the report after a filter change.

report 1302 "Standard Sales - Pro Forma Inv"

trigger OnPreDataItem()
begin
TotalWeight := 0;
TotalAmount := 0;
TotalVATAmount := 0;
TotalAmountInclVAT := 0;
SetRange(Type, Type::Item);

OnAfterLineOnPreDataItem(Header, Line);
end;

BR

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,574 Super User 2025 Season 2 on at

Like (0)

Report

This is standard behavior. If you need to print something other than Item, you need to customize it using the event mentioned by gdrenteria.

Thanks.
ZHU

Was this reply helpful? Yes No
User365 6 on at

Like (1)

Report

gdrenteria, as i see the data for the lines is collected from the Item table in this procedure

local procedure GetItemForRec(ItemNo: Code[20])

var

IsHandled: Boolean;

begin

IsHandled := false;

OnBeforeGetItemForRec(ItemNo, IsHandled);

if IsHandled then

exit;

Item.Get(ItemNo);

end;

And as far as i know we cant replace this logic with purely custom one. Or am i wrong?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,574 Super User 2025 Season 2 on at

Like (0)

Report

Hi, you can try the following.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,574 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I just made a detailed explanation and hope it gives you some tips.

Dynamics 365 Business Central: How to print all type of lines in standard Pro Forma Invoice report – Customization

https://yzhums.com/50866/

Thanks.

ZHU

Was this reply helpful? Yes No