Inventory adjustment

(0) Share

Report

Posted on by Community Member

While performing issuance in inventory management, a user has mistakenly put a positive quantity of 300 rather than to be negative. Now I need to adjust the positive quantity which is now considered purchased by AX with zero value. Please guide me what should I do. I have couple of suggestion in my mind along with the problem with every one:

1. Use item issuance of -300 which will eventually knock off the quantity with the positive 300 and then issue -300 more for actual issuance but in this case there will be an issue of item rate. If i perform issuance 1st time it will issue item with the rate based on item model group which is Weighted average and same is the problem with actual issuance. I need to adjust quantity not rate.

2. What will happen if i use adjustment journal, as far as i know it will hit only profit and loss account if we adjust items quantity. Will it effect on rate/unit too or nor?

3. Is there any way to reverse the line of issuance journal which is in positive 300, if it does will it adjust the rate of per unit item or not? also will it also reverse the voucher transaction or not?

If there are any suggestions please help

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Imran Khan,

Can't you use the same journal type that you have used for recording the positive amount? If you make use of the marking functionality, the receipt and issue price should be identical and should not affect your inventory closing procedure.

Have you tested that already?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

How can I use the mark functionality?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have checked the marking functionality but it only shows negative quantities.

Was this reply helpful? Yes No
Suggested answer

Syed Fasih 2,442 on at

Like (0)

Report

You can use the Item Model group parameters. If you un-check the post financial entry and then post an adjustment journal, then it will only update the quantity and not the price/amount.

Once completed, you can check mark the post financial entry in the item model group.

I will suggest you to test this out in a test environment to see if it's working perfectly.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Imran,

Following Ludwig's suggestion, I created a positive adjustment for a quantity of 300 and posted it. I then create a negative adjustment for the same quantity. Using the 'Inventory' -> 'Marking' function, I can see previous receipts which this adjustment out can be marked against:

You can set the 'Marking' before or after the adjustment out is posted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Guy terry.

Was this reply helpful? Yes No