Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Jobs Module - Gen. Posting Type must be equal to ' ' in G/L Account: No.=6620. Current value is 'Sale'.

Posted on by 5
I am trying to understand the Jobs module using the CRONUS AU setup (no changes- out of the box)

What I am attempting is the following:
- A simple Fixed price job using the default SETTING UP Job Posting group.
- I have 1 Job posting line called Consulting
- I want this Job line to have 2 Job Planning Lines:
- 1 Billable for a GL entry that will be the fixed price amount *G/L Account 6620)
- 1 Budget for a resource for 40 hours
- I created a new G/L Account in the Sales of Jobs sub-ledger, and do not set the General Business Posting or General Production Posting groups. From the examples I have seen around the net this seems to be the way that all examples I have seen do it
- My issue is that using the out of the box setup, when I try to add the Job Planning line for the Billable entry for the G/L Account using the out of the box account suggested, I am getting the following error:
```
Validation Results
Gen. Prod. Posting Group must have a value in G/L Account: No.=6615. It cannot be zero or empty.
```

- Then add the general posting values to the G/L Account (for simplicity I use the out-of-the-box one of 6610 which to me seems wrong because that has the name of other job expenses), making sure that I use the out of the box ones (DOMESTIC/RETAIL)
pastedimage1667545476812v1.png
- This then allows me to add the line, as well as create the Invoice, as well as calculate WIP and post the WIP to the G/L
- However, adding new Job Journal entries for the resource as Budget entries, then running Calculate WIP (this works) then Post WIP to G/L, I get the following error:
Gen. Posting Type must be equal to ' ' in G/L Account: No.=6620. The current value is 'Sale'.

I have a few questions
- Why won't the system let me create an Invoice from a Billable planning line unless the G/L account has the General Business and Product posting groups set on the G/L Account?
- If I do those posting groups set, why does it let me post the WIP to the G/L the first time, but when I add some resource cost at a later date does it give the above error?

I am tearing what is left of my hair out (FYI: I am not an accountant and I suspect that this is what is mucking me up)

Any suggestions/comments are TRULY appreciated
  • Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    RE: Jobs Module - Gen. Posting Type must be equal to ' ' in G/L Account: No.=6620. Current value is 'Sale'.

    Hi,

    In some case this type of error coming.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • rangus Profile Picture
    rangus 5 on at
    RE: Jobs Module - Gen. Posting Type must be equal to ' ' in G/L Account: No.=6620. Current value is 'Sale'.

    Thanks for the reply.

    Yes, I have tried removing the Gen Posting Type. It will then complain about there being an entry in the Gen Bus Posting Group, and then the Gen Prod Posting group.

    It is the Australian localization, so is using GST.

    What I am having trouble understanding is why posting the Sales Invoice REQUIRES an account that has that set, yet when posting from WIP to the G/L it complains that it does not expect values there. I have a sneaking suspicion that I am trying to do something that is not the usual way of doing things, as you have alluded to in your answer.

    What I was attempting to model was that I have a fixed-price project that I want to track, by having the fixed-price invoice created from the Job Planning line. However, speaking to a friend of mine this morning, the way that he has seen it done is just to incur costs and then rely on reporting to show whether we have used up all the budget or not. To me, this seems a bit of a hack, but I will defer to those with greater knowledge in this area than me

    as an aside, I have been following the Websan Youtube playlist around the Jobs module, so have been attempting to follow along with it (www.youtube.com/playlist

    Thanks for the response - very much appreciated

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Jobs Module - Gen. Posting Type must be equal to ' ' in G/L Account: No.=6620. Current value is 'Sale'.

    Somes BC requires the GBPG and GPPG group even though it's never going to use them. Not sure what localization you are running but the General Posting Type can have an impact on GST, VAT, etc.

    Have you tried removing the General Posting Type from the chart of Account card?

    My colleague that knows jobs well does not use Billable and Budget at all anytime for job planning lines.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans