I created a new document named InvoiceExchange. When I choose a customer and click on SalesInvoice, all sales invoices associated with that customer appear. However, after selecting one sales invoice and attempting to add another, the previously selected invoices still appear as options.

What I want is for the previously selected invoices to not be selectable again or to not appear in the options at all. How can I achieve this?

Attached Files

Download Selection DocumentRef.SalesInvoice can only be selected once 1.jpg (287.81 KB)

Download Selection DocumentRef.SalesInvoice can only be selected once 2.jpg (467.97 KB)

Download Selection DocumentRef.SalesInvoice can only be selected once 3.jpg (479.13 KB)

Download Selection DocumentRef.SalesInvoice can only be selected once 4.jpg (291.69 KB)

Dear Gigha,

clarify please how you open the list of invoices for only one Client? And then I will tell you how to implement what you want

Hello Gigha,

thank you for your answer, I understand and you have done everything correctly.

But to implement the functionality that you want, we need to do it a little differently...

For the list form of the document "InvoiceExchange", we should switch the DynamicList "List"  to use custom queries. We will pass a list of already added documents to this query, and they will not be shown then.

Do you know how to do this?

Attached Files

Download 1.png (58.52 KB)

Hello Gigha,

for example, take a look at how this is implemented in the Counterparties catalog (Scr_1).

The logic there is as follows: we write a query that returns a certain list, and then this list is displayed on the form.

Attached Files

Download Scr_1.png (98.55 KB)