Notifications
Announcements
No record found.
As a support specialist learning the ins and outs of MDSL I have come across many instances of errors within MDSL. Some of these errors have solutions which can be found either here in the community or by simple search. But in most cases there is literally no information available at all or at times, the information that is found is very old and not applicable to the newer versions of MDSL. I am currently using MDSL 2018 CU6 and most clients I work with use either 2018/2015. I currently have an issue that was reported where a client is getting system message 6110 when trying to select a credit memo to be applied to an AR invoice. Looked up that error, no info. SO naturally I started checking other areas, for instance document maintenances. The credit memos are listed there, but when you select them to drill down further into more details, an error stating items not found pops up. Any ideas of how to solve this issue or can someone point me in the direction of a Microsoft database that has the error catalog with possible fixes?
The file MESSAGES.MSG is a text file, located in the folder SL\Applications\DB\CSVS. This file contains a default set of messages to display in a pop-up window for users. The file has a standard format that can be followed by 3rd party developers to merge custom messages specific to their application into the Messages table in the SL System database. The System Manager document, located in the User Guides folder, explains how SL uses messages.
That message #6110 is displaying the text ,"Only payments can be added in this screen." It sounds like the user has the AR payment application screen open, they want to apply a previous credit memo entry to an invoice. The document type field filters the credit balance documents by the type of document. The user should change from the default document type of payment to the document type of credit memo, which would allow them to see all unapplied CM documents available to be applied to invoices for that customer.
Thanks for the advice about the messages. As for the Payment Application screen, the doc type was changed to credit memo. Used F3 to bring up the list of unapplied credit memos, tried selecting one and the error message pops up again.
Update, so I went into the Sql and ran Select* from ARDoc. checked the refnbrs and saw them listed as 'IN' under doctype, but whats strange is the when I added the 'where doctype = 'cm' ', those same refnbrs show up as cm. Is that supposed to happen? Is it possible for transactions of different doctypes to share refnbrs?
Yes, for AR transactions the doctype and the RefNbr fields together make each record unique. The SL Help - Schema for the ARDoc table mentions that refnbrs must be unique for IN, CM, and DM doctypes.
Update on this issue. Had actually resolved it 2 months ago but forgot to update the resolution here. What happened was that after spending some time and really looking at the sql, I realized that they had leading spaces before their CM reference numbers which was resulting in the error. Applied the fix and everything is resolved now.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
