Skip to Content
avatar image
Former Member

only items to be appear of which row status is Open

Hi experts

i am using PLD for AR invoice, what i need is if any row status is closed in the Document those items in the closed items should not appear in the Print out

as of now its comming

how can i solve this issue, pls help me by guiding me step by step process

i know it was easy if we use CR , but our management need in pld

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

14 Answers

  • Best Answer
    Nov 04, 2016 at 09:59 AM
    -1

    You already have the answer

    Create 3 new fields in the repetitive area, say F_101,F_102 and F_103

    For field F_101, configure the field as database type and map the sales order->Rowstatus, uncheck the visible option (Assumption that Get Description checkbox is enabled)

    For field F_102, configure the field as formula type and use the formula as F_101=="Closed" , uncheck the visible option

    For field F_103, configure the field as formula type and use the formula as F_101=="Open", uncheck the visible option

    Choose all the row fields like Item,description,qty etc..use the Link to option and map them to F_103.

    This will help you to achieve your requirement.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gonzalo Gomez

      Hi Sir

      I created a new test template and done as per you guide, not some changes is happened

      but still an issue is pending , when i link the F_129 with all the row level only the Item code field is not disappearing its still appearing

      all other like , dscrp, qty,unit price, row total,is not appearing if the row level is marked as Closed

      Pls see the Screen Shot

      And pls guide me for further Steps

      Regard

      untitled7.png (170.1 kB)
  • avatar image
    Former Member
    Oct 24, 2016 at 05:18 AM
    -1

    PLS ANY SOLUTIONS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2016 at 07:41 AM
    -1

    yes, they need to use the same in pre-print paper

    so pls give a solution

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2016 at 12:49 PM
    -1

    does any one have the solution

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 10:07 AM
    -1

    Any updates

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2016 at 11:33 AM
    -1

    Hi experts

    Any updates ,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2016 at 06:59 AM

    Hi,

    Just wonder is there a specific reason from management to insist on using PLD?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 02:36 PM

    Create 3 new fields in the repetitive area, say F_101,F_102 and F_103

    For field F_101, configure the field as database type and map the sales order->Rowstatus, uncheck the visible option (Assumption that Get Description checkbox is enabled)

    For field F_102, configure the field as formula type and use the formula as F_101='Closed' , uncheck the visible option

    For field F_103, configure the field as formula type and use the formula as F_101==F_102, uncheck the visible option

    Choose all the row fields like Item,description,qty etc..use the Link to option and map them to F_103.

    This will help you to achieve your requirement.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2016 at 04:14 AM

    Dear Shahan

    After you create the third field, and try to view this field per each tab. Then you can find and apply M. Sundararaja Perumal 's answer.

    Regards

    Edmund

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2016 at 08:09 AM

    Hi,

    Third field controls printing rest of the fields because they are linked to third field. Printing depends on the condition mentioned therein.

    Also you can go for crystal report where you can filter the rows on DOCSTATUS very easily.

    Regards

    Narayani

    Add comment
    10|10000 characters needed characters exceeded