Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jeff Roe]

We have noticed that when a new order/quote is entered there is already an order note from a previous order/quote that appears.

Why would an order/quote note show on subsequent transactions?

We are running in a 4 server Terminal Server configuration.

Ideas?

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————

[Thaddeus Suter]

This occurs when somebody has screwed up the NOTEINDX in the Company Master Table (SY01500) or it has no room for growth.

A new SO is created and it gets the next NOTEINDX from Company Master that has already been used. Hence a used Note shows up on the SO when it should not.

The fix is to run a sysobjects table cursor select on NOTEINDX to get the MAX(NOTEINDX) from the transaction tables.
One you find the max NOTEINDX, update your company master table NOTEINDX to any value that is larger – but make sure you leave room for growth like an extra 0 or 00.
Alternatively, go look at what the NOTEINDX is in the Company Master table and double its value while leaving room for growth. That will solve the problem…just less precisely than finding the MAX Noteindex from the transaction tables.

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-