Sage 100

 View Only
  • 1.  I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 07:09
    I need to print 1000 invoices. I can have the INVNO in a csv file. How can I print them at once without printing them individually?


  • 2.  RE: I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 07:21
    Maybe Use ar invoice history printing.


  • 3.  RE: I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 07:28
    Yes, I plan to use invoice history printing but these invoices are not consecutive. They have a criteria that I need to extract in Crystal and then save those inv numbers in a csv and somehow be able to print those invoices


  • 4.  RE: I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 07:29
    I assume those invoices are in Invoice History. Therefore you could copy/paste your invoice #'s (from your .csv) into the Invoice Number field on the Invoice History Printing screen, i.e., use ""Equal to"" and separate the values by comma's, no spaces (e.g., 0032987,0033001,0033061). Chances are you can't do all 1,000 at once but you should at least be able to chunk it down into a reasonable amount of groupings.


  • 5.  RE: I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 07:30
    Also, for reference: http://community.90minds.com/2009/06/17/mas-90-and-mas-200-onesy-twosy-report-selection-criteria/


  • 6.  RE: I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 07:50
    Thanks I was hoping for an easier way but perhaps this is it. It will be a long process


  • 7.  RE: I need to print 1000 invoices. I can have the INVN

    Posted 08-19-2015 08:02
    Create a UDT table and add these uninque invoices in there. then create a new crystal report that looks like the invoice. This is not too hard - I had to do for Knowledgesync a couple of months ago. Link in the ARInvHistHeader, detail, terms, maybe extended description and then this UDT table. If this is a lot of data put it in SQL or maybe access and it should render quickly. Or better yet - maybe try and print ALL the invoices in invoice history and have a special form that links in the UDT table - the work table will have all the invoices in your range (smallest invoice # to largest Invoice #) but linking in the UDT will force crystal to just display the unique ones in the UDT) I would try this last suggestion first!