Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Journal with Different Project Date and accounting date.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi.

Is there a way to post a journal with a project date different from the accounting date. I ask this because I would like to, for example, post a journal in April, regarding a March movement, but March accounting is already closed. This because our invoices uses the Project date to identify, in a column, the invoicing month. I can do this by making a Transaction Adjustment on the current month but changing the Project Date to the previous month although I maintain the adjustment date. If it possible to do it directly on the journal, it would be great.

Regards.

*This post is locked for comments

  • SarahFranz Profile Picture
    SarahFranz 15 on at
    RE: Journal with Different Project Date and accounting date.

    I have discovered that the Project Date field (on a Vendor Invoice Journal), will default to the Posting date entered for that line. 

    If the Posting date of the line is then changed later, it will not update the Project date field and you have the potential that this will post and impact your Project subledger in a different period to that of your ledger. 

    I believe this to be a defect, as once the period is closed, you should be prevented from posting into that prior period. 

    Interested if anyone else has this issue, as I would like to resolve my problem, other than the obvious - reverse it out and do it correctly. 

    Sarah 

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Journal with Different Project Date and accounting date.

    Hi KrishnaKranth,

    Can you open a new thread and upload some screenprints with some supporting infos what has been recorded/tested? This makes things much easier to follow :-)

    Many thanks and best regards,

    Ludwig

  • KrishnaKranth Profile Picture
    KrishnaKranth 85 on at
    RE: Journal with Different Project Date and accounting date.

    Dear Ludwig,

    I tried using the same functionality in D365 for Finance and Operations. I observed that on clicking "Post", the Project date changes to Voucher date automatically and the journal gets posted which was surprising because it defeats the basic purpose of two fields. 

    Request you to help if I am missing something from parameters.

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Journal with Different Project Date and accounting date.

    If your month end is closed, then its closed.

    You do have the option of hard closed, or soft closed which someone authorised can re-open.

    You also have the option of changing session date, but it would be wrong to post to a  prior closed period - for inventory - your inventory is already closed etc.

    For project time sheet- you can back date the entries for billing purposes- the project manager does not update his time for last month until first week of this month- but the customers liability date to pay is based on the date(s) for which he worked last month.

    With regard to item requirements Ludwig has pointed you in the right direction. Committed costs are just those  costs for items that your legal entity has committed to, and are now obligated to purchase. “Committed costs” are needed for the project expenses that are used over a period longer than the cost reporting period. Also see Sandeep Chaudary's blog he had a useful  post on this topic.

    Check for hotfixes if on an older version there have been several released in the area of project committed costs.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Journal with Different Project Date and accounting date.

    Hi nzalmeida,

    The item journal does not allow you this posting date - project date separation.

    However, if you make use of item requirements you are more flexible in regards to the time when you consume an item to the project. A major advantage of using item requirements - in combination with the committed cost parameters - is that you can immediately see the 'pending/forthcoming' costs in your project control forms but that you can post the packing slip at the time you define. Maybe this is something you want to look into and test in detail.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal with Different Project Date and accounting date.

    Hi Ludwig, in the Item Journal it's not possible right?

    Best Regards.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Journal with Different Project Date and accounting date.

    Hi nzalmeida,

    You can do that in the project expense journal where you can enter a voucher and a different project date directly. Before doing that remember that this might result in reconciliation problems between your GL and the project module if you make use of the standard reconciliation reports on a monthly basis.

    Best regards,

    Ludwig

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,313 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans