web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Items remains On Order...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Items remains On Order after posting Inventory Counting Journal AX2012

(0) ShareShare
ReportReport
Posted on by CBNestor 46

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

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,721 Super User 2025 Season 2 on at
    RE: Items remains On Order after posting Inventory Counting Journal AX2012

    Hi Nestor,

    This is quite weird. Can you share the steps you have done to import the lines via DIXF? Have you also created another counting journal manually to check if it is related to the software or caused by the data import?

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

    Hi André,

    I tried and was the same manually. Then I realized that this new company is made from a template company by Exporting Main,groups, Parameters tables. So the all voucher series Number sequence that new company was using was the same Number sequence for the template company with the scope for made to the template company.

    BUUT.... is not finished yet. I updated all the number sequence but when I validate all lines is says OK. but when posting. It throws this error:

    I can see that even the item is in the system. any transactions is made. for some items works and some not. And if I try with another Journal. the items changes the ones that did not worked before might work on the next journal...

     pastedimage1622612743826v1.pngpastedimage1622612800509v2.pngpastedimage1622612907208v3.pngpastedimage1622612942136v4.png

    pastedimage1622615107128v2.png

    here the DIXF

    pastedimage1622613537947v5.png

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,721 Super User 2025 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.

  • CBNestor Profile Picture
    CBNestor 46 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

  • CBNestor Profile Picture
    CBNestor 46 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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,721 Super User 2025 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 46 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... 300,721 Super User 2025 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.

  • Suggested answer
    CBNestor Profile Picture
    CBNestor 46 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?

  • CBNestor Profile Picture
    CBNestor 46 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...

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans