Sage 300

 View Only
  • 1.  Hi All,Working away this afternoon trying to cap

    Posted 05-01-2015 13:15
    Hi All, Working away this afternoon trying to capture the credit check button press on the order entry screen(OE1100). Here is a little backstory - Just in case any of you are using Avatax with Sage 300 and order entry, there is a bug where the credit check doesn't automatically fire like it should (if its configured to do so in A/R for the customer) when you post an O/E Order. You can manually click the button before posting and it works, but the embedded process with the post button somehow gets cancelled by Avatax. They are aware of the problem and are working on a fix. In the mean time I thought i'd go about programically clicking the button with a vba form addition in the usual fashion like this: Private sub Post_Click() Me.AccpacOE1100UICtrl1.UIAppControls(""APP_authorization_Button"").MacroEnabledFlag = False Me.AccpacOE1100UICtrl1.UIAppControls(""APP_authorization_Button"").Value = 1 ........ {other post code here} end sub Hmm - this doesn't fire off the credit check UI. If you substitute APP_Prepayment_Button in the above code, it fires the prepayment UI. I found an old post from 2010 by Stephen (https://smist08.wordpress.com/2010/11/07/entering-orders-and-headerdetail-views/) regarding using something like this: OEORD1headerFields(""GOCHKCRDT"").Value = ""1"" ' Perform Credit Limit Check OEORD1header.Process Cant seem to get that to do the credit check either. Anyone have a snippet that will do this properly or other idea on how to fire this event? Thank you! Marc


  • 2.  RE: Hi All,Working away this afternoon trying to cap

    Posted 05-01-2015 13:21
    Try recording a macro (since clicking the UI works)??


  • 3.  RE: Hi All,Working away this afternoon trying to cap

    Posted 05-01-2015 14:05
    Hi Phil - Thank you for the idea. Tried recording a macro. Running the recorded macro doesn't launch the screen either. Shucks! I went through the UI Info tool and there doesn't seem to be a UI that I can load either as none of the o/e forms were the credit checker. Strange. Might just have to wait on it or cancel the posting via vba if a manual code check of credit limit fails. Thanks, m