Sage 100

 View Only
  • 1.  Does anyone know what controls the zero-fill in GL

    Posted 10-20-2016 14:04
    Does anyone know what controls the zero-fill in GL? I have a client that expanded GL Accounts and set the zeros to the front of the existing GL account numbers rather than the back. After some VI Jobs and some change account work, the GL Accounts now all have zeros where they should be, but when typing in an account, it places the zeros at the front by default. So if the client types in ""1010"" for qualified account 101000, the system tries to create new account 001010. Any thoughts?


  • 2.  RE: Does anyone know what controls the zero-fill in GL

    Posted 10-21-2016 05:56
    On a numeric field, I do not think you can type in ""1010"" and have it assume ""101000"". It will always zero fill in the front. Just like typing in a numeric sales order number ""1010""; it will return ""0001010"".


  • 3.  RE: Does anyone know what controls the zero-fill in GL

    Posted 10-21-2016 06:06
    Thanks @MadelineStefanou I was hoping for some voodoo magic since it is set to alphanumeric and both the GL_Account and GL_Main are string fields... but I hadn't thought about Sales Order and PO having the same logic. oh well.