web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Project General Ledger setup

(0) ShareShare
ReportReport
Posted on by 279

Hello all,

We are looking to start using the Project module to track some contract R&D projects we do for customers (both fixed price and time & materials) and some internal investment projects. This is a small portion of our main business, which is manufacturing, so will only be used for a relatively small number of projects per year. I've looked through the TechNet set up guides and various blogs online, but nowhere can I find any kind of a guide to what General Ledger accounts the various types of Project Groups need to have configured. I've found bits and pieces for various project types, but no high level overview or examples that cover all the group types. Can anyone recommend a good set up guide or offer some tips? I've got Murray Fife's book, but it's heavy on showing the steps involved, but essentially nothing on WHY you're doing it and what the implications are.  

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Project General Ledger setup

    Hi PaladinSteve,

    For 1) You are right that fee transactions are used for billable amounts without associated costs. However, at the time the fee journal is posted, there is no ledger voucher generated because this voucher is generated at the time you post the invoice. The only thing that a fee journal does is recording a transaction that can in a second step be invoiced.

    For 2) You can use the pending vendor invoice form also for service transactions. This requires that you make use of a procurement category that is linked to a project category. I know that this is a hurdle for some accountants who are used to enter account numbers but you can overcome this fear for example by including the account number into the project category name.

    You can of course, continue using journals for recording invoices but be aware that you might see those costs late at a project, which is not an issue as long as you have fast invoice throughput times. Yet, I experienced a situation where an invoice >1 mio requires a long time to get approved. Because the company also used journals and not the pending vendor invoice form, the saw the costs late - too late - at the project level. So, just keep this issue with the committed project costs in mind if you want to use journals.

    For 3) Let's start with a T&M project, which is commonly used.

    Here you have 3 options:

    3.1. A basic T&M project where all costs post to P&L

    You typically make use of that for short running projects where costs and revenues match within a single period. That is, where you often write invoices to your customers for the expenses recorded.

    3.2. A T&M project with the accrual parameters active

    You use this setup for longer running projects where you need a periodic match between costs and revenues. What happens here is that all costs are posted to a P&L account. At the same time, a revenue accrual is created based on the expected sales price. At the time an invoice is created, the revenue accrual is reversed and replaced with the actual invoice revenue account setup in the project posting profiles.

    3.3. A T&M project with a Balance Sheet Accounting Setup

    I have not seen this often in practice. What happens with this setup is that all costs are 'stored' in a WIP account in the balance sheet until you invoice the customer. At the time the invoice is created, the WIP postings are reversed and shifted to the project cost accounts. At the end of the day, you can compare costs and revenues at the time an invoice is created.

    I attached you some screenprints below that illustrate the difference between those setups.

    The graphics illustrate a situation where hours are posted in January, expenses in February, item costs in March, fees in April and the invoice in May.

    6012.Figure1_2D00_139.png

    6012.Figure1_2D00_139.png

    4454.Figure1_2D00_140.png

    Hope this helps.

    Best regards,

    Ludwig

  • PaladinSteve Profile Picture
    279 on at
    RE: Project General Ledger setup

    Hi Ludwig,

    For 1) My very limited understanding of the fee journal was that it was for recording billable amounts, without associated costs, which were outside the contracted sales amount. For example, if you needed to bill the customer a late fee on an earlier invoice. I'm very surprised there's no ledger transaction created to record the unbilled revenue when the fee journal is posted. That makes the purpose of that journal even less clear. Yes, I did mean expense journal when I said Time & Materials. That one also is confusing, because the TechNet documentation makes it seem like you can only use it to record for the project expenses which are shared with the Travel & Expense module.

    For 2) The pending vendor invoice form seems to require that a purchase order has already be raised to a vendor. While most of our vendor transactions have PO's associated with them, not all do - especially for services. For most services, we find using the Invoice Journal in the AP module to be the most efficient vouching method. I had thought a project could still be referenced for lines entered there?

    For 3) That's the problem and also the source of my confusion - there are multiple project types and also project groups which combine to determine if accrual postings are required or not, or if it needs to post directly to revenue and cost of sales accounts. There's just no documentation to be found online to help determine which combinations are appropriate for our project types and, from there, what general ledger accounts we do not currently have are required to be created.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Project General Ledger setup

    Hi PaladinSteve,

    For 1) I do not know a time & material journal but expect that you mean the expense journal, which can be used for recording vendor invoices. Fee journals do not create a ledger voucher. There are just there to create positions that can be invoiced later on. Fees can be used for a lot of purposes, you can for example invoice one-time fees or even replicate 'milestones' on a T&M project

    For 2) To be quite frank, I do not like using journals for recording project expenses. Neither the AP invoice journals, nor the project expense journals. One of the reasons, why I do not like journals is because they are not included in the committed cost calculation (please see here for details: dynamicsax-fico.com/.../a-note-on-committed-project-costs). Another reason, why I do not like journals is because they do not allow recording project related intercompany postings. Finally, please remember that intercompany project transactions automatically create a pending vendor invoice. Using Journals would thus require working with different ways how ordinary and intercompany invoices are processed. My favorite is therefore the pending vendor invoice form for recording project expenses.

    For 3) That is difficult to answer because there are so many setup options available. Do you refer to T&M Projects, Investment Projects, fix Price Projects? If you can provide some additional Information then I can try posting the created ledger vouchers incl. the posting types here.

    Best regards,

    Ludwig

  • PaladinSteve Profile Picture
    279 on at
    RE: Project General Ledger setup

    Hello Ludwig. I saw your book for part 1 on Amazon yesterday and plan to order it this weekend. I'm mainly looking for answers on 3 things to begin with:

    1) What are the various project journal types used for? Beginning balance, item and hours are pretty self-explanatory, but not the difference between fee and time & materials.

    2) What are the benefits/pitfalls of using project journals to record transactions vs. AP invoice journals & AR free text invoices?

    3) What general ledger accounts are debited/credited by each transaction type - what ledger accounts need to specified each project group and which, if any, aren't necessary?  

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Project General Ledger setup

    Hi PaladinSteve,

    There is not much around that describes this ledger setup. So you are more or less doomed to test different setups yourself. I am currently working on the second part of the following book (www.createspace.com/6725618), which will include all the information you are looking for. Unfortunately, I won't be able to finish this second part within the next weeks and can only try to help through this forum for the meantime. If you provide some additional information on what exactly you are looking for, we can try to get hopefully all of your questions answered here.

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Community Member Profile Picture

Community Member 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans