Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Sales Invoice from job for item with serial number

Posted on by 6

Hello,

I have an item with SN tracking.

I have made a Job with a job planning line for that item (both budget and billable)

I have made a purchase invoice linked to the job and job task for that item, where I have set the serial number of the purchased item.

Now I want to make a Sales invoice referring to that serial number, but that seems not be possible. Why?

Kind Regards

Business Central Online Version

  • Verified answer
    Ben Baxter Profile Picture
    Ben Baxter 4,894 Super User 2024 Season 2 on at
    RE: Sales Invoice from job for item with serial number

    To prep the Job Journal entry.  There is a function to "Create Job Journal Lines" from the Job Planning Lines.  This is used to auto-fill the Job Journal with what is going to be consumed on the Job.

  • kristien Profile Picture
    kristien 6 on at
    RE: Sales Invoice from job for item with serial number

    Hi, Thanks for your answer,

    but if you cannot create from a Job a Sales invoice with Tracking , what is the purpose then of the function in the Job Planning Lines: "Process" >> "Item Tracking Lines" to set serial numbers or lot numbers for the Item?

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,894 Super User 2024 Season 2 on at
    RE: Sales Invoice from job for item with serial number

    Unfortunately, this will require a custom extension or an app from AppSource.  Base BC does not let you create Sales Lines with Item Tracking defined when the Sales Line was created from the Job.

    The Serialized Item will enter inventory on the purchase order and consumed from inventory during a Job Journal transaction.  This will zero the inventory and reference the Serial number on the Job Ledger Entry.  Without customization there is no way to get the Serial information onto the Sales Invoice using the standard "Create Sales Invoice" from the Job.

  • kristien Profile Picture
    kristien 6 on at
    RE: Sales Invoice from job for item with serial number

    Hello,

    When you make a purchase invoice of an item, and you fill in the job number and job task, (and you also set the serial number), there is +1 in stock and immediately a -1 on the stock because this stock is "placed" on the job.

    Whe you the make an sales invoice to the customer, starting within the job from the job planning lines, you cannot select the serial number of the item. But I want to put the serial number of the Item that i Sell on the sales invoice. How can I do that?

    I tried to make the Sales Invoice from within the JobCard on the Job Planning Lines and also from the JobList with the function to create Sales Invoices, but the result is the same.

    What do you mean with "run the invoicing process from the job", According to me, that is exacly what I have done.

    Attached some printscreens of the process

    Invoice-Item-with-serial-number-from-job.docx

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 Season 2 on at
    RE: Sales Invoice from job for item with serial number

    Hi, I'm curious what your error message is?

    I suggest you go to Item Ledger Entries page to check the Lot number you created to check whether the inventory is sufficient.

    pastedimage1675988716085v1.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Sales Invoice from job for item with serial number

    Are you creating the sales order from the Job module?  There is most likely a reservation on that item against the job it was purchased for - that means that you can not put that SN on a manually created sales order.

    You need to run the invoicing process from the job.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans