NAV2013: How to print total invoice amount in footer

Luc_VanDyck · 2013-08-20

On report 206, a Footer was added to print a bank transfer strip (translated from dutch "overschrijvingsstrook"). This Footer contains the bank details of the receiver (= the NAV company that created the invoice), along with a structured reference (such as "+++090/9337/55493+++") and the total invoice amount.

How do I print this invoice amount in the footer of a RDLC-report, knowing that this NAV company makes invoices with and invoices without VAT? How can I transfer the correct field from the invoice lines dataset to the Footer?

clausl · 2013-08-20

Use Code.GetData or ReportItems!, this way you have the right value printed in your Footer.

/Claus Lundstrøm

Luc_VanDyck · 2013-08-30

The needed fields are not displayed in the Expression window after I type =ReportItems! as Expression value for a textbox in the footer, so I guess I'm stuck with Code.GetData? I presume I first need to use Code.SetDate somewhere? Where?

EDIT: I added + Chr(177) + Cstr(Last(Fields!TotalAmount.Value)) to the Expression of textbox CustAddr, and used =Code.GetData(56,1) as Expression of the textbox in the footer, but nothing gets printed.

Marije_Brummel · 2013-08-30

If ReportItems! does not work, then Code.SET/GETdata won't work either I guess.

Can you make a screenprint from the field that you want to transfer?

Luc_VanDyck · 2013-08-30

The total invoice amount needs to be printed in the footer, so this can be either the field TotalAmount or TotalAmountInclVAT.

Marije_Brummel · 2013-08-30

In order to use ReportItems! the cell you want to move to the footer needs to have name or you need to point to the technical name Visual Studio gives it.

Then you can use it like this.

Luc_VanDyck · 2013-08-30

Mark Brummel wrote:

In order to use ReportItems! the cell you want to move to the footer needs to have name or you need to point to the technical name Visual Studio gives it.

Right on! When using =ReportItems!textbox85.Value in the footer, the value gets printed. Now I need to use a iif-construction to print either the amount with or without VAT.

Marije_Brummel · 2013-08-30

Glad it works.

Another option than iif is to add the business logic in C/AL and add the field hidden to the body. This keeps your business logic in one place rather than partly in NAV, partly in VS.

Whatevery works for you off course.

Luc_VanDyck · 2013-08-30

I ended up with 2 textbox controls placed on top of each other, and using an expression to toggle the Visibility.

Thx all for the hints. This is a great forum ;-)

Marije_Brummel · 2013-08-30

Isn't it.

NAV2013: How to print total invoice amount in footer

Answers

Categories