when bank transaction type is not populated in the bank reconciliation worksheet, under open document i am able to populate it in the AOT in the BANKACCOUNTTRANS table. Today i am having an issue where i need to edit an already populated bank transaction type. when i edit in AOT, it is not updating in the front end. can anyone help?
*This post is locked for comments
Rigth click in the table and select Synchronize.
By your information, you cant change the data like this, if you want to update some table use the update statement.
please create a job in the AOT, and add the code there.
Example:
static void AM_UpdateProcessBatchFlag(Args _args)
{
SemSCIWorkBenchData benchdata;
;
ttsBegin;
while select forupdate benchdata
where benchdata.semtransbatchid == '26' &&
benchdata.Status == SemSCIProcessStatus::Processed &&
benchdata.TransactionType == 'D_MIG_VEND'
{
benchdata.Status = SemSCIProcessStatus::NotProcessed;
benchdata.doUpdate();
}
ttsCommit;
}
never do directly in the table.
no. how do i do that?
After the updated, did you synchronize the table?
there is no error when i update in AOT but the update does not reflect in the front end.
Are you updating the table without any error?
#1
André Arnaud de Cal...
293,238
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
