Sage 100

 View Only
  • 1.  Is there a way to turn off Sales Order lines recal

    Posted 03-02-2015 14:54
    Is there a way to turn off Sales Order lines recalculating Bill of Materiel Items with options? For example, if a client enters a bill, and manually overrides the price, then selects options (all of which are set to $0) after accepting said options, the price will default back to the original bill price. Before I dive into storage vars with scripting, figured I should see if there is just a check-box somewhere that I am missing.


  • 2.  RE: Is there a way to turn off Sales Order lines recal

    Posted 03-03-2015 09:02
    Michelle, I couldn't find that ""magic"" check-box either, unfortunately. I looked into the Providex code for you and was able to trace it. The price recalculation occurs after the OK button is clicked in B/M Options Maintenance. At this point, it's using the original unit price as the base price before adding any options pricing, if any. Even the PriceOverridden field is still set to No when it should be Yes. I can't determine if this is a bug or a design issue. Knowing what I know about scripting, I'm not sure where to insert it in the right place to make it work. I'm more than happy to explore it in more in depth if you want me to if overriding the price after the options have been entered is not a viable option for the client.


  • 3.  RE: Is there a way to turn off Sales Order lines recal

    Posted 03-03-2015 10:23
    Thanks, I appreciate that! I am thinking if I just have a script fire off to set a Storage Var when the Unit Price is overridden initially, when the write lines happens (after the recalculation) I can have it compare the value in the storage var to the recalculated Unit Price and if it doesn't match then have it reset the value/prompt to set the price with the stored Var. Thoughts? @AlnoorCassim or @MarcosDeLuna @Sage100AdvancedScripting


  • 4.  RE: Is there a way to turn off Sales Order lines recal

    Posted 03-03-2015 11:32
    It might work. Make sure the Total Amount at the bottom the Lines tab reflects the override price instead of the original unit price. after you reset the value in your script.


  • 5.  RE: Is there a way to turn off Sales Order lines recal

    Posted 03-03-2015 12:12
    My thought is listen to Marcos :)


  • 6.  RE: Is there a way to turn off Sales Order lines recal

    Posted 03-03-2015 12:38
    Thanks Guys, I probably would have overlooked that. If they decide to move forward I will report back with results.