Alpha Video Training
Results 1 to 6 of 6

Thread: Global Update for Invoice Numbers

  1. #1
    Fancy Plants
    Guest

    Default Global Update for Invoice Numbers

    Does anyone know which operation(?) to use to globally update invoice numbers? We have reoccuring invoices and used a global update using system grand + an invoice number. Each record was then updated sequentially with a new invoice number. Cannot figure out how to do this in A5. Any suggestions? -Donna

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,625

    Default RE: Global Update for Invoice Numbers

    Have you looked at the update operation in Alpha 5?

    From the control panel, click the operations tab and the new button.

    Scroll down the left column and the last type of operation is update. It's the same as the Alpha 4 global update.

  3. #3
    Fancy Plants
    Guest

    Default RE: Global Update for Invoice Numbers

    Al-
    Did go to Update to change the invoice numbers. I don't know which expression to use in A5 to automatically increment the invoice numbers. In A4, I was able to use system/grand + first invoice #.
    Thanks -Donna

  4. #4
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,625

    Default RE: Global Update for Invoice Numbers

    Donna

    To emulate the A4 routine, you'd use the total() function.

    Without understanding your id structure, I wonder why you don't use the field rule auto increment?

    Is this for assigning a value to a field that is used for linking tables together or just a field used to find by?

  5. #5
    Fancy Plants
    Guest

    Default RE: Global Update for Invoice Numbers

    Al -
    I finally figured out that the "update genie" has Assign Serial Values that did the trick. I thought the auto increment was for new records - we reuse the same records each month and update the date & invoice numbers.
    Thanks -Donna

  6. #6
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,625

    Default RE: Global Update for Invoice Numbers

    Donna

    If you're happy, I'm happy....

    Have a good day!

Similar Threads

  1. Invoice Line Numbers
    By alexmuir in forum Alpha Five Version 5
    Replies: 10
    Last Post: 05-22-2005, 11:30 PM
  2. Global Update
    By Steve Pick in forum Upgrading to Alpha Five from Alpha Four
    Replies: 3
    Last Post: 10-06-2003, 11:26 PM
  3. Update Inventory from Invoice
    By Vince Salzer in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 06-23-2000, 09:31 PM
  4. Invoice Page Numbers
    By Robert Brantley in forum Alpha Five Versions 2 and 3
    Replies: 0
    Last Post: 04-12-2000, 08:02 PM
  5. Invoice Page Numbers
    By Robert Brantley in forum Alpha Five Versions 2 and 3
    Replies: 0
    Last Post: 04-12-2000, 08:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •