[Pamela Lasiter]

?We are currently in the process of implementing GP Project Accounting as our project management source.  We currently use Encore.  One thing I have noticed is that there doesn’t seem to be an easy way to attached a journal entry to a project which is something that is a must have for us.  We currently use the copy/paste function from an Excel template and use a unique keystroke to open up Encore and attach AFE(project) numbers to the appropriate lines.  Is anyone out there using Project Accounting and posting JE’s with the AFE or Project number attached somehow?  I would love to know how you are doing this function.

——————————
Pamela Lasiter
Senior Accountant
Explorer Pipeline Company
Tulsa OK
——————————

[Jo deRuiter]

Hi

I love that you guys have started using GP’s Project Accounting Module.  I’m a big fan of that module, myself!

The answer to your question is that you cannot post JE’s to the Project Module.  However, you can shift thoughts on it a bit.

Most people who need to post to GP’s project do so by the type of entry it is:
Time and Expense
Equipment Usage
Miscellaneous Logs
Inventory…

This helps the functionality and reporting on Projects.

If you want to bring in “Random” entries, such as a GL entry, you use the transaction type: Miscellaneous Log Entry.

Unfortunately, you can’t cut and paste into it, but several products INTEGRATE into it.

You may be able to have someone write some customization for you, but take a look at the Misc Logs and let us know what you think.

Hopefully, other collaborators here on the forum have some tricks up their sleeves 😀

——————————
Kindest Regards,

Jo deRuiter , MCP, DCP
“That GP Red Head”
Advanced Credentialed Professional-Dynamics GP
GPUG Academy Instructor
GPUG GP Credentialing Exam Committee
Chairman, GPUG Partner Advisory Board
Dexpro Dynamics LLC
Senior Consultant
Milwaukee, WI
770-906-4504 (Cell)
——————————
——————————————-

[Pamela Lasiter]

?Thanks, Jo.  We had heard about the Misc Log option but being so used to the efficiency of the copy/paste, it was a little more cumbersome.  We are currently working with our VAR on a solution and possibly an import of some sort.  I was just hoping there was an option that we weren’t aware of.  Thank you so much for your help!

——————————
Pamela Lasiter
Senior Accountant
Explorer Pipeline Company
Tulsa OK
——————————
——————————————-

[Michael Taranto, CPA]

Not sure how much time you have spent with project accounting but you may want to consider Ket2act job cost.  I used project accounting for my own practice and found that the only way to get costs in directly was thru purchase orders.  The different log postings are used to get items in thru AP entry, GL entry.  It really becomes two entries to get one transaction into the job.

When I learned about job cost I found you can put costs to your jobs almost everywhere.  GL transactions, AP transactions, Inventory and purchase order.

I’ve implemented both for customers so this is what I have learned from using and implementing.

Best Regards,
Mike

——————————
Michael Taranto, CPA
President
ERP Consulting, LLC
Pataskala OH
740-951-0220 mtaranto@erpconsultingLLC.com
erpconsultingllc.com
——————————
——————————————-

[Jen Kuntz]

If you own SmartConnect, it would be relatively straight forward to build a “journal entry” template that actually integrations to Misc Logs so you import all journal entries for jobs.

I built a template for a customer many years ago that they would use for either GL Journal Entries or ML “journal entries” (JE to a job) and I simply had the SmartConnect maps filtering the source data depending on what was filled out. It had 2 maps, one GL, one ML, pointing to the same source, set to run 1 map after the other successfully completed so it would run both types in 1 click so to speak.

Jen

——————————
Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
Manager, Business Solutions
Energy+ Inc.
Cambridge, ON, Canada
——————————
——————————————-