Sage 100

 View Only
  • 1.  Updating AR Repetitive Invoice Entry

    Posted 12-10-2025 14:48

    End user has 15 Sage 100 companies.  Depending on the company they have between 300 and 800 repetitive invoices they use to create AR customer invoices for each company.  They use Miscellaneous Items not "regular" inventory items.  If they have a price increase for the 50 Misc items, what's the most efficient way to update the items in Repetitive Invoice Entry?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Updating AR Repetitive Invoice Entry

    Posted 12-10-2025 14:50

    You can export and import, as long as you include the LineKey in both



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------



  • 3.  RE: Updating AR Repetitive Invoice Entry

    Posted 12-10-2025 14:52

    Thanks Beth.  Oh well.  I was hoping there  a magic "Update Repetitive Invoices" button in Misc Item Maintenance.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Updating AR Repetitive Invoice Entry

    Posted 12-10-2025 14:54

    A button script might be able to do that... loop through the header table, go through lines, and update the amount if the line item matches, save, next...



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



  • 5.  RE: Updating AR Repetitive Invoice Entry

    Posted 12-10-2025 14:56

    That's a good idea also @Kevin Moyes.  i have a few good options to present to the end user.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------