• How to setup a Sequence number definition using type Database Sequence type?

    Hi We are having problems with frequent locks on table AVALNUM Most of the time the locks are for sequence numbers WRG, WRK (used for various Workflow activities). We hoped that changing these two Number series into the type " Database sequence" might…
  • I would like to set up a sequence number for adding customers that counts by 100.

    My next customer number in the sequence would be 449600 and the next would be 449700 and so on. I understand most of setting up the sequence, but I don't know how to achieve the count in increments of 100. I am guessing this can be accomplished with a…
  • Script Hangs on NUMERO

    I have a very strange issue. I have a custom sequence definition defined in X3. In my 4GL, I am calling NUMERO to get the next sequence number. This worked in our test environment, but it just hangs indefinitely in our pilot environment. I have confirmed…
  • Issue with sequence auto-numbering a document field in 4GL

    Short summary: I've created a custom object screen for change control, set up the sequence number, and can get it to populate with an infbox or before field action on the document field (which populates a number in sequence prior to record creation…
  • Sequential number on custom field

    Hi all, I am trying to create a sequential number logic for a custom field, and I appreciate if someone helps me with a step by step to how to create a sequential number structure for a custom field. The field is on SIH and PIH screen, currently…
  • Journal Entry - Error of non existent sequence number

    Error when turning a journal entry into Final status - Table : ACODNUM , no record found Problem in recovering the sequence number () : non existent sequence number I started a brand new folder from the very beginning and have been doing all the configurations…