Skip to main content

Notifications

Business Central forum
Suggested answer

Negative Job Journal

Posted on by 95

Hi All,

I want to find out if this is possible. I want to be able to use the jobs function to accumulate costs, in order to create a new item from this job. In other systems that I have used, I am able to add costs to the job, and then add a negative job journal line for an Item at the total cost of the job to bring that final product into Stock.

Yes, this is a form of manufacturing using the jobs instead.

When I try and do this, I get a message that I have to add more usage to the job before posting???

Any ideas / recommendations?

Debbie

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,445 Super User 2024 Season 2 on at
    RE: Negative Job Journal

    Since the Item is Serialized, you could use an Item Journal entry to add the produced Item into inventory.  The Job will not show the off-set, but I'm not sure that is that helpful.  I would rather see the fully costed Job so I have a reference point for the Item's production.

    If you want them connected, you would need to use either Production Orders or Assembly Orders to produce an Item into Inventory.  Neither of which utilizes the Time Sheets capability.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Negative Job Journal

    Debbie,

    On the Prod. Order, after I add my components and routings, I can run MRP to generate related Purchase Orders against the Production Order. When they are received the PO Cost is applied to the Prod. Order. The final final Output will increase the FG inventory for the Item you are creating.

    Hope this helps.

    Thanks,

    Steve

  • DebbieG Profile Picture
    DebbieG 95 on at
    RE: Negative Job Journal

    Yes. Was just trying something different with jobs. I tried to do time to production orders and PO’s but I must be missing something. On a PO I can see the production columns but cannot select any orders when i raise a PO.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Negative Job Journal

    Debbie,

    The Jobs granule will not create a new item after the Job is completed. If your intention is to capture manufacturing costs and then convert the Output to a real Item, I would utilize the Manufacturing process. You can add the Components to the Finished Good BOM you want to consume. You can create Routing Steps for the process and record time/labor. In the end, the Finished Good you have created will be output to the new Item and all the components consumed and capacity recorded to establish the Unit Cost of the new Item.

    Thanks,

    Steve

  • DebbieG Profile Picture
    DebbieG 95 on at
    RE: Negative Job Journal

    Hi Steve

    I am doing budget lines for the components and I then get my total Wip. I then want to do a negative line for an actual item to the job (serial tracked). So this line is not added to the job budget. I was hoping if I can do this that it will bring this item into stock. So kind of doing a manufacture from a job.

    Debbie

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Negative Job Journal

    Debbie,

    In your Job Journal, you can enter a Negative Quantity, based on Line Type and Job Task No., Type, and No.  I am not sure if you are Budgeting all the possible Job Planning Lines or just entering Cost to the Job as they happen. If you did not Budget and just add them as incurred with Line Type Budget, a new entry is added and posted. When you have the totals, you can enter a negative quantity line for the Line Type and Type/No. so that it zeroes out the combination in the Job.

    Here is a sample where I reversed some Resource hours:

    pastedimage1621499190810v1.png

    Hope this helps.

    Thank you,

    Steve

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans