Announcements
Hi All,
In Project Invoice proposal, if journal is On-Account type while posting, data is populating on report but if it is transactional type like fee, hour or expense, no data is populating on report, report is blank.
It is same report PSAProjInvoice.report for On-Account and transactional types it uses.
Is there any setup missing which is effecting this?
Please help me in this.
Regards,
Raziq.Ali
*This post is locked for comments
Hi Jay,
Enclosed a link with the description how to debug in AX2012: msdn.microsoft.com/.../gg860898.aspx
I am having "There is no data available" for below report.
PSAContractLineInvoice.Report
What steps can I take to debug as no customizations were made.
thanks
Jay
The ProjInvoiceTMP table is a temporary table. This means it could hold records for a certain session temporary. You will not find records in the database as the records are not persistent.
I am getting no values on report for T&M projects.
I was reading ProjInvoiceTMP table would have values, but I have no values in that table.
Thanks for the feedback.
Hi Andre,
As I have mentioned before that there is no problem with code in DP class or temp table insertion.
After Troubling for long time, I have jumped into Visual studio where I have seen if any validation effecting this and I came across one validation that if hour journal creating without service order, it won't publish whole report body.
My Hour journal has created without service order makes invisible to whole report body which is a part of customization.
Thanks,
Raziq.Ali
Hi Raziq.Ali,
You can try to delete usage data for this user and the user cache files from the users Appdata\Local folder (*.auc , *.kti files)
I had a similar issue on another report in the past where this solved the problem.
Hi Andre,
This is not customized one, this was working fine previously but what went wrong in setup, it is not showing on report. This has happened in Production environ.
On-account is not combined with any other types as of now. data is rendering perfectly in on-account.
even if on-account is combined with other types, it is only populating data for on-account data but not for other transactional types in report.
On-Account is fixed price and hour journal is Time and material.
I have debugged code in PSAProjInvoiceDP class, temporary table is populating correctly for both On-account and transactional types but why it is not rendering data on report for hour and fee types.
Thanks,
Raziq.Ali
Hi Mohammad,
Can you indicate if the report is customized? What project type is being used here? Can you tell if this occurs in a combination of on-account with types like hour or also without the on-account?
André Arnaud de Cal...
294,190
Super User 2025 Season 1
Martin Dráb
232,968
Most Valuable Professional
nmaenpaa
101,158
Moderator