QAD browse that shows Primary Lines as set in 18.22.1.1

QAD_Hack_2021

New Member
Hello, I need some help finding a browse that will show the Primary Lines field (Yes / No) information.
We set Primary Lines in 18.22.1.1 so that when when using 22.20.1 Master Scheduling Workbench it will indicate the MRP demand.
18.22.1.3 is a browse that shows most of the information but doesn't show the Primary Lines tag.
When using CIM loads the data field used to load the Primary Line is called: Primary Line / v-Primary / 4/5-C-L

I have tried to design a custom design a browse but the data field v-primary lines is not available or I don't know which database it's in.

primary lines.jpg
 
This is the code for Primary Line value:
Code:
 v-primary = no.

               for first lna_det
                  fields( lna_domain lna_allocation lna_line lna_part lna_site)
                   where lna_det.lna_domain = global_domain and  lna_site =
                   lnd_site
                    and lna_line = lnd_line
                    and lna_part = lnd_part
               no-lock: end.

               if available lna_det then do:
                  if lna_allocation = 100 then
                     v-primary = yes.
               end.
 

QAD_Hack_2021

New Member
Thanks for the reply Marco!
I have one more question about your answer.
Does this code go on the Filter tab or the Pre-Processor tab?
Sorry, but I am learning as go and appreciate the help!
 
Define a function on "Local vars" section. And add a Calculated Field (local-var00) and call the Function created on Local vars.
 

QAD_Hack_2021

New Member
Hello Marco, I don't have a 3.6.11 and icbr007 opens 3.6.1 which didn't have any example of the code although it did use variables, but I didn't see that they had been defined anywhere in the browse.
I was able to create the local-var00 and add to the browse fields. See below.
1644890113644.png

Hopefully, I pasted the code in the correct spot, as below.
1644890666408.png

Then, on the local_variables tab I added the variable, hopefully correctly.
1644890926890.png

So, when saving, I'm sure know what's coming...
I get this lovely message:
1644891046330.png

I appreciate any additional guidance you willing to provide.
 
You need to convert the code to a Function.
On Browse Maintenance 36.4.8.13 open ic007. Or search for other examples; there are a lot of browses with defined Functions.
 
Top