Sage 100

Does anyone have any thoughts or ideas on how to prevent Picking Sheets from being selected in picking sheet printing if the sales order has not been printed first?

Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
Birmingham, AL
------------------------------

What if you test for the SO Print checkbox that's on the SO Header?  Of course, that would have to be added to the worktable for the proper testing to be added to the form.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

1a. During S/O Printing, if M/D is an option, there's a nice hook in the post process routine when PrintSalesOrders sets to N and SalesOrderPrinted sets to  Y. You could create your own checkbox UDF called UDF_SOPrinted on SO Header. The MD routine would set UDF_SOPrinted = Y for you. Then in Pick Sheet printing you set UDF_SOPrinted = Y in the selection grid. 

1b. Another M/D option is to just add standard SalesOrderPrinted field to Selection grid and default it to Y. For that matter if it's a hard rule, then don't even add to Selection grid but rather override SO_PickingSheetPrinting_rpt.pvc program so it is part of the default selection.

2. There's no hook for scripting except 1 imperfect one if they don't mind quick printing the order:
* Create UDF_SOPrinted checkbox
* Create your own quick print scripted button so they can click on that. 

retVal = oBusObj.SetValue("UDF_SOPRINTED$", "Y")
oScript.InvokeButton("BT_QUICKPRINT")

But once it clicks the real Quick Print button for you, you will get a Do you want to save? with Yes / Cancel buttons for a new order and for existing order same prompt with Yes / No / Cancel buttons. If you always click Yes here, then this will work out. In Pick Sheet Printing, just set UDF_SOPrinted = Y on the grid and print. But if they ever click Cancel or No then it won't work out. Of course if they don't even Quick Print orders today (they use the menu), it won't work out at all. Not clean.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Original Message:
Sent: 08-28-2019 10:28
From: Michelle Taylor
Subject: Picking Sheet Printing

What if you test for the SO Print checkbox that's on the SO Header?  Of course, that would have to be added to the worktable for the proper testing to be added to the form.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Can't just use the Sage fields? Header Pre-Write script: If SalesOrderPrinted <> "Y" then set PrintPickingSheets >> "N".
Replace quick print PS button with a check on the SalesOrderPrinted flag before triggering the Sage button.

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

Original Message:
Sent: 09-02-2019 22:38
From: Alnoor Cassim
Subject: Picking Sheet Printing

2 things:

1. During S/O Printing, if M/D is an option, there's a nice hook in the post process routine when PrintSalesOrders sets to N and SalesOrderPrinted sets to  Y. You could create your own checkbox UDF called UDF_SOPrinted on SO Header. The MD routine would set UDF_SOPrinted = Y for you. Then in Pick Sheet printing you set UDF_SOPrinted = Y in the selection grid.

2. There's no hook for scripting except 1 imperfect one if they don't mind quick printing the order:
* Create UDF_SOPrinted checkbox
* Create your own quick print scripted button so they can click on that.

retVal = oBusObj.SetValue("UDF_SOPRINTED$", "Y")
oScript.InvokeButton("BT_QUICKPRINT")

But once it clicks the real Quick Print button for you, you will get a Do you want to save? with Yes / Cancel buttons for a new order and for existing order same prompt with Yes / No / Cancel buttons. If you always click Yes here, then this will work out. In Pick Sheet Printing, just set UDF_SOPrinted = Y on the grid and print. But if they ever click Cancel or No then it won't work out. Of course if they don't even Quick Print orders today (they use the menu), it won't work out at all. Not clean.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------


Original Message:
Sent: 08-28-2019 10:28
From: Michelle Taylor
Subject: Picking Sheet Printing

What if you test for the SO Print checkbox that's on the SO Header?  Of course, that would have to be added to the worktable for the proper testing to be added to the form.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Kevin - Great idea! But I *think* Michael was implying their process is to print Pick Sheets from the menu instead of the Print Pick (Sheet) button. Assuming I read that correctly, that's why the closest legal scripted soln I mentioned was a half-assed one where you quick print the order with a button script in between to set UDF_SOPrinted flag but Pick Sheets themselves would still be printed from the menu and use same UDF_SOPrinted from the selection grid.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Original Message:
Sent: 09-03-2019 13:30
From: Kevin Moyes
Subject: Picking Sheet Printing

Can't just use the Sage fields?

