Search results

I need to do an invoice print but do an invoice print of each line at a time where it shows up on a seperate invoice. Is there a way to get around this as I know doing an invoice post after each line will do the trick but how else can this be done. Thank you.

When we do an invoice print, it generates an invoice number. What QAD table is that invoice number stored at and is it possible to find out what the entity is for that invoice number. Thank you.

Hello, Using gpselout.i, how can I set it to the printer name by default. Thanks in advance.

Hello, The following code does not seem to work: def buffer buff1 for sod_det. def buffer buff2 for buff1. What I need to do is to iterate through a buffer with another buffer. Thank you.

I am unclear as to how the following does not produce any results as display tmp_buff.ln tmp_buff.name does not show the results: def var i as int. def temp-table tmp field ln as int field name as char. def buffer tmp_buff for tmp. create tmp. assign tmp.ln = 1 tmp.name = "one"...

I need to do a DO loop but interative down. Meaning if value is say 50, I need to then go down: 50 49 48 .. I essentially need to do the opposite of how the following works: do i = 1 to 50: display i. end.

Hello, I have a table that has the following info: Ln Part Date Field1 -- ---- ---- ------ 1 part1 09/09/08 2 partxx 09/08/08 3 partyz 09/08/06 4 partki 08/07/06...

Say if I have a frame with 3 fields that are updatable at the same time. The field that are updatable are 'Name' 'Dept' and 'Code' if the user enters say "Accounting" for the Dept then I like to have Code default to "NC". Please keep in mind that all fields are updatable at the same time. One...

I am somewhat confused on what ar_type = "P" represents. I know what ar_type = "I" is when an item was invoiced. But what does ar_type = "P" mean. Thank you in advance for your response.

What is the logic to see if a vendor has been paid in AP? Thanks in advance

I have a string like the following" "98776*". How do I use matches to see if there is an * in a string. val1 matches "*" is what I tried but not working THanks

There are items in QAD that are configured kits and there are items that are just kits. If they are kits, QAD will take all active items for that components for that kit - sob_det. My question is how do we know what items are normal kits vs. configured kits? Thanks

Say if I have a field called ps_ps_code. I like to assign that to a value. ex: x = ps_ps_code. even if ps_ps_code is blank I like to assign x one char. so x would equal " ". another example would be say if ps_ps_code = "12345". I like x gain to be the first character x = "1". Thanks

Hello, I have a temp table. From the temp table. In the temp table, I have 2 fields 1) Name - Will be name of person 2) Delivered (will be YES/NO) I like to create a query browse where I can update only the Delivered field for each name. Once done, I like the info in the query to go back in...

With the following code I am trying to read an input file. If the input file has row1, I do not wish to process it: /* why does undo mainloop, retry mainloop not work if within the input from */ def var cont_val as logical. def var val1 as char. def var val2 as char. def var errval as...

From a given gltr_hist record, how can I figure out what sales order it came from? I see gltr_doc may be of use but not sure how to tie it tall together. Thank you.

I like to find out how many months there are between 2 given dates. For example: 01/01/2010 - 02/28/2010 will result in 2 months. If you have: 01/01/2010 - 03/02/10 the result would be 2 months and 2 days. Any idea on how to handle this. Thanks in advance.

I am having a hard time getting the following to work: on stop anywhere do: message "stopped". end. Can somebody so a simple example from which when ctrl-c is pressed we get the "stopped message". I cannot get this message to come up is the problem. Say if I have the following loop: for...

How is it that the following code : def var sonbr as char. form sonbr with frame a. for each so_mstr where so_domain = "xyz" no-lock: disp so_nbr @ sonbr with frame a. end. displays the field without pausing on the frame. But the following code allows for pauses: def var sonbr...

I need to update sp_sort field with a program. Which other table should I also update as I will not be doing a CIM when I updated sp_sort. Thank you.