Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Items remains On Order after posting Inventory Counting Journal AX2012

Posted on by 529

Hi all,

I have a new company with almost everything set up.

I have made a DIXF import for Inventory Counting Journal. which looks like is working very fine so far.

So I made the Counting journal with more than 200 items. Updated all financial dimensions to all lines. and Posted (according to AX: *successfully*).

Everything is posted. the money is in the ledger. but when I go On- Hand everything stays in: On Order.

what did I miss? 

Your help as always greatly appreciated!

R3CU11 

pastedimage1622532720653v1.pngpastedimage1622532826362v2.pngpastedimage1622532978416v4.pngpastedimage1622533225436v6.pngpastedimage1622533906291v7.png

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    No it is not fixed. Actually the error happens for any entry/modification to the InventTrans table. whether the transactions comes from a sales order/ purchase/production/ items journals etc.

    I am right now working in a previous back up I made, but it will be nice to know what happened.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    This is indeed weird. Did you verify if it now continues to run correctly? Are other processes using this table not affected?

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    I have changed the InvenTrans Table OCCenable property to NO. Then made the post of counting journal and works....

    Then I turn it back. try to post another journal and the same error shows up.

    weird...

  • Suggested answer
    CBNestor Profile Picture
    CBNestor 529 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Hi André,

    I found the problem -one of the source of the problem- and at the same time I created a new one ironically:

    I have made used of the SysDatabaseTransDelete Class for this new company while testing. and in the order hand I was importing the Counting Journals with the same Journal Id that was -At least in theory; deleted by this Class- and it happens that the Transactions in the shared transaction tables like the ones below are not beign delete at all ( I guess 'cause are shared tables):

    • InventTransOriginJournalTransReceipt
    • InventTransOriginJournalTrans
    • InventTransOriginProdTable
    • InventTransOriginPurchLine
    • InventTransOriginTransferReceive
    • InventTransOriginProdBOM
      • and so on.

    So I have two eviroments (A and B). on Enviroment A I deleted all records on those tables. Imported the journal with the same JournalID and all transactions are made, and the journal is posted successfully. ON the other hand on the enviroment B, I deleted all tables above Plus the InventTransOriginTransfer which is references to other tables, I have tried posting the Journal (any counting journal even by hand with one item) and this error pops up:

    Cannot edit a record in Inventory transactions (InventTrans).
    An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

    pastedimage1623423389637v1.png

    I already tried Restarting all Server. and it is the same.. 

    What did I messed up again this time?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Hi Nestor,

    You can try to install on a separate environment the latest CU and quality updates to see if this solves your issue. You can also consider writing a script which will create the inventory transactions like it is done by the insert method of the inventory journal lines.

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Hi André,

    Yes as mentioned. transactions are missing for some items. I have been trying to import the same list of items. sometimes 20 items are missing transaction. sometimes is 6 some 2. I tell you is radom. when Item A is missing transaction on first try. on the second try the transaction is made, and so on. Makes it difficult to track what's going on that way. The items are simple items I cannot find any error. The only things is giving me ideas is that I Reinstalled the AOS and probably the DIXF framework component has to be reinstalled as well which I haven't. anyway I tried with my other old (not reinstalled) AOS and the problem is the same.

    in the InvenSumLogTTS table the transactions has not origin FK recid and is setting the transaction type as Sales Order.. So, no clue..

     pastedimage1623130598268v1.png

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Indeed, both your replies contains required setup to get the inventory transaction created during the import. Have you checked if the inventory transaction is missing for all lines or just some? If it is not for all items, then you can check if the settings on the released product are complete and correct.

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    I think I founded what you mentioned. but this was already enabled by default.

    unfortunately error persists 

    pastedimage1623042516841v2.png

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Hi André,

    you mean this. ? . the "Run business logic in insert or update method" was already enabled. I just tried again with the Run Business validation but the problem is still the same. some items without transactions.

    maybe there is something I am missing that I don't know

    pastedimage1623040398979v1.png

    appreciate your help

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Hi Nestor,

    When there is no inventory transaction created by the import, you have to enable the insert business logic option on both the target entity and the processing group. Then it will also execute the insert() logic of the inventory journal lines which is normally taking care of creating the inventory transaction.

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans