Dynamics 365 Project Operations

When customer retention is set to decimals, the calculation fails somewhere. The project invoice total amount becomes a penny different than the revenue in calculated tax.

For example,

with customer retention 7,5% on a project invoice

Header

Invoice amount: 6,805,505.96

Gross margin: 5,444,404.77

Invoice proposal transaction summaries

Invoice line amount: 5,885,843.00

Retention: 7,5%

Customer retained amount: 441,438.23 (actually 441,438.225)

Amount less retention 5,444,404.78

Posted sales tax

Amount origin: 5,444,404.78

tax: 25%

Calculated sales tax amount: 1,361,101.19 (actually 1,361,101.195)

amount origin + calculated sales tax amount = 6,805,505.97

The problem is that this causes problems in in xml validation tools, which fails with the following error message:

Document not a valid Electronic invoice, failed in validation for document type. 

The error message is due to amount + calculated sales tax is not equal invoice total amount.

To sort this out today, you need to 1) send to external provider for validation, 2) receive the error message, 3)re-invoice and manually adjust retained amount so the penny difference no longer appears, and 4) resend.

Alternatively, the XML-file can be adjusted manually, causing penny difference between actually invoiced and stated in Dynamics.

The cost of this issue for one of our clients is at least 10.000USD per year, due to increased validation and resending of invoices. This does not include the labour cost for adjusting manually the xml files and re-uploading a new file.

This was reported to Microsoft as an issue, but it was declined - as they deem it too complex to fix and they believed it is an uncommon issue. However, it happens every month for our client.

In most countries to reclaim VAT/Sales Tax on an employee expense report you need a valid VAT/Sales Tax receipt.

Today, D365 will allow you to post Sales Tax transactions/recover Sales Tax on an expense report line with or without a receipt attached. The Sales Tax calculation appears to only be based on the Tax Group and Item Tax Group selected (which can be linked to any additional Tax Configurations).

The Microsoft guidance is for a user to review all Expense Reports prior to posting and adjust Tax Groups are required.

Having the system automatically disregard Expense Lines without a receipt would minimise the effort by this individual/eliminate the need for this individual saving time and money.

The Ideas:

1. If the 'Receipt attached' field is 'No' the system will automatically not post any VAT/Sales Tax entries
2. If the user could select a 'Receipt Type' (Tax Receipt or non-Tax Receipt) - the system could determine whether or not to post any VAT/Sales Tax entries based on this receipt type.

We have the feature in the system to cancel the product receipt of project item req linked but if i enable the feature then i can able to cancel the product receipt but the posting behavior of item req packing will be change and only updated physically not financially but in the case of Time & material project type it is ok I can update the item req by posting the invoice journal but in the case of Fixed price project there is no way to update the packing slip financially.

The Feature name is they are dependent on each other

• Enable packing slip cancellation for item requirements
• Enable project purchase order product receipt cancellation with linked item requirements

In Expense Management module for Australia legal entity, intercompany GST is not posted to the correct legal entity. The issue happens when the expense is directly charged to the destination legal entity, without project linked to the record.

• The expected results: when General ledger parameter Legal entity for intercompany tax posting is set to Source (Destination option is for the US tax as shown in the description), the GST portion in subledger journal and voucher transaction should be posted to Source legal entity. Also, the Posted GST in Tax module should be recorded in Source company as well.

• The current posting pattern is incorrect: GST portion in subledger journal and voucher transaction is posted to Destination legal entity, however, the Posted GST in Tax module is recorded in Source legal entity.

Fixing the intercompany tax will make this module stand out from competitors and enhance its competitive advantages. I would appreciate it if this could be put on the roadmap.

When the customer wants to create project invoice proposal, the system has a function to select different types of invoices at one time, but separately on different invoices. 

The item sales tax group is currently not available when entering the expense itemization. the item sales tax group is only available after itemizing the expense and by going to the view all itemized expenses.

The idea is to make the item sales tax group already available when itemizing the expenses.

The user is adding lines to the Project item journal using the Excel add-in. However, presently, the cost price for the line is not getting updated automatically and is populate as 0.00 on publishing the data using Excel add-in. However, when the line is created manually on the Project item journal form, the cost price is updated correctly.

The cost price for the line should be updated on the Project item journal when the line is added using Excel add-in.

As a service company that has multiple stages to a project it would be great to have the ability to make a specific job task inactive to prevent any time being posted to that task once it has been completed.

For a simple example a project has three task lines:

Line 1.0 Phase 1

Line 2.0 Phase 2

Line 3.0 Phase 3

Phase 1 of the project has been completed. Task line 1.0 is made inactive

Phase 2 Starts, task line 2.0 is made active

Phase 3 has not started yet, task line 3.0 is inactive.

An error messages (Unable to find a unique worker record corresponding to the entered values) occurs when carrying out a project adjustment if a project validation is used in Project Parameter and setup for category/resources validation lookup.

The option is available to be use in the system and support our business processes. such scenario shouldn't pose any error message in the system.

The issue needs to be address and fixed.

·      What is the business impact to the customer?

·      Customer while using Expense Report not able to use personal expense category as it is not visible.

·      Due to this Expense report is not reflecting accuracy.

Setup:

Navigate to Expense Management > Setup > General > Shared Categories

Click on New the name of the Shared category name it as HQ Personal Costs and setup as shown below

Enable Can be used in Project > Yes

Enable Can be used in Expense > Yes and choose Expense Type as Personal

Go to Expense Management > Setup > General > Expense Category

Click on new and setup as shown in the figure below.

Category Name: HQ Personal Costs

Used in Project > Yes.

Expense Type > Personal

Default Payment Method > Select CompanyCC

Navigate to Expense Management > My Expenses > Expense Report

Click on New

Navigate to Expense Management > My Expenses > Expense Report > Click New

Expense Catogory not able to select HQ Personal Costs

Actual Result:

 Expense Category HQ Personal Costs is not available to select.

Expected Result

: Expense Category HQ Personal Costs should be available to select.