General Consultant Discussion

 View Only
  • 1.  A/R Invoice Number Expansion - Sage Development Survey JUNE 2024

    Posted 05-31-2024 15:51

    Hi everyone, in preparation for the Sage Development Roundtable scheduled for June 20, 2024  (Register Here)

    Please review the post below and complete the Survey before next Thursday, June 6, 2024.  Thanks! 

    Sage Development Survey June 2024

    Sage 100 Release 2025

    A/R Invoice Number Expansion 

    Requirements

    • The Accounts Receivable Invoice Number will increase from 7 to 20 characters.

    • No conversion for existing 7-digit invoice numbers.  Invoice 0000001 will stay as 0000001 after conversion.

    • A new A/R setup option will determine the length to zero pad (or zero-fill) the invoice number. This option allows you to determine the number of zeros that will be used to fill the length of the invoice number. 

    • If the invoice number starts at "100" and you require 20-digit invoice numbers, the number will automatically zero-fill to 20 digits, 00000000000000000100 (17 zeros + 100). The padding of the zeros may make the invoice number difficult to read.

    • Adding an option will allow you to reduce the number of zeros. For example, if the option is set to 10 and the invoice number starts at 1, the Next Automatic Invoice Number will be set to 0000000001 (9 zeros + 1). 

    • You will still be able to enter an invoice number up to 20 digits, regardless of this option.  For example, if the option is set to 10, you can enter 12345000001001 (14 digits) in the Next Automatic Invoice Number. It will not zero-fill and will increment accordingly, 12345000001002, 12345000001003, etc.

    • You will also be able to enter characters. It will not zero-fill when characters are used.

     

    Invoice Number starting at 1 and zero-filled to 10 digits

    Invoice Number entered with 14 digits, no zero-fill

     

    Invoice Number entered with characters, no zero-fill



    ------------------------------
    Anne Sawyer
    Executive Director
    90 Minds Inc.
    Sunset Beach CA
    ------------------------------


  • 2.  RE: A/R Invoice Number Expansion - Sage Development Survey JUNE 2024

    Posted 05-31-2024 20:17

    When they refer to AR invoice number, are they including SO invoices???  It would seem silly to think they wouldn't, but this is Sage.  What about SO numbering?  What is the reasoning behind 20?  Is that how many Intacct has?  20 seems like overkill.  I like the ability to limit it to a lesser number, but not having a hard limit is questionable.  I like the idea but am concerned with execution.  After rereading the survey, it would be nice if they provided an area for other questions/comments.  Because of the limited questions/responses and the inability to add comments overall (see questions above), I wonder if they have already committed and are looking for justification.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 3.  RE: A/R Invoice Number Expansion - Sage Development Survey JUNE 2024

    Posted 06-04-2024 12:42

    Hi Jeff - I will pass this on to the team.  Please feel free to post any additional questions or comments outside of the survey here.  Everything will be sent to Elliott and Laura.  Thanks! 



    ------------------------------
    Anne Sawyer
    Executive Director
    90 Minds Inc.
    Sunset Beach CA
    ------------------------------



  • 4.  RE: A/R Invoice Number Expansion - Sage Development Survey JUNE 2024

    Posted 06-04-2024 13:16

    I was thinking an "allow expanded" option makes the most sense (similar to expanded ItemCode values), with an optional utility to update history with leading zeroes.  That way, clients who don't need the new feature don't have the associated data conversion headaches.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 5.  RE: A/R Invoice Number Expansion - Sage Development Survey JUNE 2024

    Posted 06-10-2024 12:38

    Happy Monday everyone

    I will be sharing the survey results and all comments with Sage tomorrow.  Can you please post any additional comments, suggestions, etc. for the development team here today? Thanks!



    ------------------------------
    Anne Sawyer
    Executive Director
    90 Minds Inc.
    Sunset Beach CA
    ------------------------------