RollBack Sales Order

NavDave
NavDave Member Posts: 13
edited 2013-01-18 in NAV/Navision Classic Client
Hi all,

I'm trying to create a Sales Order from C/AL (NO GUI).
However, I would like to be able to rollback if an error happens, that is no Sales Order document will be created.
This is possible if no COMMIT are called implicitly or explicitly.

I found that setting the CONSISTENT property to False would do the trick but the problem is that NAV pops up
a system error dialog when the code encounter an errors which I don't want. Is there a way avoid that message ?

My alternate solution would be creating a temporary Sales Header Record and once done I copy to a real Sales Header Record.
That seems to work at first but I realized that all the other codeunits involved in Sales Header won't be declared as temporary and they are affected by the COMMIT.

Does anyone know a solution that allows to create Sales Order that safely rollbacks everything in case of an error ?

Thanks in advance,

Dave

Comments

  • ara3n
    ara3n Member Posts: 9,258
    I suggest to get in touch with a partner that will help you with creating the codeunit and allow you to role back.
    He will need to use if CUCreateSalesOrder.run() then.. method.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • NavDave
    NavDave Member Posts: 13
    ara3n wrote:
    I suggest to get in touch with a partner that will help you with creating the codeunit and allow you to role back.
    He will need to use if CUCreateSalesOrder.run() then.. method.

    Thanks for the reply.
    Could you be more specific? Isn't there a special setting or command to set a codeunit not to do the implicit write transaction (Commit)?

Categories