Regarding Pld from data base field....

[Former Member]

hi..

in sales order...i am adding one document..

defaulty one pld setup is there  it is ok..

what i need is...

in data base  items are saving like..

itemcode   userdefined field

A00001      p1

i0001         c1

i0002         c2

i005           c3

A00008      p2

dsd            c1

dd              c2

A89999       p3

in pld  all the items are comming

one of the column is itemcode comming from db..

but what i need is  A0001,A0008,A8999  only

Which means only bill of materails  only it shoul come...

i001  and i005  should not have any bill of materails  any information..

plz inform me..

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please advise your BOM type.

If sales BOM type, select check box "Hide BOM Components in Printout" under Bill of material window. While printing or previweing the compoents won't appear in PLD.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

hi

my bom type is template....

[Former Member · Accepted solution]

Hi,

If you are using Template BOM for that you need to create an item which you will set as a sales item otherwise it'll appear in Sales Order correct... If You select it as Sales Item then you can use it Sale BOM item. I'll suggest you to chabge your BOM type From Template to Sales BOM. Could you please tell me reason to use template type of Bill of material if it fullfill all your requiremnt as Sales BOM type.

[Former Member · Accepted solution]

k thanks for your reply...

exact reason i dont know

the same quesiotn i have to ask to the  my fuctional consultant..

Tell me one thing

if it is  bom type is template.... we can not achive  am i currect

jus one word...

[Former Member · Accepted solution]

Hi,

Not sure if PLD can handle this requirement.

you may check the same in crystal report.

But as far as the system setting is concerned, if you use Sales BoM, you have only these tw options.

Thanks,

Joseph

[Former Member · Accepted solution]

Yes yes chekcing....

Thank u for ur surrport

keep posting...

[Former Member · Accepted solution]

Hi

I got a solution but for that you have to do some Little bit efforts...

1. Create new filed in PLD at row level let say F_102

2. No go to Content tab and select these info...

    Source Type: Databae

    Table : Sales Order: Row

    Column:  BomType

3. Add it and keep it Invisible.

4. Create another field and in PLD go to Content Tab and do the same Let say F_103

    Source Type: Formula

    Put Formula : F_102!='N' and Save it.

5. Now you have to link all row level field with this field F_103.

Go to each field mentioned in Row Level and go to General tab in Field Properties and Click on "Linkto" and select F_103

Hope it'll help you....

[Former Member · Accepted solution]

Hi,

Did you try the given solution??

[Former Member]

Hi,

Could you please share your scrrenshot here??

[Former Member]

hi,

Thanks for your reply..

[Former Member]

Hi,

If you are using Sales type BOM in Sales Order then try to add sales order by updating this amendment.

[Former Member]

Hi,

Please Follow the step which mentioned in Screenshot...

[Former Member]

This is the only solution  for getting the result..

Actually they need two type of report....

one is  all items

antoher one is only bom report....

if i hide it...

in another case it will be faile..

i think....

[Former Member]

Thanks for your reply...

have a look on below image...

i took bom type is  template

[Former Member]

Hi,

It's Better to go for Query Print layout design or Crystal report.

[Former Member]

Hi,

Have you checked Document Settings-->For Sales BoM in documents...?

Which option is activated? You can choose to print parent item only..

Thanks,

Joseph

[Former Member]

If u dont mind can u plz show me the picture.. of document setting i dont know where it is ....

[Former Member]

Hi,

Go to Administration--> System Initialization--> Document Settings --> General tab.

Thanks,

Joseph

[Former Member]

k i will check it..

[Former Member]

hi.

I changed it

but still it is comming every thing