[solved] 4.03 Job Cost Posting - N. American Release

MW59
MW59 Member Posts: 85
edited 2006-11-15 in NAV/Navision Classic Client
I hope I can describe my issue coherently...

In this scenario, only Resources (no Items) will ever post via the Jobs Journal. Also, nothing will ever land on the Balance Sheet. We have three P&L accounts that should net to zero when the routines in Jobs - Periodic Activities are complete. Specifically, Labor Resources are to debit one account, Machine Resources should debit another, and both types should credit the third, which is declared to be a "wash" account of sorts. I am, by the way, posting Prices rather than Costs.

I'm definitely not an expert where Job Cost Posting is concerned, but I achieved part of what I describe above. That is, I can get ALL resource cost to accumulate as a debit in one G/L account and as a credit in another. I cannot, however, create a distinction between where Labor versus Machine prices land since I can only assign a single Job Posting Group per Job.

Most of my experimentation has been in Job Posting Setup, but I note there are now some Job Cost-related columns in General Posting Setup. Maybe they've been there for a while and I never noticed (they're hidden by default). Perhaps they're a path to what I'm trying to do (since the Resources show General Product Posting Group codes), but a couple of things I tried were unsuccessful.

I guess I'm hoping someone has run into precisely this situation and got it to work. If so, I'd be grateful for any tips.

Thanks!

mw #-o
I despise animal testing. They get all nervous and give the wrong answers.

Comments

  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Navision, by default, can only have one recognition account per job. So you're analyzing your financials by jobs instead of by machine or labor.

    We have a client with your same exact requirement. There are 2 ways you can go about it.

    1. You will need to make some changes in the standard job posting routine to use the accounts setup on your Gen. Posting Setup instead of looking from the job posting setup.

    2. You can use dimensions with analysis views to differentiate each resource with their own dimension values. This way, when you do your analysis view, you can see for the job G/L accounts, which of those amounts are for machine and which are for labor.

    The 2nd option requires no modification at all.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • MW59
    MW59 Member Posts: 85
    That was really helpful...

    It confirmed what I was observing AND you gave me a good idea. You see, the client has no use for dimensions (even global ones), but they're open to new ideas.

    I could just set up a single global dimension for use with Resources and make my values "Labor" & "Machine". Then, I could easily get away with only two G/L Accounts... and where the debit amounts are landing, the client could distinguish between the two types via global dimension 1 filters. I like it!

    I think I'll leave this open just a bit longer in case others have input, but I really appreciate that Lizard.

    Thank you,

    mw
    I despise animal testing. They get all nervous and give the wrong answers.

Categories