• Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • Positive Pay file generation

    When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
  • PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

    Hello All, Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table. I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
  • Script to rename report in Preview

    Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…
  • Same code return different results

    When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…
  • Inter site transfer destination location in report

    The need to create a report form to print out detailed information from and where goods are moved with an inter-site transfer (GESSIS). I can not find where are stored destination locations. Table SCHGD contains only info about a location from where goods…