Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Project Invoice proposal when posted, report shows blank

(0) ShareShare
ReportReport
Posted on by 2,474

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

  • André Arnaud de Calavon Profile Picture
    294,190 Super User 2025 Season 1 on at
    RE: Project Invoice proposal when posted, report shows blank

    Hi Jay,

    Enclosed a link with the description how to debug in AX2012: msdn.microsoft.com/.../gg860898.aspx

  • Community Member Profile Picture
    on at
    RE: Project Invoice proposal when posted, report shows blank

    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

  • André Arnaud de Calavon Profile Picture
    294,190 Super User 2025 Season 1 on at
    RE: Project Invoice proposal when posted, report shows blank

    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.

  • Community Member Profile Picture
    on at
    RE: Project Invoice proposal when posted, report shows blank

    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.

  • André Arnaud de Calavon Profile Picture
    294,190 Super User 2025 Season 1 on at
    RE: Project Invoice proposal when posted, report shows blank

    Thanks for the feedback.

  • Suggested answer
    Mohammad Raziq Ali Profile Picture
    2,474 on at
    RE: Project Invoice proposal when posted, report shows blank

    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

  • Verified answer
    André Arnaud de Calavon Profile Picture
    294,190 Super User 2025 Season 1 on at
    RE: Project Invoice proposal when posted, report shows blank

    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.

  • Mohammad Raziq Ali Profile Picture
    2,474 on at
    RE: Project Invoice proposal when posted, report shows blank

    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

  • André Arnaud de Calavon Profile Picture
    294,190 Super User 2025 Season 1 on at
    RE: Project Invoice proposal when posted, report shows blank

    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?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,190 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,968 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans