PLD Sales Order Colsum() of quantity

[Former Member]

Hi, experts!

I have a customer with any deliveries dates(docduedate) in lines. And a group to itemsgrpcode. In sales order have columns by month based in docduedate to indicate in what a month this items needs to do delivery.

1. Create a formula to show the month Field_XXX (Month(DocdueDate)).

2. Create 12 formulas Field_xx1(Field_XXX == '1'), Filed_xx2((Field_XXX =='2') ...

3. Set this fields Visible = 'N'.

4. Create 12 Formula fields associate a Fieldxx1, Field_xx2... to show the quantities(Field_089)

But in the the first group (itemsgrpcode) when I create a column sum of the quantities(Fieldxx1) for month show me in all columns the same total. This total is a total of quantities how a create a column sum of the field_089.

Why is it happen?

[Former Member]

Hi, bellow I try describe the scenario.

In sales order lines I have any distincts duedates. In Sales Order Report I need show the total quantities for each month.

ie.

Sales Order Lines

Line ItemCode QTD DueDate

1 A 1 01/01/08

1 A 1 01/02/08

1 A 1 01/03/08

1 B 1 01/01/08

My PLD

ItemCode Jan Fev Mar Abr May Jun Jul Ago Sep Oct Nov Dec Total

A 1 3

A 1 3

A 1 3

B 1 1

ItmsGrpCode

A1 4 4 4

B1 1

I can show the quantities for moth for each itemcode but in Group ItmsGrpCode show me in total for month

the total of the quantities

PLD Correct

ItmsGrpCode Jan Fev Mar Abr May Jun Jul Ago Sep Oct Nov Dec Total

A1 1 1 1 3

B1 1 1

Total 2 1 1 4

[Former Member]

Hi,

I could not see which one is the trouble...

Do you want to summarize one column or do you want to add another column?

Regards.

--

Enriquillo Guigni

[Former Member]

Hi,

It's a little bit confusing but if I understand correctly, you are using the link to option to display or hide the fields with the quantities. Then you try to summarize these fields to display the total.

The problem with this is when you have a field with a value and you link it to another field to display/hide the value in certain circumstances, it just makes the field invisible but the value is still there. So when you have these fields summarized, it will give you the total of all the fields because the values are there but they are not visible.

I think what you are trying to achieve here is not possible in PLD, but probably it is by creating some UDFs or some programming.

Regards,

Nat

[Former Member]

Hi Enriquillo,

How I have quantities for each month I need a Sum for each month. I can show the quantities for month. But when I try summerize columns this sum is allways the same.

[former_member182291]

Hi,

I am not sure I understood your exact scenario, but if you want to display fields with conditions like you described

you probably use the "relate to" a certain field.

But then, if it is related to a condition field like F_100 == '1' you should check the "suppress zeros" property of that condition field\item.

Please give me more details of the scenario. if that is not what you meant.

Regards,

Tuvia.