Our CFO was trying to run Revenue Recognition today and got the error: No product group found for GL MKT. We do not have a product group GL MKT. I have looked in the Parts table and no part has it. I looked in the order tables and no order as it. How do I determine where this is coming from?
Can you look at orderdtl or invcdtl- i’m thinking it’s invcdtl cause revenue and that table has a prodcode?
I have looked at those tables but I don’t see anything there.
I did talk with the CFO about it and he did create a new Project Billing GL Control Code MKT but the projects using it do not have a sales order associated with them since these types of projects result in nothing being shipped.
I guess the question is what needs to be tied to the project or project billing control code to stop the error.
ohhh you mean a control code??
Your post says product group.
Look at entityGLC table where GLControlCode = ‘GL MKT’
SELECT *
FROM erp.EntityGLC eg
where eg.Company = ‘YOUR COMPANY CODE’ and eg.GLCOntrolCode = ‘YourControlCode’
If you’re talking about GL cotnrol codes
1 Like
Could you post the actual text of the error message, and the Stack Trace from the Error dialog?
1 Like
The error specifically says product group. I can see the projects that have the control code when I look at the EntityGLC table. I will try to see if our test platform can get the same error. We have already run revenue recognition for this month so we can’t reproduce it. If I can get it I will post the stack trace
It turns out this error message came from a BPM our consultants put in to verify the product group GL on job material with the project billing GL. Once I created the product group to align with the project billing GL the error went away.
2 Likes