How to un-Register RESIGSTERED item

(0) Share

Report

Posted on by Faiqa Khushi

915

User have created “Inventory Movement Journals” to add opening balance of Inventory, and against these Movement Journals they have entered Item Arrival to register Batch # and Serial #. Below is the process

1. Create Movement Journal Inventory...Transactions.........Movement

2. Register Items (Batch # & Serial #) Item Arrival à Item Arrival

3. Post Item Movement

There are few transaction where Item Arrival is posted (step 2) but Movement is not posted (step 3) and we want to delete these transaction. System displays error message “Updating has been interrupted because there is an inventory transaction with the status Registered.” So, we have to un-register these items first to delete transaction.

Any idea??

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Community Member on at

Like (0)

Report

Hi Faiqa,

Just wondering if you found a solution to this issue? I have the same problem and I'm struggling with it.

Thanks

Dan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm getting the same error when registering a Return Order line, when the item has a different unit coversion between Stock and Sales.

E.g. if Item is stocked in PCS but sold in BAGS (and 1 BAG = 20 PCS), then when registering stock in the stock UOM, I'm encountering this error.

Any ideas please?

Was this reply helpful? Yes No
Suggested answer

Microsoft Dynamics ... 80 on at

Like (0)

Report

Hi

Same error message is also came when I try to Un-register to Registered Item in AX 2012.

For the solution I am using the backend .I am login to SQL Database and then write a query

I have taken INVENTTRANS table and find the particular item,because all the intermediate transactions exist in this table.

please follow the down steps of query:-

select * from INVENTTRANS

select * from INVENTTRANS where Itemid= 'SAGL001-02'

select * from INVENTTRANS where ITEMID='SAGL001-02' and QTY =600

--// Now choose for Date of BOM Journal same exist in DATESTATUS.

select * from INVENTTRANS where ITEMID='SAGL001-02' and QTY=600 and DATESTATUS='01/17/2013'

--// Now check here StatusReceipt = 3 which is Registered State of Item.

--// Please change the status from 3 to 0 for unregistered the particular Item.

update INVENTTRANS set STATUSRECEIPT='0' where ITEMID='SAGL001-02' and QTY=600 and DATESTATUS='01/17/2013'

By this way we can change the status from Registered to Un-registered and easily remove that Item in AX 2012.

In case if you face any problem ,please write to me on my e-mail id => lalitsoni1984@gmail.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[deleted]

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report

Is the movement journal posted?

Was this reply helpful? Yes No
Suggested answer

Weaveriski 23,620 Moderator on at

Like (0)

Report

Hi Rmar

If you have an active maintenance contract then you log a support issue with Microsoft, they are the support team, this is a community forum where Microsoft are not really present and it is populated by volunteers.

You are responding to a post that is over 4 years old, fortunately the version is in the title (not tags) but historically this forum goes back a long way.

In AX2012 go to the line, the registration is not there, press Add, it will default to the minus regstration of the one you posted, post it, it resets the registered line to ordered.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello steven,

I am reaching out to community rather than Microsoft support.

Thank you for your response. I should mention this is for a purchase order type returned order. The quantities on all items are in the negative. If I select "credit" for the disposition code a registration window pops up. I then click check box "auto-create" and "post all". If I find out at a later date that the disposition code needs to be RTC or Scrap how do I unregister the line item that contains the wrong disposition code so I can re register it with the correct disposition code?

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

Hi Rmar

Your last post was in bold and capitals and looked like a rant. Your question is actually completely different to the one that is posted, and therefore your best option is to load it as a new question with a proper title. You should be aware of what the types of disposition code are and how they are configured, if your "credit" is "credit only" you are telling AX there is no stock transaction, so you cannot change it and unregister because you have already written the stock off. Although this is sales and I thought you were talking about purchase return order which has return actions as you are sending it back not receiving it and it would be a "pick" not a registration - which is why a clear explanation is required!!

Load a new post with all of the details and see what the community comes back with.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Steven,

I do not know how the post is coming through on your end but my first email was in bold and capitalized, not my last. My apologies if you interpreted it as a rant. It was more like frustration. I am not sure about your experience with AX Client but for our company it has been very challenging and has caused many problems that we did not see coming. So again, I apologize if you took that as a rant. I was simply expressing my frustrations hoping someone would be able to answer my question.

In fact Steven you did! Your original sugestion worked perfectly! What I am doing is Intercompany returns through AX Client. item gets returned at POS to lets say company "A" quarantine warehouse. That item then gets returned to the parent company "B" through AX Client. Parent company "B" then returns it to the supplier.

I tried exactly what you mentioned by clicking "Add" and it worked. The line item went back to "Expected" and registering a different disposition code was then possible.

Thank you very much for your help. Not even the company we hired to install and customize AX for our needs could answer that question.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

Hi Rmar

It was the first email. When you are frustrated try not to take it out on the people you are asking for help!

I am glad you have a solution

Was this reply helpful? Yes No