[PLD] Subtotals are wrong displayed in layout

[Former Member]

Hello,

I have question containing subtotals in print layout designer. I have searched quite a while for relevant topics, but I couldn't find anything that came really close.

Summary of the problem

I want to create a layout for a quotation that can handle:

- text

- items

- subtotals

I made my layout, but when a excisting quotation is being printed, the subtotals are displayed on the wrong place.

After that I tried to use a different systemvariable, but that displays the wrong ammount of money.

Anybody of you has experience with this problem and is able to help me out? If you need more info, go ahead and ask.

Thanks in advance,

Hendri Wessels

Edited by: Hendri Wessels on Nov 27, 2008 12:58 PM

[Former Member · Accepted solution]

Hi,

Please check SAP notes 1255296,1232170,918132.

Regards,

Abhinav Banerjee

SAP Business One Forums Team

[Former Member]

hello hendri,

first you u have to enable the type on your quotation form. to do this, check the tick box on your form settings under the column type, check the visible and active tick boxes. when the type is already visible from your quotation form type is now visible, from there u can choose whether text or subtotal.

Now on your Print layout, please do the ff.

on your layout, put a data field on file, choose Sales Quotation - rows and in the field choose text. and on link 2 field, link it to itself base on its field exclusive No. add 2 formula fields and 1 text field. on the text field put it T, meaning text, on the first formula field evaluate it as "Field 1 != field2" and the 2nd formula field as "Field 1 = field 2".

now this is the way it works.

if 1st formula is true, it display the row of your Quotation and if the 2nd formula is true it will display the text or the subtotal...

hope u can follow my English...

FIDEL

[Former Member]

At first: thanks for your reply. I did unsterstand it quite well.

I had allready made the fields you mention, even before I posted this topic. That is the strange thing about it: you say: it should work like this, and yes, it should have worked, but it doesn't. Only thing I can come up with is I linked something wrong...

But the strange thing is it worked before I added subtotals. Everything works fine as long as I don't add subtotals. Even text rows do work...

I have tried some several hours allready, but I can't get it working.

[Former Member]

hi hendri,

just wanna know your SBO Version...

Fidel

[Former Member]

My version is 2007A and the patchlevel is 42 and there are no additional add-ons working.

[Former Member]

sorry but i have a lower version running on my machine. i'm not sure where it went wrong, but the approach that i shared to u is perfectly working here.

Best regards

fidel

[Former Member]

Well I will have a look at it again myself and I have to find out what causes the bug. Thanks for your effort I will give you some points for it.

[Former Member]

You can also check the SBO-sample, the layout: "Order Confirmation (DIN) (System)"

hth

Chief

[Former Member]

Gentlemen,

Thanks for your replies! I have taken a look at the system layouts allready, but that did not brought me the solution. I will have a look at the SAP Notes, thanks for the advice.I hope it will give me the right information.

[Former Member]

According to one of the notes it is a bug in SAP. Now I have hard copy evidence for my customer that I am not to blaim Thanks for that.