Header Pre-Write script: If SalesOrderPrinted <> "Y" then set PrintPickingSheets >> "N".
Replace quick print PS button with a check on the SalesOrderPrinted flag before triggering the Sage button.

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


Original Message:
Sent: 09-02-2019 22:38
From: Alnoor Cassim
Subject: Picking Sheet Printing

2 things:

1. During S/O Printing, if M/D is an option, there's a nice hook in the post process routine when PrintSalesOrders sets to N and SalesOrderPrinted sets to  Y. You could create your own checkbox UDF called UDF_SOPrinted on SO Header. The MD routine would set UDF_SOPrinted = Y for you. Then in Pick Sheet printing you set UDF_SOPrinted = Y in the selection grid.

2. There's no hook for scripting except 1 imperfect one if they don't mind quick printing the order:
* Create UDF_SOPrinted checkbox
* Create your own quick print scripted button so they can click on that.

retVal = oBusObj.SetValue("UDF_SOPRINTED$", "Y")
oScript.InvokeButton("BT_QUICKPRINT")

But once it clicks the real Quick Print button for you, you will get a Do you want to save? with Yes / Cancel buttons for a new order and for existing order same prompt with Yes / No / Cancel buttons. If you always click Yes here, then this will work out. In Pick Sheet Printing, just set UDF_SOPrinted = Y on the grid and print. But if they ever click Cancel or No then it won't work out. Of course if they don't even Quick Print orders today (they use the menu), it won't work out at all. Not clean.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA


Original Message:
Sent: 08-28-2019 10:28
From: Michelle Taylor
Subject: Picking Sheet Printing

What if you test for the SO Print checkbox that's on the SO Header?  Of course, that would have to be added to the worktable for the proper testing to be added to the form.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

(The button was just to close the logical loop).
The menu printing is what this script was intended to deal with... I missed the part where this needs to be set to "Y" when the SO has been printed: This won't work for the second print cycle for a BO though (unless you reset the two Printed flags when the last invoice # on the SO changes)... and whether the printing process will trigger the Pre-Write event is to be verified.
​

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

Original Message:
Sent: 09-07-2019 18:11
From: Alnoor Cassim
Subject: Picking Sheet Printing

Kevin - Great idea! But I *think* Michael was implying their process is to print Pick Sheets from the menu instead of the Print Pick (Sheet) button. Assuming I read that correctly, that's why the closest legal scripted soln I mentioned was a half-assed one where you quick print the order with a button script in between to set UDF_SOPrinted flag but Pick Sheets themselves would still be printed from the menu and use same UDF_SOPrinted from the selection grid.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------


Original Message:
Sent: 09-03-2019 13:30
From: Kevin Moyes
Subject: Picking Sheet Printing

Can't just use the Sage fields?

Header Pre-Write script: If SalesOrderPrinted <> "Y" then set PrintPickingSheets >> "N".
Replace quick print PS button with a check on the SalesOrderPrinted flag before triggering the Sage button.

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


Original Message:
Sent: 09-02-2019 22:38
From: Alnoor Cassim
Subject: Picking Sheet Printing

2 things:

1. During S/O Printing, if M/D is an option, there's a nice hook in the post process routine when PrintSalesOrders sets to N and SalesOrderPrinted sets to  Y. You could create your own checkbox UDF called UDF_SOPrinted on SO Header. The MD routine would set UDF_SOPrinted = Y for you. Then in Pick Sheet printing you set UDF_SOPrinted = Y in the selection grid.

2. There's no hook for scripting except 1 imperfect one if they don't mind quick printing the order:
* Create UDF_SOPrinted checkbox
* Create your own quick print scripted button so they can click on that.

retVal = oBusObj.SetValue("UDF_SOPRINTED$", "Y")
oScript.InvokeButton("BT_QUICKPRINT")

But once it clicks the real Quick Print button for you, you will get a Do you want to save? with Yes / Cancel buttons for a new order and for existing order same prompt with Yes / No / Cancel buttons. If you always click Yes here, then this will work out. In Pick Sheet Printing, just set UDF_SOPrinted = Y on the grid and print. But if they ever click Cancel or No then it won't work out. Of course if they don't even Quick Print orders today (they use the menu), it won't work out at all. Not clean.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA


Original Message:
Sent: 08-28-2019 10:28
From: Michelle Taylor
Subject: Picking Sheet Printing

What if you test for the SO Print checkbox that's on the SO Header?  Of course, that would have to be added to the worktable for the proper testing to be added to the form.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772