Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Journal Transaction Non Post Project

Posted on by

I need to be able to create a journal transaction using the non post project that was set up in project controller and fill out the employee id field.

I have opened COA and set an account category that needs to be used with the account. I also checked the "require employee" box. After filling out the account, it allows me to use the non post project account; however, it does not allow me to enter anything in the employee field. If I choose any other project, I can fill out the employee id field. Is it possible to do what I'm asking? 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Non Post Project

    No it would still post to that dummy project.  You would just ignore that project, filtering it out of any project reports.

  • Candice82 Profile Picture
    Candice82 on at
    RE: Journal Transaction Non Post Project

    So, you're saying there's no way to do it out of the box, without tricking the system? If a dummy project was used, is there a way to make it not post against it?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Non Post Project

    When you enter the non-post project into the project field the employee Id field is disabled.  

    So you basically have to trick the system.  

    Insert a new field on the screen in the grid area.  Use a user character field from the GLTran like User1.

    Move the regular employee field off to the side and mark it as invisible and disabled.

    Place the new field where the regular employee field was. Give it a tab index right after the regular employee field.  Also copy the PV and the Mask from the regular employeeID field into the new field properties.

    Then in the chk Event of the new field use the SetBufferValue to set the original employee ID field equal to the chk string.  I.E.:

    Call SetBufferValue("bgltran.employeeid", ChkStrg)

    You could also use an unbound control to instead of a user field but that means that you will have to write some code to display the employee ID from existing records in that unbound control.

    You probably will also need to write some code to set the employee field as disabled when you are using a non-project account and required when the account says that employee is required.  In other words you should duplicate what the underlying code does with the original employee ID field except make it enabled when you use the non-post project.

    You also could just set up a dummy project to handle this instead of using the non-post.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans