Sage 100

Anyone know of a way, either through scripting or hopefully just a simple setting, that would prevent the pop-up message, "Do you want to to receive the complete purchase order?"  @Eric Anderson posted a similar question a while back for the Sales Order version of this feature, but I hadn't seen much chatter about this other than a really old post on SageCity, which basically said to just fire the person hitting "yes." :)

Or possibly use BOI.

------------------------------
Rob Neal
ServiceWorld Business Solutions
------------------------------

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Thanks @David Speck II​...exactly what I was looking for (literally) but couldn't find.

------------------------------
Rob Neal
------------------------------

Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

David,

Nicely done on your script.

------------------------------
Marcos DeLuna
Deluna Consulting
------------------------------

Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

@David Speck II, thanks again for the help on this one.  One additional thing that came up is that when the script is running, the users are unable to set a default warehouse.  As soon as you select (or type) one in the header warehouse field, it disappears.  Any thoughts?   ​

------------------------------
Rob Neal
------------------------------

Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Which event (and field) are you assigning the script to?
If you have this on the post validate of the PO number, then it sounds like sage's own post validation on the PO number field and subsequent logic is not processing, essentially not copying the PO's header data, is that what you are seeing?
In the original post, the script was on the post validate of the invoice number so sage's logic on the PO number field would have fired already.
If this is the case, you can try adding retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0) line.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 02-26-2020 14:47
From: Rob Neal
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

@David Speck II, thanks again for the help on this one.  One additional thing that came up is that when the script is running, the users are unable to set a default warehouse.  As soon as you select (or type) one in the header warehouse field, it disappears.  Any thoughts?   ​

------------------------------
Rob Neal
------------------------------


Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions

Validating on PurchaseOrderNo.  I added retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0), but result was the same, so I removed it.  I noticed, though, that all other header fields were retained, like the ShipTo and even the Comment.  I finally realized the pattern was when the PO was made up entirely of Miscellaneous Items.  If even one regular item was on a line, the warehouse field on the header is retained.  The even stranger thing was that user's inability to change the warehouse on the header.   It doesn't behave that way for my logon.  Thanks again for the help!

------------------------------
Rob Neal
------------------------------

Original Message:
Sent: 02-26-2020 18:40
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

Which event (and field) are you assigning the script to?
If you have this on the post validate of the PO number, then it sounds like sage's own post validation on the PO number field and subsequent logic is not processing, essentially not copying the PO's header data, is that what you are seeing?
In the original post, the script was on the post validate of the invoice number so sage's logic on the PO number field would have fired already.
If this is the case, you can try adding retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0) line.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 02-26-2020 14:47
From: Rob Neal
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

@David Speck II, thanks again for the help on this one.  One additional thing that came up is that when the script is running, the users are unable to set a default warehouse.  As soon as you select (or type) one in the header warehouse field, it disappears.  Any thoughts?   ​

------------------------------
Rob Neal


Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions

Glad you figured it out and thanks for posting what you discovered, can't say i have ever encountered that behavior but i also never intentionally tried to receive a PO that didn't have any standard inventory items on it.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 02-26-2020 19:19
From: Rob Neal
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

Validating on PurchaseOrderNo.  I added retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0), but result was the same, so I removed it.  I noticed, though, that all other header fields were retained, like the ShipTo and even the Comment.  I finally realized the pattern was when the PO was made up entirely of Miscellaneous Items.  If even one regular item was on a line, the warehouse field on the header is retained.  The even stranger thing was that user's inability to change the warehouse on the header.   It doesn't behave that way for my logon.  Thanks again for the help!

------------------------------
Rob Neal
------------------------------


Original Message:
Sent: 02-26-2020 18:40
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

Which event (and field) are you assigning the script to?
If you have this on the post validate of the PO number, then it sounds like sage's own post validation on the PO number field and subsequent logic is not processing, essentially not copying the PO's header data, is that what you are seeing?
In the original post, the script was on the post validate of the invoice number so sage's logic on the PO number field would have fired already.
If this is the case, you can try adding retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0) line.

------------------------------
David Speck II
Tennessee Software Solutions


Original Message:
Sent: 02-26-2020 14:47
From: Rob Neal
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

@David Speck II, thanks again for the help on this one.  One additional thing that came up is that when the script is running, the users are unable to set a default warehouse.  As soon as you select (or type) one in the header warehouse field, it disappears.  Any thoughts?   ​

------------------------------
Rob Neal


Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions

Just had the warehouse issue pop up when a PO with only misc items was received. It appears to be due to the fact that the field on the panel for the warehouse code is called ML_WarehouseCode and/or a timing issue. I was able to resolve this by using the following code instead of oBusObj.CopyPurchaseOrderLines(0).
If oScript.UIObj > 0 Then oSession.AsObject(oScript.UIObj).SetVar "CMD_STR$", "X coBusiness'CopyPurchaseOrderLines(0)" End If ​

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 02-26-2020 23:49
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

Glad you figured it out and thanks for posting what you discovered, can't say i have ever encountered that behavior but i also never intentionally tried to receive a PO that didn't have any standard inventory items on it.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 02-26-2020 19:19
From: Rob Neal
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

Validating on PurchaseOrderNo.  I added retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0), but result was the same, so I removed it.  I noticed, though, that all other header fields were retained, like the ShipTo and even the Comment.  I finally realized the pattern was when the PO was made up entirely of Miscellaneous Items.  If even one regular item was on a line, the warehouse field on the header is retained.  The even stranger thing was that user's inability to change the warehouse on the header.   It doesn't behave that way for my logon.  Thanks again for the help!

------------------------------
Rob Neal


Original Message:
Sent: 02-26-2020 18:40
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

Which event (and field) are you assigning the script to?
If you have this on the post validate of the PO number, then it sounds like sage's own post validation on the PO number field and subsequent logic is not processing, essentially not copying the PO's header data, is that what you are seeing?
In the original post, the script was on the post validate of the invoice number so sage's logic on the PO number field would have fired already.
If this is the case, you can try adding retval = oBusObj.CopyFromPurchaseOrder(sCurrentPO) before the retval = oBusObj.CopyPurchaseOrderLines(0) line.

------------------------------
David Speck II
Tennessee Software Solutions


Original Message:
Sent: 02-26-2020 14:47
From: Rob Neal
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

@David Speck II, thanks again for the help on this one.  One additional thing that came up is that when the script is running, the users are unable to set a default warehouse.  As soon as you select (or type) one in the header warehouse field, it disappears.  Any thoughts?   ​

------------------------------
Rob Neal


Original Message:
Sent: 02-07-2020 02:59
From: David Speck II
Subject: Block Pop-Up in Receipt of Goods to receive complete PO

You should be able to adapt my solution to this post to fit your needs.
https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/100804/po-roi-script-to-default-no-on-lines-question-to-invoice-complete/282028#282028

------------------------------
David Speck II
Tennessee Software Solutions