Macro to print SOP Blank Packing list not working

  • Macro to print SOP Blank Packing list not working

    Posted by Jeff Roe on February 28, 2018 at 6:27 pm
    • Jeff Roe

      Member

      February 28, 2018 at 6:27 PM

      I have created a macro that is supposed to print 2 copies of a Sales Transaction Packing list using the SOP Blank Packing List.

      When it runs it is only printing 1 copy and is using the Long Form instead of the Blank Form

      Here is the piece of the macro that I’m using.Ā  Ideas?

      # DEXVERSION=14.00.0085.000 2 2
      CommandExec dictionary ‘default’ form ‘Command_Sales’ command ‘SOP_Batch_Entry’
      NewActiveWin dictionary ‘default’ form ‘SOP_Batch_Entry’ window ‘SOP_Batch_Entry’
      TypeTo field ‘Batch Number’ , ‘DCPRINT’
      MoveTo field Origin item 0
      ClickHit field Origin item 1 # ‘Sales Transaction Entry’
      CommandExec dictionary ‘default’ form ‘SOP_Batch_Entry’ command ‘WindowPrint_w_SOP_Batch_Entry_f_SOP_Batch_Entry’
      NewActiveWin dictionary ‘default’ form ‘SOP_Print_Options’ window ‘SOP_Print_Options’
      MoveTo field ‘(L) Print Packing Slip CB’ # ‘FALSE’
      ClickHit field ‘(L) Print Packing Slip CB’ # ‘TRUE’
      MoveTo field ‘(L) Include PS Line Comments CB’ # ‘FALSE’
      ClickHit field ‘(L) Include PS Line Comments CB’ # ‘TRUE’
      CommandExec dictionary ‘default’ form ‘SOP_Print_Options’ command ‘Print Button NONE_w_SOP_Print_Options_f_SOP_Print_Options’
      NewActiveWin dictionary ‘default’ form ‘Report_Destination’ window ‘Report_Destination’
      MoveTo field ‘OK Button’
      ClickHit field ‘OK Button’
      NewActiveWin dictionary ‘default’ form ‘SOP_Print_Options’ window ‘SOP_Print_Options’
      NewActiveWin dictionary ‘default’ form ‘Report_Destination’ window ‘Report_Destination’
      MoveTo field ‘Cancel Button’
      ClickHit field ‘Cancel Button’
      NewActiveWin dictionary ‘default’ form ‘SOP_Print_Options’ window ‘SOP_Print_Options’
      NewActiveWin dictionary ‘default’ form ‘SOP_Batch_Entry’ window ‘SOP_Batch_Entry’
      PrintDialog copies 2 hori_adj 0 vert_adj 0 printer ‘\CCI2K12DCFILESShipping – LaserJet’
      # Print To Printer: ‘SOP Blank Packing Slip Form’
      CloseWindow dictionary ‘default’ form ‘SOP_Batch_Entry’ window ‘SOP_Batch_Entry’
      NewActiveWin dictionary ‘default’ form sheLL window sheLL

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————

    • Ken Roy

      Member

      February 28, 2018 at 6:36 PM

      Hi Jeff,

      I don’t have an answer for your macro but do have a questions?Ā  Ā 

      Is a macro the only way to get two copies of the Packing List to print?Ā  I’m trying to test this myself.Ā Ā 

      Thanks,

      Ken

      ——————————
      Ken Roy
      Premier Manufacturing
      Tualatin OR
      ——————————
      ——————————————-

    • Beat Bucher

      Member

      March 1, 2018 at 9:15 AM

      Hi
      Have you tried to use ‘named printers’ ? that would allow you to pre-define 2 pages for a specific queue and also select specific paper tray, without having to open the printer config every time.??

      ——————————
      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      @GP_Beat http://dyngpbeat.wordpress.com/
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14
      ——————————
      ——————————————-

    • Jeff Roe

      Member

      March 1, 2018 at 9:32 AM

      The bigger issue is not the printer but the form it is printing.

      I want it to print the Packing list with the Blank Paper form but it always prints the Long Form (the default form)

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————
      ——————————————-

    • Thaddeus Suter

      Member

      March 1, 2018 at 9:39 AM

      For two copies of the pack slip to print maybe use this:

      ——————————
      Thaddeus Suter
      Retus, Inc
      HELOTES TX
      ——————————
      ——————————————-

    • Jeff Roe

      Member

      March 1, 2018 at 10:10 AM

      Where would i find the Quick Print setup (I’m using GP2015 R2)?

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————
      ——————————————-

    • Tim Andaya

      Member

      March 1, 2018 at 2:02 PM

      Hi Jeff,

      Sales Transaction Entry –> Options –> Quick Print Setup

      Regards,

      ——————————
      Tim Andaya
      Strategic Systems Group
      “There are no stupid questions.”
      ——————————
      ——————————————-

    • Jeff Roe

      Member

      March 1, 2018 at 2:25 PM

      Thanks

      Unfortunately we are printing at the Transaction Sales Batch level not individual transactions so Quick Print is not viable at this time.

      Good to know anyway on the Quick Print if needed

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————
      ——————————————-

    • Thaddeus Suter

      Member

      March 1, 2018 at 7:13 PM

      For order/transaction printing use Quick Print Setups.
      For Batch Printing use Named printers.
      Both were written by
      Maybe he can help you

      Out of curiosity, who is your VAR anyway???

      ——————————
      Thaddeus Suter
      Retus, Inc
      HELOTES TX
      ——————————
      ——————————————-

    • David Musgrave

      Member

      March 1, 2018 at 7:18 PM

      Hi Guys

      Thanks Thaddeus for the mention.

      The issue with multiple copies can be caused by the printer driver. Some printer drivers will only print one copy even when requested to print more than one.

      I would suggest trying a different version of the printer driver. Such as the Microsoft supplied one instead of the manufacturer supplied one (or vice versa).??

      Definitely use Named Printers and the SOP Quick Print functionality as this will allow you to control what prints where with a single keypress and can bring the document back after printing.

      David
      Original developer of Named Printers and SOP Quick Print. šŸ™‚

      ——————————
      David Musgrave MVP, GPUG All-Star

      Managing Director
      Winthrop Development Consultants

      Perth, Western Australia

      http://www.winthropdc.com
      ——————————
      ——————————————-

    • Jeff Roe

      Member

      March 2, 2018 at 7:33 PM

      I actually got it to work.

      My biggest challenge is that I have two different batch names that i needed to print packing lists for but each batch goes to a different printer.

      What i ended up doing is
      1. Made the default form set to Blank Paper
      2. Set the printer settings to always print two copies
      3. Was then able to use the macro format that i originally posted

      The problem with the macro not working the way I thought was less about the printer itself. The macro would not change the form type (at the time the default was Long Form) so changing to Blank Paper corrected the form issue. Next the macro apparently would not actually send the 2 copies command to the printer (even though it was part of the printer string) but setting the copies on the printer settings itself resolved the issue.

      Long way around the problem but all is working as needed and as always the feedback from the GPUG community is tremendous.

      We are using Tribridge but I never approached them with this issue.

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————
      ——————————————-

    Jeff Roe replied 7 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Macro to print SOP Blank Packing list not working’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!