5
If you use the RM Recalc scripts for 'average days to pay', data exists for both customers in the ta780000 table, and so when you use the Customer combiner tool, it sees this as a duplicate record and you get this error:
Violation of PRIMARY KEY constraint 'PKta78000'. Cannot insert duplicate key in object 'dbo.tx78000'. The duplicate key value is (XXXXX).
Please make the customer combiner tool compatible with the 'average days to pay' RM scripts and not error on the ta78000 table. (CR #87802 - rejected)
Violation of PRIMARY KEY constraint 'PKta78000'. Cannot insert duplicate key in object 'dbo.tx78000'. The duplicate key value is (XXXXX).
Please make the customer combiner tool compatible with the 'average days to pay' RM scripts and not error on the ta78000 table. (CR #87802 - rejected)
STATUS DETAILS
Declined
Administrator on 2/4/2025 7:56:25 PM
Thank you for taking the time to submit your suggestion. We truly appreciate your input and the effort you put into sharing your ideas with us.
After careful consideration, we regret to inform you that due to the current lifecycle stage of our product, we will not be able to implement your suggestion at this time.
We value your engagement and hope you continue to share your thoughts with us in the future.
Understand the Lifecycle Policies - Dynamics GP | Microsoft Learn
Terry Heley
Microsoft