Scripting

  • 1.  I have a customer interested in a control over the

    Posted 05-15-2017 10:23
    I have a customer interested in a control over the volume of new sales orders that can be shipped on a single day. They would like Sage 100 (Advanced 2016) to prevent an order from being assigned to a ship date (header, not lines) that has already reached a total of $xxxxx for that day. If the limit has been reached for that shipment date, the system would return a message and require another date be selected. If that next date also had reached its limit, then the message would be received again and they would be prevented from moving ahead until an available date has been reached. In addition, though this is where I am wondering if actual modification would be required, an override password could be entered to allow the date to be accepted that would otherwise be disallowed. Scripting is not my forte', so thoughts and interest in the project invited.


  • 2.  RE: I have a customer interested in a control over the

    Posted 05-15-2017 11:04
    InputBoxes to enter passwords would be tricky (there's no direct input, so I end up using screen UDFs), but you could do a custom button on a messagebox that only appears for special users (""Override""). You'd have to nail down what exactly is included in the gross total and how you'd want to handle shipments that are accepted and then later modified, but it all sounds do-able. Depending on the urgency, I could assist.


  • 3.  RE: I have a customer interested in a control over the

    Posted 05-15-2017 12:11
    Thank you for your quick reply and the information, very much appreciated. After drilling further into the number of open orders and learning that they import a significant volume from 2 key trade shows, we have decided it would really be better served by doing a providex customization. Thanks again, Cheri


  • 4.  RE: I have a customer interested in a control over the

    Posted 05-15-2017 12:16
    No worries. Just for future reference, scripts can be configured to only work in the Entry screens and ignore V/I, but pvx is a better fit anyway.


  • 5.  RE: I have a customer interested in a control over the

    Posted 05-15-2017 13:24
    I am curious what part of your requirement you found could not be handled by scripting. I agree with Steve, you may be able to significantly benefit from less upfront development cost and future complex upgrade coordination between a 3rd party developer & Sage.