Skip to Content
avatar image
Former Member

Need help: SAP B1 [Edit Print Layout] with [system variable]

Hi,

I need help with SAP 2007 Bussiness One's system-variable for the "Edit Print Layout" of the 'AP CHECK'.

I have a label field that needs to to be able to dynamcially display data from the Database

depending on the datatype.

Here is my situation:

My "AP CHECK" have line-items and each line-item can either be a [Credit-Memo] or [Invoice].

I need to know how I can display each line-item data using one label field (variable)

Many Thanks,

Tim L.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 23, 2009 at 10:48 PM

    Tim,

    You will need to use 2 formula field to evaluate the document type and have 2 text field and link them to each formular. When the formula returns true the related Text would be displayed

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I found out how to figure the DataType for the mentioned document-types, thanks to a colleague at work.

      SAP uses a field called "ObjType" to define a document type.

      In my case, the AP Credit-Memo is ObjType = 14 and the AP invoice ObjType = 18.

      Now I can use what Suda had suggested, use two formulas to conditionally set the two Text Field data to be "visible" based on the ObjType.

      Hope this can jelp other and Thanks for the suggestions.

      Tim L.

  • avatar image
    Former Member
    Apr 23, 2009 at 10:58 PM

    Please check this thread for conditional fields:

    How to use If condition in formula editor of PLD

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded