You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL to extract Ineligible Expenditure Items

edited May 12, 2020 10:41AM in Project Management 2 comments

Content

Hi,

When running the "Generate Revenue" job it is possible to set the "Generate Ineligible Data" parameter to Detail.

Then the Generate Revenue: Generate Report / GenerateRevenueReportJob job provides details about any ineligible expenditure items found.

I wondered if anyone is aware of how to find those same details using SQL?

For example - we have many thousands of ineligible expenditure items, split out across these Message Names:

  • PJB_EI_HOLD (The expenditure item wasn't invoiced or recognized for revenue because the expenditure item was on indefinite invoice or revenue hold.)
  • PJB_EI_NONBILL (The expenditure item wasn't invoiced or recognized for revenue because it was nonbillable.)
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!