Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6400 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Project Accounting Asset Tracking
Description:Due to Business Ready Licensing (where clients receive a "suite" of modules when purchasing Microsoft Dynamics GP), I have found more and more clients using project accounting in non-traditional ways simply because they already own the software. One of the most common non-traditional approaches is to use the module to track capital expenditures. Project accounting works great for the capturing of the myriad of costs associated with a capital project like labor, materials, consulting, and even indirect expenses like overhead and equipment usage.

One of the questions that always comes up in discovery is how to handle the "recognition" of the asset, when a capital project has reached a specific stage of completion and the construction in progress can be capitalized. I have found that by using the WIP (Work in progress) functionality of project accounting with a time and materials project, we can easily emulate the transfer of expense from a CIP (Construction in progress) account to an asset account.

Let's walk through an example of typical WIP using a cost of $100 that is billed for $150:

$100 purchase
$100 Debit Work In Progress
$100 Credit Contra Account for Cost (Accounts Payable)

$150 billing
$100 Debit Cost of Goods Sold/Expense
$100 Credit Work in Progress
$150 Debit Accounts Receivable
$150 Credit Project Revenue

Okay, so that is all well and good, but with a capital project there would be no billing, right? Well, in our process we will do a "dummy" bill as outlined below.

$100 purchase
$100 Debit Work in Progress (Construction in Progress)
$100 Credit Contra Account for Cost (Accounts Payable)

For this to work, its important to note that the billing type is set to STD (standard) and the profit type is set to Billing Rate $0.00. These settings are very important. You cannot make the items NB (not billable) or NC (no charge), or set the profit type to NONE-- the process will not work with these settings as no WIP distribution will be generated.

Then, when we do a billing (using cycle biller or manually, choosing what needs to be recognized-- either all the costs, or just a portion), the items will show up to be billed at $0.00 resulting in a $0.00 bill and no effect on receivables management. However, the costs will be moved out of WIP in to the appropriate asset account. The billing you print serves as a record of the expenses that were capitalized.

$0.00 billing
$100 Debit Cost of Goods Sold/Expense (Asset account)
$100 Credit Work in Progress (Construction in Process account)

As an additional tip, if you are using the fixed assets module. The debit above (to Cost of Goods Sold/Expense) would actually go to the FA Clearing account, and the report from the billing would be given to the user who sets up fixed assets. They can set up the fixed asset for the total amount that was moved from CIP, the action of setting the asset up in fixed assets would then move the balance from FA clearing (credit) in to the FA cost account (debit).

If anyone has any other unique processes they have accommodated in project accounting, I would love to hear about them and will post them on this blog.
Category:TIPS AND TRICKS BY MODULES: Project Accounting
Link Owner:
Date Added:June 17, 2010 06:15:11 PM
Number Hits:34
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.