Hi Team
I need your help on project management Time sheet functionality.
In MS Dynamic 365 Finance and operations If I am filling the time sheet for the month of January. I need to enter number of hours each of the days and submit for approval. Once it will approve. I can post the time sheet. After posting of time sheet Cost vouchers and WIP vouchers are creating based on the dates specific. I want the voucher should be created at the end of the month. I have not found any setup for set voucher date at the end of the month for timesheet. can you please help me for this.
Regards
Amit Minocha
Hi Amit
There is no configuration for that and the only way to achieve what you are looking for would be a system modification.
Please let us know if there is anything else the community can help you with.
if this is not the case then please be so kind and verify the answers provided.
Many thanks
Ludwig
Thanks Ludwig & André
Hi Amit,
It looks like you duplicated your question. The questions are now merged. It has no use to cross post your questions on the forum. Like Ludwig mentioned, there is no setting and you have to consider another option.
Next to a customization, you can also consider disabling the automatic accrued revenue posting on the project group. Then you can use the periodic option to post the accrued revenue for an own defined period on the ledger date you choose.
Moved to D365 Finance forum.
In MS Dynamic 365 Finance and operations If I am filling the time sheet for the month of January. I need to enter number of hours each of the days and submit for approval. Once it will approve. I can post the time sheet. After posting of time sheet Cost vouchers and WIP vouchers are creating based on the dates specific. I want the voucher should be created at the end of the month. I have not found any setup for set voucher date at the end of the month for time sheet. can you please help me for this.
Hello amit.nysa01,
For timesheets, you can't automatically set the voucher date to the end of the month/period except by making a system modification.
A workaround is using hour journals instead, which support this functionality and can post the transaction automatically on the last day of your month/period.
Hour journals do, however, not support intercompany transactions but rather have to entered in the respective company.
Best regards,
Hi Ludwig
Thanks for your quick response.
Yes all cost transactions are recorded in accounting currency. In cost related we don't have challenge. My client are using WIP for sales in time and material project.
At the time of posting of time sheet cost is recorded in accounting currency and WIP will calculate based on the sales price (Hour)/Rate card. If it is same company.
Even same problem I have faced in Inter company time sheet, where WIP is calculate based on the Transfer price 90% of the sales value as per our scenario. All transactions are recorded based on the date specific instead of Period end date. In that case also WIP is showing balance in accounting currency because my client is maintaining 2 exchange rates 1 day of the month and last day of months.
So I want to know how I can set voucher date to end of the month date.
Hello amit,
All cost transactions in the project module are recorded in the accounting currency.
There is thus no exchange rate effect on your WiP unless you modified something here.
The only time the exchange rate comes in is when you create and post invoices.
Can you double check and confirm that?
My Client is maintaining 2 exchange rates first day of the month and last day of the month like.... 1 January exchange rate (1 USD = 72 INR) and 31 January (1 USD = 71 INR), client want WIP should record based on the closing rate in accounting currency. but now vouchers are creating on dated 1 January so balance in WIP is 100 USD = 7200 INR, the same is showing in project statement.
After posting of the Project invoice on dated 31 January WIP has been reversed on dated 31 January 100 USD= 7100 INR. So balance is showing in the WIP as per the accounting currency.
We aren't able to knock off the WIP balance from project. So please help me how we can achieve this.
Thanks
Hello Amit,
Why is it that you want to have this posting on the last day of a specific month and not on the date the transaction is recorded for?
What's the advantage / value added from having this posting on that specific day?
Would be great if you could elaborate.
Many thanks and best regards,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,257
André Arnaud de Cal... 913 Super User 2025 Season 2
Sohaib Cheema 611 User Group Leader
