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

G/L Entry table missing Job No. from posted job sales invoice

(0) ShareShare
ReportReport
Posted on by 135

I am seeing an issue on some G/L entries where the job number is not being assigned properly. We are using recurring job journals and posting them each month. All of the lines in these recurring job journals are marked billable and there is a unit price associated with each one. The items are all set up as "Service" type items, so when the invoice gets generated the Sales account from the general posting setup is credited and Accounts Receivable is debited. When these entries are posted, the Job No. is written to the Job No. field in the G/L Entry table. I believe that this is standard Business Central functionality. I have not made any customizations to any of the posting code units and we do not have any third-party products installed that would impact the jobs module.

This is working most of the time, but I have seen on some invoices that Job No. is blank only for certain lines. When I look at the posted sales invoice, the job number is also blank for that specific line. Has anyone seen this behavior before? Is there a way to fix this/prevent it from happening in the future? I was not able to reproduce this issue - it was reported to me by a customer.

Here is a screenshot of the G/L Entry from one of the invoices. You can see where the Job No. is missing.

GL-Entry.PNG

Here is a screenshot of the corresponding sales invoice. You can see where the Job No. is missing.

2604.Sales-Invoice.png

I have the same question (0)
  • Michael Scalamogna Profile Picture
    135 on at

    No sooner did I post this did I realize that users can add lines to sales invoices that were generated via the Create Job Sales invoice function. When users do this, the lines are not coded to the job. I believe this is what is happening.

  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    Thank you for sharing root cause. If you think this is a bug, feel free to raise it so the team can look into it.

    Thanks.

  • Suggested answer
    JAngle Profile Picture
    133 on at

    This is typically why I implement a dimension alongside which contains the job no. It also means you can use it as a filter in an analysis view so you can build an account schedule with it. Extra invoice lines can be added but they won’t update on the job so the dimension method acts as another reconciliation point also.

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,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans