Full Rollback in Batch Posting

navuser1
navuser1 Member Posts: 1,334
edited 2024-12-30 in NAV Three Tier
Hello,

There is scenario where I make two sales orders during a process, and I have to post them right away. If the system fails to post any of them under any circumstances, I would like it to roll back entirely.

How can I use the Business Central platform (AL Code) to accomplish this?

Please share your knowledge about it.

Kindly, ignore this topic if you have already gone through the same question in the Dynamics 365 Community forum.

Regards,
SB
Now or Never

Answers

  • Developer101
    Developer101 Member Posts: 569
    I have seen it on Dynamics 365 Community Forum as well. So have you found a solution for it?
    United Kingdom
  • navuser1
    navuser1 Member Posts: 1,334
    So far, I have not found any solution.
    Now or Never
  • JJMc
    JJMc Member Posts: 63
    When you call to the posting codeunit to achieve this, you have then posibility of passing a "SuppressCommit" parameter to avoid commit for each recor you pass, and commited at the end.

    This way if any error occurs during the hole process, the rollback do not create, modify, delete, any registers in the database
  • navuser1
    navuser1 Member Posts: 1,334
    edited 2024-12-31
    Exactly the same approach I have already implemented.

    wbq63wn55xu8.png
    Now or Never
  • Developer101
    Developer101 Member Posts: 569
    > @navuser1 said:
    > Exactly the same approach I have already implemented.
    Has this worked?
    United Kingdom
  • txeriff
    txeriff Member Posts: 515
    By Standard the posting routine will commit, I didn't know MS introduced SetSupressCommit function, in the old days we used a blank error to prevent the commit in the code (Error(''))

    My understanding is you have some piece of code (bespoke) that fails sometimes but the document has already been posted. I would review if you have your piece of code in the right place as it should happen before any commits, it would rollback by default.
  • vaprog
    vaprog Member Posts: 1,162
    SetSupressCommit only supresses any explicit call to Commit during the execution of the Codeunit. This allows you to include more database changes into the same transaction such as updating bookkeeping daten related to some interface to an external system. As such it is very different from Error('')
  • navuser1
    navuser1 Member Posts: 1,334
    @Developer101
    It seems working fine
    Now or Never

Categories