Sage 100

Delete line Items from Receipt of Goods My client wants to scan incoming items in Receipt of Goods using a cheap wedge scanner. When you get to the lines tab, You are asked, ""Do you want to receive complete?"" The client says no and then begins scanning. Once the item is scanned, they type in the quantity. Rather than the scanned item number matching up with the inserted item number, another line is added. Now we have two lines with the same item number.- one with the received quantity typed in and the other with the default quantity of zero. Can we purge the line entries so we start with an empty Lines screen using scripting or does this have to be a code change. Or better yet, match up the scanned item with the one already there. Would doing this screw anything else up?

If this is Sage 100, you could invoke a button script that would prompt for scanner input then find and update the corresponding line. A few assumptions would need to be worked out for duplicate items and if the user inadvertently received the entire order. Support for Sage 100 advanced would be tricky since advanced scripting runs in the context of the server and an InputBox command would prompt at the server console. The alternative for Advanced could involve scanning into a UDF, but that's a bit clumsy. Perhaps @AlnoorCassim has an idea.

Hey Harold - Yes you could click on a button (script) that would remove the lines and refresh the grid and they scan afresh from there. For the better alternative I envision something like this: * Create a PO Rcpt Hdr UDF for Item No and UDF for Qty Rcvd but place on Lines tab somewhere off the grid area * Create a PO Rcpt Lines checkbox UDF called Rcvd and add to the grid. * Create a Customizer script button to the right of the 2 UDFs and set the tab sequence so button follows the UDF Qty Rcvd which follows the UDF Item No. * Scan into the UDF Item No then type in the Qty Rcvd. Press Enter twice. This should press the button for you. * Script fires off which scans all the lines for the same item. When found it will set the Qty Rcvd on that line, set the Rcvd checkbox, write the line, and refresh the grid. There would be rules for situations where the item wasn't found or if multiple instances of the item number is found.

Hey @DanBurleson - InputBox is a great idea! Hopefully like you mentioned it's MAS 90 not 200. For the UDF idea, I figured out how to make it not so clumsy.

@AlnoorCassim the clumsy part would seem to be the line focus. The Item and Qty UDF's could be on any row yet effect another row. Perhaps if one cleared the UDF's each time it might not be so clumsy.

@DanBurleson - What I did in a similar script was create Header UDFs but placed them on the Lines tab either on the toolbar row or the area to the right of the secondary grid. IOW it didn't live on the grid itself. I evaluated the UDFs and applied them to the lines and it worked out okay no clumsiness there but I did have issues. The GetValue's on the Hdr UDFs returned no value when they lived on the Lines panel. The workaround was to use .Execute's and .Evaluate commands. This way I could get the UDF control IDs first then get the value of the UDFs from there.

Excellant! Way to keep the clumsiness behind the curtain (Oz).

The customer has Sage 100 Standard and currently on Version 4.4