No record for InventTransOrigin table was created

(0) Share

Report

Posted on by AXDev_001

235

Hi All,

Does anyone experienced of creating a Sales order and sales order line but no record for "InventTransOrigin" table was created?

This issue is intermittent. Once I restart the AOS, it will be working fine but later on the issue arises again.

Hope someone knows a solution.

Thanks in advance for your help. :)

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Rachit 4,015 User Group Leader on at

Like (0)

Report

This is bit weird. Do you have any customizations in these areas? Do you get any error message? Can you debug the insert method of salesLineType class. Also check if there are any customizations in classes inventUpd_Estimated and inventUpdate, as these are used to create the record in inventTransOrigin when salesLine is created.

Also check if there is any custom batch process running in the system which is impacting this area.

Thanks,

Rachit Garg

Was this reply helpful? Yes No
AXDev_001 235 on at

Like (0)

Report

Hi Rachit Garg,

Thank you for your response.

No customizations have been done on this area. I have already invoked debugging on InventUpd_Estimated::inventUpdate. It has a condition checking if there was already a record on InventTransOrigin table and this is returning true although the record on SalesLine was newly created.

Just to inform you, we do have two companies and these companies are using the same format of number sequence for Sales Order. I'm not sure if this is part of the issue. Cause based on my analysis on the condition checking if there was already a record on InventTransOrigin it is checking a global cache.

Thanks,

AXDev

Was this reply helpful? Yes No
dachong 55 on at

Like (0)

Report

Hi All,

Any update about this post? My client also having the same issue and definitely there is no customization, now it is not only happened in purchline but also inventjournaltrans. The on-hand quantity is correct calculated but user is not able to view the inventory transactions, kindly advice.

Thanks,

Dan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are seeing a similar situation, We are AX 2012 R2 release. the same order has three lines and it missing the entry on this table for the first item. Any help is greatly appreciated.

Was this reply helpful? Yes No
Saghir Ahmed 1,330 on at

Like (0)

Report

I have also facing same problem no customization and no 2nd company.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (1)

Report

We have seen this issue. In at least one case we are certain it was related to the changing of the sign on the movement line (sales order line in our case), and some of the steps a user can take in making that happen. I have also recently seen a few cases where the InventTransOrigin record is created, but the InventTransOriginSalesLine is not. Once I create the InventTransOriginSalesLine record manually (often I can identify it's original RecId and re-use that), all is well again.

Was this reply helpful? Yes No
Rani Abdulnoor 140 on at

Like (0)

Report

i have the same problem

what the soultion??

Was this reply helpful? Yes No
Rani Abdulnoor 140 on at

Like (0)

Report

do you have soultion about these problem??

Was this reply helpful? Yes No
Lobelt on at

Like (0)

Report

Our clients also face the same problem. (AX 2012 R2 CU7, 8 companies, same numberseq format for SO and inventTransId in each companies) It seems that the issue occurs while the master planning is running during the creation of the sales order, but we are still in the dark. Any solution, tips, anybody?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

This may be a silly question - but is the item a "stocked" item (released product / Item Model Group / Stock Policy / stocked Product).

From memory, non stocked products do not use trans records.

Hope this helps ;)

Was this reply helpful? Yes No