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
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.
This is indeed weird. Did you verify if it now continues to run correctly? Are other processes using this table not affected?
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...
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):
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.
I already tried Restarting all Server. and it is the same..
What did I messed up again this time?
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.
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..
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.
I think I founded what you mentioned. but this was already enabled by default.
unfortunately error persists
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
appreciate your help
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156