WIP GL account reconciliation

(0) Share

Report

Posted on by Community member

Hello, can somebody let me know how I can reconcile the GL WIP account to a D365 report? The idea is from TB to the report.

Many thanks for the help in advance!

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Matias,

Thanks for asking your question on this forum. Can you elaborate and provide some more details? What type of WIP account are you referring to? Is it related to projects, production or something else? What exactly do you mean by "The idea is from TB to the report"?

Was this reply helpful? Yes No
Community member 4 on at

Like (0)

Report

Hello Andre, Many thanks for your reply. Our WIP account should have projects and manufacturing. The company produces manufactured equipment plus equipment improvements that are treated as projects.

The goal is to have some reports or excel tables that i can tie to the TB WIP amount. Audit is coming very soon and they will ask WIP reconciliation....

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
You can try generating a (TB) report from D365 FO, making sure the report includes WIP accounts and other financial information required for the audit. Export project-related reports from D365 FO, which often include detailed information about engineering projects, including WIP values. Make sure these reports contain data for the same audit period as the TB report.
Using Excel or other spreadsheet software, create a worksheet to organize and compare data from the TB report and project-related reports. Reconcile WIP amounts in TB reports with WIP values in project-related reports. You can use formulas and functions to calculate the difference to make sure the two are consistent.
For more related information, you can check this link:
https://www.ebecs.com/video/reconciling-inventory-and-work-progress-wip-values-general-ledger-microsoft-dynamics-ax
Best Regards,
Hana

Was this reply helpful? Yes No
Community member 4 on at

Like (0)

Report

Hello Hana, can you please specify which project-related report i should use? I see Project WIP, Category WIP, Resource/item WIP and several others...

Many thanks!!!

Was this reply helpful? Yes No

Join the conversation

Community site session details

WIP GL account reconciliation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

WIP GL account reconciliation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates