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

Link sales order to Projects (jobs)

(4) Share

Report

Posted on by peter fun

913

If I create multiple Sales Orders and want to link them to a specific project, in which field should I enter the Project (Job) Number so that I can later search all Sales Orders associated with that particular project?

Categories:

Dynamics 365 Business Central

Microsoft Dynamics RMS

Dynamics 365 Business Central migration

Microsoft Dynamics NAV

All responses (6)

Answers (0)

Sort by

Suggested answer

RockwithNav 9,225 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

You will find Project No and Project Task No on Sales Line.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
peter fun 913 on at

Like (0)

Report
Copy link

Link copied!

yeah by going through ? at the top righ corner and then inspecting the sales line there are job no and job task no as a base application

but by the name of job no and job task no i am unable to find these jobs related field from personlization.
please tell me fields name if somebody can.
Thanks
Suggested answer

YUN ZHU 103,676 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, just add some info:

Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)

https://yzhums.com/43183/

Thanks.

ZHU
Suggested answer

Andrés Arias 5,192 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The Job data are in the lines and should be entered there. Use the customize option to include them.

I hope I can help.

Regards,

Andres
Suggested answer

Yi Yong 2,805 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

You can't find job/project related fields on sales order subform because the standard design is only linking job/project module with invoice module and not order.

you see it on the table because sales invoice line is sharing the same table id.
Suggested answer

Ben Baxter 7,276 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Yi Yong is correct. Adding those fields to a Sales Order will not help you. The base logic is not there to form the connection. Microsoft's design is to have all Project related billing come from the Project to a Sales Invoice. For Project based billing you would be searching the Sales Invoices, not Sales Orders.

Also, from the Project you can see a list of all Sales Invoices associated with the Project. Likewise, you could open the Sales Lines table and filter/sort by Project No., such as using the Analysis Mode to form a summarized view by Project.

Best Regards,

Ben Baxter

Accent Software Inc