HI All,
We have a Issue where the discount (Net amount) is not reflecting on the committed cost., the committed cost is getting created based on Unit Price * qty, at both PO and PR levels.
the functionality was working earlier, stopped working now, ( Net amount was considered earlier)
when I debugged using the periodic function (generate committed cost )the amount considered for the committed cost creation is fetched directly from the accounting distribution of the line and it does not consider the related discount accounting distribution.
Please guide us on if we are missing something and how to troubleshoot this further.
thanks,
Yes, removing the cash discount, reflects in the accounting distribution with discount getting posted to the same ledger as line item and not discount account , this further creates Project accounting distribution for the discount also.(can be verified from the Project button in accounting distribution form).
Committed cost is calculated form Project accounting distribution by adding all lines ,+line amounts and -discounts
hence the reflection of the net amount in committed cost and solving the issue.
Hi Karunakaran,
So, removing the cash discount account from the posting profile fixes this issue, right?
Best regards,
Ludwig
Thanks Dr Ludwig ,
the code changes mentioned in the fix are not used for the purchase order creation and confirmation process, it might be used in the sales side.
I debugged further to find out that the item that is used in purchase line should not have a discount posting account in item posting profile, seems like leaving it blank decides if the discount is posted to project as opposed posting to the discount ledger specified in the profile.
Good morning,
Can you please check whether the following hotfix applies to your environment:
Issue 3826863 Committed cost does not consider item discount
fix.lcs.dynamics.com/.../Details
Best regards,
Ludwig
Thanks Dr Ludwig for the quick response,
Please find below, the purchase order with unit price 2500 and after discount 2000
Committed cost not reflecting discount
thanks,
Hello Karunakaran,
Can you provide some details on what you mean when you say that it worked earlier?
What has changed in the meantime?
Best regards,
Ludwig
Martin Dráb
456
Most Valuable Professional
Abhilash Warrier
310
Saalim Ansari
261