Recent content by sgs.prasad

  1. S

    Resolved Using "Local Variables" in QAD Browse Maintenance

    I think you can just define a function in local variable tab and call it for the respective variable. But here you cannot define any temp-table inside that. Try to get data from the main tables itself.
  2. S

    How to replace entire occurence of a character.

    I dont think you can do that using pre-defined function. Try the below code. def var ctest as char. def var a as char. def var b as char. def var c as char. def var i as int. a = "demo". /*needs to be replaced*/ b = "admin". /*replaced with*/ ctest = "demo1,demo,demo2,test". do i = 1 to...
  3. S

    How to remove duplicate values in a string

    That can be taken care by if condition to overcome the beginning comma if i = 1 then dest = entry(i,source). else dest = dest + "," + entry(i,source).
  4. S

    How to remove duplicate values in a string

    source = ‘a,b,c,d,a,b,c,d”. do i = 1 to num-entries(source): if lookup(entry(i,source), dest)) = 0 then dest = dest + "," + entry(i,source). end.
  5. S

    sod_project field added to Generalised codes,but not showing an error

    I dont think in the program they are validating the field in Generalized code maint. Even though you specficy the value in the Gen code it will be not validated until the same thing is checked in the program. If you want this to be checked then you have write wrapper program
  6. S

    [ask]display item line per line in quote date

    Are you displaying the net sales value based on the Sales Orders, if yes then follow the below points, 1. There is no proper initialization for sumtot1. Initialize the sumtot1 = 0 before the for each idh_hist. 2. display the put statement after for each idh_hist. Hope this resolves issues
  7. S

    mfg/pro general

    The things you are asking are related to customization to standard MFGPRO program. If you have source code then it will be easy to dump the customization code into the standard program. If you dont have code then you have to write wrapper program for the same. Wrapper programs are nothing but...
  8. S

    mfg/pro general

    Could you please be more specific with your question? Do you want any standard mfgpro file (.p or .i) to open file? which file you want to open? and what menu ?
  9. S

    Lost (tag) data when doing the FREEZING

    Then you can directly go for CYCLE RECOUNT instead of tag entries. Perform cycle recount for the latest stock counting. It will have both Inventory and GL impact.
  10. S

    Need Verification of costing - Urgent

    The cost adjustment entry will be passed by system when you change the cost of item. If you have passed any manual JV for the same then you need to reverse it. Note: are you doing it from back end? if you are changing the cost from backend then it will not have any affect on GL
  11. S

    Lost (tag) data when doing the FREEZING

    In this case, it is better to delete the old tag and create new tag for new freezing qty.
  12. S

    Excel Cim load for Purchase Order Maintenance

    There is no specific format of excel file to load the data. It all depends on the user data. The standard MFGPRO will accept only the file which are already in CIM format. The input file specified will not be excel file but the formatted CIM file. Prepare the CIM file based on the data...
  13. S

    how to join abs_mstr?

    In abs_mstr there is one field which stores the sales order number. Please check the table fields of the abs_mstr.
  14. S

    running progress program using unix shell script.

    you can use the following command inside the script/bin/_progress -pf (.pf file name) -p (progress program) where /bin is directory where your progress has been installledNote: please ensure all your .pf files are stored in the specific directory and specify the directory inside the script
  15. S

    Help needed on SYSTEM ERROR: Memory violation. (49)

    I think this might be due to stack error. I think the procedure execution is overwritten in the stack and causing the problem. Please check the -s parameter in the start up script and try to increase the same. Please use PROMON command to get more details regarding the issue.
Top