I use setobjectvalue command to set an infomation to a posted batch but I don't known how to save it properly.
Please help me !.
Thanks all
*This post is locked for comments
Which screen are you customizing?
Which Control?
Which Event is your code in?
Barry
Hi Barry,
I customize voucher and adjustment entry 03.010.00. I want create a button in that screeen to update some information in posted batch. Because sometime users do a wrong batch and I want to mark that batch.
03.010 shows Released/Posted batches in "enquiry mode" - it shows you the documents/transactions, but you can't change them.
This is intentional - when an AP Voucher batch is Released, a lot of tables have been updated. To change any financial information would risk introducing integrity errors.
What field do you want to change?
I want to change only user06 field of batch table. I pull that batch and press customize button, the field user06 will be update a character that I want.
I think your using the wrong command in adding information to an active_status_batch. In my own analyze, the set_object_value command refer to MS Visual Studio C++ library, where each object implanted thru an IDE has specific attributed values. Usually, your local network administrator should be able to first, find the referenced ID of your batch and second, should be able to take intern measures for modifing a script no matter where the batch is in the workflow. In an usual way, modification of script between steps of worflow syncings should not especially require a function of saving or not your modification because it can be done over a unique process and modification of elements while batches are in workflow invoked databases modifications with an automatic recording for modifications done to it.
One possibility is to use the "SQL" call to update the batch table.
The SQL you use will probably look something like "update batch set user6 = 'ABC' where BatNbr = 'whatever' and Module = 'AP'
You can then use "Call SQL" to execute your sql.
Make sure you include "and Module = 'AP'" in your SQL - it is legal to have the same batch numbers in different modules.
You will want to update only the AP one.
Obviously your code needs to know the batch number - you will probably want to use GetObjectValue to uplift it.
And possibly also do a GetObjectValue to uplift the batch Status, and check it out.
If the Status is U or P, then 03.010 is not likely to be updating the Batch table itself, and it all sounds good.
But if the Status is anything else, 03.010 may subsequently update the batch table.
If your code has already done that, you are likely to get an "another process has updated the batch record" error.
Hope that helps.
It's work, thanks Barry
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
