Sage 100

 View Only

  • 1.  Multi Part printing issue with printer options

    Posted 10-07-2021 12:12

    Hi All,
      I am not sure there is a way to resolve this issue but maybe someone has found a way. 
      Have a client that went from 3.71 to 2016.  Previously they printed to two part dot matrix forms, the second copy has a hash grid so that pricing cannot be seen on the second page..  They got NCR paper and a printer with a stapler.  Configured the form to suppress pricing based on the shadow copy text.  That works great BUT the printer "sees" them has separate prints and does not staple them together.  If the form is printed not using multipart and setting it to 2 pages, it staples but shows pricing on the second page.
       I tried creating a form that automatically prints two copies of the form using sub reports.  It works IF the order is only one page long.  If not the printing order is wrong (all of the first copy, then all of the second copy..  So close)

       I am tending to thing that the only solution is to have the second page of NCR paper printed with the grid hashes.    

    Anyone have any further thoughts/Ideas?

    Thanks in advance!



    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Multi Part printing issue with printer options

    Posted 10-07-2021 13:08
    Sorry, no answer to the printer technical question but this might be an opportunity change their printing process.  A lot of things have changed since the v3.71 go go years so there might be a different way of making the process more efficient for them.  What do they do with the two sheets of paper?  Are they still necessary or is it the way they have always done it. I assume this is a picking/shipping issue.  Are they using the shipping module?  Is the second sheet a packing list?  If you can determine the why of the 10+ year old process, maybe you can eliminate it using the newer Sage tools.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Multi Part printing issue with printer options

    Posted 10-07-2021 18:05

    Hi Jeff,

       They send both copies to the warehouse and they write on them how many were actually shipped and use one as a packing slip, the other goes to the office for invoicing.  That is why they want them stapled together.  Thinking the only solution is to get the hash grid on the second sheet of paper...

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     




    Original Message


  • 4.  RE: Multi Part printing issue with printer options

    Posted 10-07-2021 19:05
    Or convince them that the future is to enable shipping data entry, print a picking sheet with a bar coded SO number (on the shipping department printer) so it can be scanned into Sage, enter shipped quantities, print a packing list.  Using shipping data entry, they can scan the tracking number into Sage.  People hate to change their tried and true methods for something more efficient and faster.  I know, I still have clients operating foolishly in the 80's and just won't change.  I am surprised your client gave up the dot matrix.....

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 5.  RE: Multi Part printing issue with printer options

    Posted 10-08-2021 02:29
    I am backing Jeff on this one.  There are many changes and for the better,  You have sell it to your clients.  There is the picking list after a sales order and then a packing list by going thru shipping data entry.  Multi-Print is pretty much obsolete.

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


  • 6.  RE: Multi Part printing issue with printer options

    Posted 10-08-2021 09:25
      |   view attached

    Bob,

    There is a lot of validity to asking the user to rethink their processes when upgrading from a version of Sage the is about 20 years old. Everything is going to be different and now is a good time to assess all your process and blame the new software for things you have always wanted to change in your company.

    But if you have not thrown in the towel just yet; I think I have a way to do this, Although I'm not sure how their printer will see documents. I got it to print two copies with the second copy suppressing the price information.

    Attached is the Sage 100 standard Sales order with some slight modifications.

    Here is what I did:

    • Created a User Defined Table called PRINT_TWO (SO_UDT_PRINT_TWO)
      • UDT has only one field – type "string"
      • Added two records to that UDT
        • ONE
        • TWO
      • I Added this table to the standard Sales order form in designer and linked on sales order number to that field with a NOT-Equal join
      • I created an new grouping on the sales order and grouped on the field "UDF_PRINT_TWO_CODE" from the UDF
      • I made that Group #2 in the crystal form and suppressed that section
    • I then added suppression logic to the unit price and extended price fields so they would suppress if UDF_PRINT_TWO_CODE}="TWO"

    I made an order that was two pages long to make sure it would print the order twice with the pages in the correct order and it seems to work. I also printed multiple orders and that seems to work too.

    I do see at least one more thing that needs to be done.  Getting the totals to print at the bottom of the first copy instead of the second copy.  I didn't tackle that but it should be possible.  Or, if the second copy of the order could be the one that has prices and totals all you would have to do is change the suppression logic on the price fields to UDF_PRINT_TWO_CODE}="ONE" then the first copy would not have prices and the second copy would have prices. 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------

    Attachment(s)

    RPT
    SO_SalesOrder2.RPT   27 KB 1 version
    Original Message


  • 7.  RE: Multi Part printing issue with printer options

    Posted 10-12-2021 16:05

    HI All,
      I understand the idea of rethinking processes but I am dealing with a client that took 15 years to get to the point of thinking that an upgrade might be a good idea.  They are now just getting "use to" printing checks for goodness sake...   Change does not come easy here and they are very busy at this point.  I would LOVE  if they did shipping data entry but at this point the warehouse does not even have computers and they are manually write in the quantity shipped on the paperwork - one copy used as a packing slip, the other to the office for invoicing (this is the need for the pricing to be blanked out).   
       David's idea is VERY interesting but will have to play with it to see if it will work.  The trickiest part is that the pages cannot be collated.  Page 2 of the second print has to be stapled to page 2 of the first print and have to see if can work this way..  They have a lot of volume (they drop ship for Amazon and Bed, Bath and Beyond) so having someone do this manually is a big ask.
       Thanks all!   



    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------

    Original Message


Related Content