Posting of Timesheets in bulk on Manufacturing Production Orders

(5) Share

Report

Posted on by October Sky

673

I note that the Production Journal does not allow edit in excel in BC and we would like to be able to upload timesheets in bulk against Production Orders. I'm guessing that the Output Journal could be used for that purpose but are there any apps that might be better or possible limitations with the output journal.

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Gerardo Rentería Ga... 26,082 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Same Question : Posting of Timesheets in bulk on Manufacturing Production Orders

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

Please check Insightwork apps they do have some great app for Production process

https://dmsiworks.com/apps/production-order-analysis?utm_source

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave2/smb/dynamics365-business-central/edit-excel-item-journals-warehouse-worksheets?utm

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,857 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi, You can submit this idea to Microsoft, and the Edit in Excel function is generally added by Microsoft.

For example,

https://yzhums.com/42472/

Or you can try the following method

Dynamics 365 Business Central: How to add Edit in Excel to Card and Document Pages (codeunit 1481 “Edit in Excel”)

https://yzhums.com/22941/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,114 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Hi,

The lack of Excel editability in the Production Journal can be a real bottleneck when you're trying to upload timesheets in bulk. While the Output Journal is a valid alternative, it does come with limitations, especially around setup time, indirect costs, and operation-level granularity.

Here’s what you can consider:

The Output Journal is better suited for posting finished quantities and time usage, but it doesn’t support Excel import natively. You’d need to use configuration packages or a custom page to simulate bulk entry — which can be fragile if your routing or work center setup is complex.

For more robust handling, apps like Insight Works Shop Floor Insight or Netronic Visual Production Scheduler offer time capture modules that integrate directly with production orders. These tools allow barcode scanning, mobile entry, and batch posting — much closer to what you're aiming for.

If you’re open to customization, you can expose a simplified API page or use Power Automate to push timesheet data from Excel or a third-party form into BC. This gives you control over validations and lets you bypass journal UI constraints.

Helpful Reference
Set up time sheets and their approval – BC
Registrering Time used on Production Orders – Usedynamics
TimeSheets in BC – Sabre Limited

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,171 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

You’re right, the Production Journal doesn’t support Excel edits, and while the Output Journal can work for bulk time entry, it has limitations. For better handling, consider using a timesheet app like Insight Works or explore other AppSource options.

Also, here's a helpful thread that might relate to your situation:

🔗 Solved – Deferral entries not showing in G/L

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No