web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Job Sales Invoice does not create item ledger entries

(1) ShareShare
ReportReport
Posted on by 96
Hi All,
 
I am posting a job sales invoice for an item on a job planning line and no item ledger entries are created??!! Am I going mad??
I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at
    Can it be that the item is defined as a none inventory item?
    That will explain why no item ledger entries are created.
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    Does the system generate Item Ledger Entries when you post an normal sales Invoice?
    If not, the option below may not be enabled.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Ben Baxter Profile Picture
    6,620 Super User 2025 Season 2 on at
    This is standard functionality.  With Jobs, you are consuming the Item to the Job, which reduces the quantity on hand.  When you create a Sales Invoice for that Billable Job Planning Line you only want to capture the revenue, otherwise you would be double consuming the Item.  You should be able to see the consumption of the Item to the Job in the Item Ledger Entries.
     
    Hope this helps clear it up.  If you found this information helpful, please mark it as a Verified Answer.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    Jun Wang Profile Picture
    8,202 Super User 2025 Season 2 on at
    I was working on a job related project and came across the post. It seems there are gaps between Jobs module and sales module. Here are the issues I noticed:
     
    1. when user creates a planning line for a qty of items. the items are not treated as demand in BC. It doesn't show as demand on item card. Nor the planning worksheet care about it. Even qty on job order shows zero in spite of the qty I put on the planning line. It shows the planning line if I click on the zero to drill into the planning line. this is obviously incorrect. 
    2. I created a sales invoice against the planning line and able to post it even there is no inventory. BC shows no error even the prevent negative in set to yes on sales and receivable setup.
    3. a sales shipment was posted due to the sales invoice, but NO item ledger entry was created. This is the weirdest things.
     
    So what Peter noticed is same as what I observed, which is not correct and need to handled with the below workaround.
     
    1. ensure there are sufficient qty for the jobs planning line, reserve the qty to the planning line if needed.
    2. manually create a sales order to reflect the demand and plan MRP if needed.
    3. don't just post sales invoice created from planning line without checking inventory for the above reason
     
    I posted my suggestions for improvements to ideas and hope MS could fix in future release.


    this is the link to the suggest improvements, please vote to make BC better.



     
    Jun Wang
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans