We’d like to set up our GL’s so that any employee that’s apart of the Design department has their WIP Labor go to account 6000 instead of the INV/COS and WIP default account of 1151.
How can I achieve that?
To add to this, our controller does not what overhead and burden being applied to the designers either.
I believe that is what the Job Department Maintenance GL Controls is for under:
Production Management > Job Management > Setup > Departments.
As for the designers, if the Operation that they are clocking into is associated with a Resource or Resource Group without overhead & burden defined, then none will be applied.
-Rick
www.getaligned.solutions
That’s what I thought, but there’s only one account context in the Department control and it’s just called department.
I set it anyways and made sure my test designer had it assigned and logged some T&E.
I ran the WIP Recon and it did not seem to be going to the new account.
Additionally, the PE Log Viewer shows it’s pulling from the Project Billing GL Control.
Is there any way to make it so that the design WBS phases have their own code? That seems like it would do the trick.
If I set it at the project billing level, it changes it for CAD and Art as well.
The WIP Labor of the Product Group overrides the default INV/COS. So if their jobs call out the Product Group (and you assign the 6000 to it) then that should work.
Now you do mean WIP and no expense, right? 1151 looks like a balance sheet account where 6000 does not, and WIP is an asset so…
Mark W.
Mark, there’s no product group since these are Project WBS Phase jobs.
As far as your other statement… I have no idea.
I don’t know that much about the accounts.
I see that now. Didn’t catch the Projects part in the first message… What billing method are you using?
What are the options? Hah
I know we run the Capture Revenue Recognition process.
The reason I asked about the accounts is it depends on what they are trying to accomplish. A WIP account will be debited at labor entry (credit labor absorption) and when the job is relieved of costs, the WIP account will be credited and COGS will be debited. If they just want to send it to expense then you really want to avoid WIP altogether.
Mark W.
Rob says you’re on the right track.
He wants the cost to be expensed directly (without overhead), and avoid WIP all together.
Looks like we’re using the Customer Shipment billing method? It’s all grayed out, though, and I don’t think we have a choice.
(Sorry, out of the office Tuesday…)
OK, he wants to expense it but have some kind of reference to the project. So one option is to create an Expense code for each project (if you don’t have a huge number of projects) and then add those costs to your project reporting. Another option is to add a UD field to your LaborDtl file and make it accept valid project IDs. There may be some other trickery that the real accountants know but I only play one at home and in newsgroups.
If you can only access Customer Shipment from the Project Billing drop-down, then you’re not licensed for the other “Project Billing” methods.
Mark W.
There’s no way to just set a certain GL Control Code to handle this?
Maybe. Get the accountant to layout what is required in T-Accounts then maybe one could figure out how to arrange the GL Controls if possible. If project tracking is not important then it’s super easy. If project tracking is important AND they do not want it in WIP then it’s working differently than the default scenario. What do they want to see from a reporting persepective?
As the saying goes, begin with the end in mind. If one doesn’t know the end, it’s hard to begin.