web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

(0) ShareShare
ReportReport
Posted on by 135

We should have access to an ER config for user-defined project invoice now but I'm not finding it in Microsoft's LCS repository. Am I looking in the wrong place? I go to the Electronic Reporting workspace, under the Microsoft provider I click on Repositories, I've already added LCS to the table so I click on that and click Open in the action panel. I've searched for configurations containing "user" and "projects" (searching separately) but I'm not finding any user defined project invoice.

Is it just the one named project invoice (excel)? But I've already been playing around with that, successfully for invoices without billing rules. I've tried to reuse the format mapping for user defined invoices too but according to the errors I've been getting for user defined, the user defined one seems to need a different model mapping and won't work with project invoice model mapping).

Also, the project invoice config is tagged with SIProjInvoice (see below). Is there no stock config for SIManagedProjInvoice? Can someone point me towards how I can configure one for user defined project invoices please?

2555.pastedimage1575519591506v1.png

  • Hetal Gore Profile Picture
    291 on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    Hi Lexicon,

    Any updates on this?

    I am trying to use project invoice and have tagged this to project invoice with billing rule and can see it in print management, but when i try to view i get an error saying:

    Unable to find the report design ElectronicReporting:{527922A1-1003-4E1C-B952-5DA3F0732C4E}.

    do you know why this could be?

    I have published the report also.

  • Lexicon_ Profile Picture
    135 on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    Hi Killuke,

    Apologies for the late response.

    The Project Invoice (Excel) format you imported is by default set to Project tax invoice without billing rules.

    In your ER configuration screen, scroll down to Tags and you will see one for Business document type, and its ID assigned to SIProjInvoice, which is for without billing rules.

    pastedimage1620180181594v1.png

    You can duplicate the config with your own config provider, and then make changes to your copy of it. Change the SIProjInvoice to SIProjInvoiceWithBR and it will show up accordingly under Project tax invoice with billing rules.

  • Killuke Profile Picture
    25 on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    Hello,

    I've imported Project Invoice (Excel) and Project Manage Invoice (Excel) configurations. However, when I go to Project Management and Accounting module > Print Management I don't have Excel print options under Project invoice with billing rules under Report format.

    Any advice how to start using configurable business documents (Excel) for Project invoice with billing rules is much appreciated.

    PS! I'm a newbie in the Dynamics world :)

    3056.Pic1.png6661.Pic2.png

    I've found the required configurations from Microsoft Global Repository --> Project contract line items (Excel) and Project contract line items model mapping (RDP). 

  • Lexicon_ Profile Picture
    135 on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    No updates to the support ticket yet. We had a screenshare call and they've not been able to work it out. They were able to reproduce the errors and will keep investigating.

    Will keep this thread posted.

    Edit (12 Dec 2019): Our MS support engineer has had to escalate the problem. Fingers crossed!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    Hi Lexicon,

    I think opening a support case was the best thing you could do at the moment.

    It might indeed be an update / release issue that should get fixed soon.

    Would be great if you could keep us informed here how things are going.

    Many thanks and best regards,

    Ludwig

  • Lexicon_ Profile Picture
    135 on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    Hi Ludwig,

    Yes that was the release plan I was looking at and expecting. I've raised a ticket with MS Support and received a response as I suspected, that it is simply the Project invoice (Excel) config that is there. But it doesn't work. My response:

    ---

    Thank you for your quick response!

    I’ve played extensively with that Project invoice format but I can’t get it to work for user defined project invoices. I think it’s partly to do with the model mappings available.

    The Project invoice format is tagged with SIProjInvoice (see screenshot below) which is for project invoice without billing rules. If I pair it with the Project invoice model mapping you included within your red square selection below, the format does not show up in Print Management as a user defined project invoice format (see screenshot below). I have to derive a copy of the Project invoice format and change the tag to SIManagedProjInvoice to get it to show up in Print Management to be assigned to user defined project invoice. Then, when I try to print a project invoice with a user defined layout, I receive errors (see screenshot below). Another related conflict is in the project tax invoice proposal form. You get to select an invoice format to use but it only shows formats tagged with SIProjInvoice, which conflicts with the invoice format layout being a user defined one (see screenshot below).

    433.jpg

    Clipboarder.2019.12.06_2D00_002.pngpastedimage1575600477984v2.png

    pastedimage1575601954113v2.png

    If I pair it with the Invoice model mapping that is not in your screenshot below, then the Project invoice format does show up in Print Management under both project invoice without billing rules and user defined project invoice without needing to change the tag. This duality is in line with the project tax invoice proposal form as mentioned above, where having one format with the duality of both makes sense. However, when I try to print a project invoice with a user defined layout, I also receive errors (different ones). These ones indicate issues with format elements having no datasource bindings in the Invoice model mapping.

    From my experience, the Project invoice format works well with the Project invoice model mapping. Most of the desired datasource bindings in this model mapping are in place. When I validate the Project invoice format with this model mapping, I get minimal warnings. However, the format has never worked well with the Invoice model mapping. When I validate the format with this model mapping, I get over 150 warnings about format elements with “no binding to any datasource in using model's mapping”.

    I note that Project invoice model mapping has not been updated since creation on 3 Oct. But Invoice model mapping was just recently updated on 29 Nov. Perhaps the wrong model mapping was updated when trying to support user defined project invoice?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Business document/ER configuration for User Defined Project Invoice should be available Nov19 but I can't find it

    Hi Lexicon,

    The configurable project invoice should become available in November.

    Please see: docs.microsoft.com/.../configurable-business-documents-reporting-word-excel

    If it is not yet available for download then get into contact with MS support to ensure that there is no delay or any kind of postponement.

    Best regards,

    Ludwig

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Product updates

Dynamics 365 release plans