Codunit 5763 Whse.-Post Shipmen- end of transaction (COMMIT)

randrews

Codunit 5763 have version NAVW13.60.00.26 in our database.
Code() function have strings:

  REPEAT
    SETRANGE("Source Type","Source Type");
    SETRANGE("Source Subtype","Source Subtype");
    SETRANGE("Source No.","Source No.");
    InitSourceDocumentHeader;
    InitSourceDocumentLines;
    COMMIT;
    CounterSourceDocTotal := CounterSourceDocTotal + 1;
    PostSourceDocument(WhseShptLine);
    SETRANGE("Source Type");
    SETRANGE("Source Subtype");
    SETRANGE("Source No.");
  UNTIL NEXT = 0;

One user run "Post Inventory Cost to G/L" and block another, who post shipment.
When user is unblocked - there are some lines of shipment are posted, another not.

Somebody knows the reason? May be HotFix in Codunit 5763?

randrews

In addition:
The shipment are posted invisibly to user.
He push some button, system create Transit Transfer, process all studies of postings etc, and show only Put-aways to user.

But this process ends in posting shipment sometimes (when user was blocked).

Navision in SQL Database.

ara3n

My solution would be comment out the commit. I've done it in several instances.
The second solution would be lock gl table.
Do you have expected cost on?

randrews

We have expected cost on.
I will try your way.
Thanks