research in nav database with two key

Business Central/NAV Developers Forum
1

Hi
Please i need the C/AL CODE of research in the sales Line table a document with her documents number in navision

thanks…

2

Can you explain what you need exactly?

3

hi

in other word , how I can extract the contents of a field of type option: navision database
for example in the table Sales Line Navision, how to know the number of the customer who is to document type “command” and number document is “1000”

thanks

4

SalesLine.SETRANGE(“Document Type”,SalesLine.“Document Type”::Command);

SalesLine.SETRANGE(“Document No.”,1000); // 1000 as an example

IF SalesLine.FINDSET THEN

REPEAT

Message(’%1’,SalesLine.“Sell-to Customer No.”);

UNTIL SalesLine.Next = 0;

5

THANKS FOR HELP…:wink: