• 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…
  • 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…
  • Validation rule on a custom field

    Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…
  • 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…
  • Two different tabs using the table screen type.

    Good day everyone, I am going to be grateful if I get a reply to one of my challenges. I am trying to create two tabs with the table screen type. I am successfully making on the tab save data to the database but the other tab cant save data into the database…
  • Make A New Field

    How can I make a new field on the invoice? When an invoice is created I want to use this new field with drop down options that the team can use to tag invoices. So when reporting is done they can filter for a specific report.