Skip to main content

Notifications

Business Central forum
Suggested answer

Assembly reversed - Remaining quantity

Posted on by 313
Hi everyone,
 
I have this situation that not even my partner knows how to solve:
 
An assembly was made in three assembly orders, those orders used:
 
10,000
18,000 and
12,000 LB each, 
 
then those assembly orders were reversed, but now I have this three open rows with remaining quantities and original row has less quantity remaining, the correct quantity should be 157,886 as we already reversed Assembly orders.
 
 
 
I also need to reverse 157,886 LB that came from another assembly order. None of this quantities have been moved since they where assembled. I already have tried to use Application Worksheet   in order to try to fix these but I can't. Could you give me a hint on how to solve this situation?
 
TIA.
 
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 4,022 Super User on at
    Assembly reversed - Remaining quantity
    I would suggest you to go to item card just for below item and investigate if someone has transacted on this item. the screenshot on the post doesn't tell the whole story.
     
     
    Jun Wang
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,099 Super User on at
    Assembly reversed - Remaining quantity
    Valentin is correct,
    By doing Undo on assembly order, You cannot link the consumption and reversal entries to each other. If You need to do a correction, then You have to post an entry from Item Journal.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 4,608 Super User on at
    Assembly reversed - Remaining quantity
    Let me see if I understood:
     
    • item MPCS-06 is the output of an assembly order where a quantity of 157,886 LB was produced
    • MPCS-06 was then consumed on 3 separate assembly orders with quantities of 12,000, 18,000, 10,000
    • the 3 assembly orders were reversed so the quantities of 12,000, 18,000, and 10,000 were put back into inventory
    • the problem is, when the quantities of 12,000, 18,000, and 10,000 were put back into inventory, the system created 3 new item ledger entry lines, rather than updating the remaining quantity field in the original output line (so the original output line has a remaining quantity of 117,886 rather than 157,886)
    • overall you still have 157,886 in inventory. Its just sitting in inventory from 4 different item ledger entry lines, rather than 1 line. 
     
    So what is the problem here? Using the Undo Assembly button created new item ledger entries to put the item back into inventory, but your inventory quantity is correct.

    Is the problem because you need to reverse the original output of the assembly order where a quantity of 157,886 LB was produced? If that's the problem, then don't use the Undo Assembly action button on that posted assembly order. Use an item journal to manually undo the assembly. You would do a negative adjustment for MPCS-06, and a positive adjustment for the items consumed. 
     

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,405 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,370 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans