You’re offline. This is a read only version of the page.
85
Dear Poineers,
We are facing an issue while posting Project Invoice proposal with "Customer retained amount" on invoice lines for Fixed price in Project in D365 f&o,
An error says, "Posting Project contract ID: ABCDEF-2022 Number sequence 0 does not exist".
We did verify the Number sequence for Project ID, Proj Contract & Invoice proposal - all setup done perfectly with Number sequence setup for Scope was setup with Company.
Also, we noticed another issue that most of the times "Customer retained amount" is not getting reflected automatically as per the setup for Project contract>funding source.
Please advise with your valuable inputs on this, as we are not able to figure it out what is happening...
Hello,
Finally, we found the solution/cause for this issue. As its all because of some incorrect setup done in the environment as below.
1) Firstly, we should identify the categories which are marked Yes for “Customer payment retention” & make them deactivate. Example: As in below, we noticed few categories in the system has this option marked for Yes & deactivated those, as this option is no longer available for more than 1 category in the system.
Service Fee Core
Sales deduction
Sales of operations
Work Construction
2) Next, we must create a New Category ID for Customer retention fee, as the system will not allow user to use the old categories & also we don’t have the control to disable the “Revenue recognition” feature for the same category in Project categories screen.
3) Make sure to create a New Project Category & do not mark “Yes” for both “Revenue recognition & Subscription” features & please mark Yes for “Customer payment retention” feature.
4) Try to create new invoice proposal, should allow user to post the invoice as it worked!!
Regards,
Durgarao.
Hi Girish,
Thank you so much for your quick response!!
However, as per your suggestion link our client is not using billing rule on Proj contract level, even though we have gone through your suggestion but did not work and still facing the same issue. Number sequence set up was perfect as per instructions.
Also, the invoice line not reflecting with "Customer retained amount" automatically as per the setup.
Please let me know your inputs on this.
Thanks,
Durgarao.
Hi Durgarao,
Refer to the below link. It talks about ax 2012 but you can try the suggestion given in the below link.
https://dextersdax.blogspot.com/2018/04/number-sequence-0-does-not-exist.html?m=1
Thanks,
Girish S.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
