Sage Accpac Community
Accpac Support Community
Search in

Suppress preceding zeros when showing order numbers etc

Last post 10-22-2008 9:28 AM by BVROB. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-18-2008 11:18 AM

    Suppress preceding zeros when showing order numbers etc

    Hi,

    In 7.2 we now have 10 digit order numbers etc. We only are using 6 digits currently. Is their a way to stop the extra 4 zeros from showing?

     

    thanks

    Ralph 

  • 10-22-2008 9:28 AM In reply to

    • BVROB
    • Top 75 Contributor
    • Joined on 10-22-2008
    • Posts 3

    Re: Suppress preceding zeros when showing order numbers etc

     Go into Report Designer and select the form to edit; create a Formula called "Invoice Number", then use the Strings function ie RIGHT(invoice number field, 6) and this will limit the invoice number to the 6 characters starting from the right side

Page 1 of 1 (2 items)