Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Project Invoice proposal when posted, report shows blank

Posted on by 2,430

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,420 Super User 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
    Community Member Microsoft Employee 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
    André Arnaud de Cal... 288,420 Super User 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
    Community Member Microsoft Employee 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
    André Arnaud de Cal... 288,420 Super User on at
    RE: Project Invoice proposal when posted, report shows blank

    Thanks for the feedback.

  • Suggested answer
    Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 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
    André Arnaud de Cal... 288,420 Super User 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
    Mohammad Raziq Ali 2,430 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
    André Arnaud de Cal... 288,420 Super User 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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans