Sage 100

 View Only
  • 1.  Button for reversing General Journal entries from

    Posted 09-09-2011 15:48
      |   view attached
    Button for reversing General Journal entries from Journal drill down. I found a script from one of the old Summits and I am attempting to use it. it works fine but not with batches enabled. Has anyone gotten it to work with GL journal batches enabled? it get an error that it can't find a record in the GL Journal Detail. Add a button to the Journal drill down and attach this script. Rename to .VBS to run.

    Attachment(s)

    txt
    BT_reverseGL.vbs.txt   2 KB 1 version


  • 2.  RE: Button for reversing General Journal entries from

    Posted 09-10-2011 08:02
    It doesn't work with batches because it was never scripted that way. You would have to add the command to either start a new batch or write to an existing batch. My guess is, to be consistent, you'd want it to write a new batch each time, because otherwise how would you know what batch to add it to, programmatically?


  • 3.  RE: Button for reversing General Journal entries from

    Posted 09-10-2011 10:19
    Do you have the line of code for that?


  • 4.  RE: Button for reversing General Journal entries from

    Posted 09-12-2011 06:42
    retVal = object.SelectNewBatch(batch, ""N"", Comment) Where object is the object you are referencing, comment is a variable containing the comment you want on the batch. If you leave ""batch"" as an empty string it creates a new batch, if you have it populated with a value it uses that batch number.


  • 5.  RE: Button for reversing General Journal entries from

    Posted 09-12-2011 09:46
    Is any one an early adopter of V4.5? This script is working in v4.4 but blows an error in v4.5. See the attached files. Just wondering if I should notify Sage or not.


  • 6.  RE: Button for reversing General Journal entries from

    Posted 09-12-2011 11:53
    Found the problem. Needs to have allow external access activated.


  • 7.  RE: Button for reversing General Journal entries from

    Posted 09-12-2011 12:27
    That is a common issue. I had that too. :)