Hi...I have try to use 'Amount' field value from Sales Invoice header table but it shows 0 in procedure but it has some value in that field. Ma'am please share why it is happen like this?..
@@gomstechtalks I want to take Amount value from sales invoice header table but now I get it zero but all the other fields in that corresponding record got correctly, this 'Amount' field, 'Remaining Amount' field are getting zero. I have used a procedure to invoke these values
Thank you so much for your support. The statement `Customer.SetFilter(Name, '@' + Name + '*');` in AL (Application Language) programming is used to set a filter on the `Customer` table. Let's break down what this statement does: Breaking Down the Statement 1. `Customer.SetFilter`: This method sets a filter on a specific field of the `Customer` table. The filter limits the records in the table to those that match the specified criteria. 2. `Name`: This is the field in the `Customer` table on which the filter is being applied. The `Name` field typically contains the names of the customers. 3. `'@' + Name + '*'`: This is the filter criteria. It consists of three parts: - `'@'`: The `@` symbol is a special character in AL that indicates a case-insensitive search. - `Name`: This is the variable or the current value of the `Name` field. - `'*'`: The asterisk (`*`) is a wildcard character that matches zero or more characters. Combined Explanation The filter criteria `'@' + Name + '*'` means that the filter will match any customer names that start with the current value of the `Name` variable, regardless of case. For example, if `Name` is "Al", the filter will match "Al", "Albert", "ALBERT", "alex", and any other name that starts with "al" in any case. Example Let's say we have a table of customers with the following names: - Alice - Albert - Alexander - Bob - Charlie If the `Name` variable is set to "Al", the `Customer.SetFilter(Name, '@' + Name + '*');` statement will filter the `Customer` table to include only the following records: - Alice - Albert - Alexander These records are included because their names start with "Al" or "al", and the filter is case-insensitive due to the `@` symbol. Practical Use This type of filter is useful in scenarios where you need to find all customer names that start with a certain prefix, and you want to ignore the case of the characters in the name. I hope this explanation helps! Let me know if you have any further questions. Regards, Dr. Gomathi
Second is how to open customer card using a action button on sales order by code not it's use property. If you have not time to make the video on this so please give some suggestion about this on the comment. How can we do it
Because this is urgent for me because I will work on project and this project use this to open customer card go through the sale order by a action button. so please help
well done dear
Thank you
Hi...I have try to use 'Amount' field value from Sales Invoice header table but it shows 0 in procedure but it has some value in that field. Ma'am please share why it is happen like this?..
Can you please explain clearly
@@gomstechtalks I want to take Amount value from sales invoice header table but now I get it zero but all the other fields in that corresponding record got correctly, this 'Amount' field, 'Remaining Amount' field are getting zero. I have used a procedure to invoke these values
Hi ma'am please make a video on how to import the CSV file
Sure.
Please check here ruclips.net/video/4ysMhgX5zbc/видео.html
Thanks mam.. it's very beneficial for me.🙏
@@gomstechtalks ma'am if you have time than make a more video on open to customer card by sales header through code
Because I can't find any reference to it online
Thanks for this wonderful video!
Can you please explain what you did in line 87?
Customer.SetFilter(Name, '@' + Name + '*');
Thank you so much for your support.
The statement `Customer.SetFilter(Name, '@' + Name + '*');` in AL (Application Language) programming is used to set a filter on the `Customer` table. Let's break down what this statement does:
Breaking Down the Statement
1. `Customer.SetFilter`: This method sets a filter on a specific field of the `Customer` table. The filter limits the records in the table to those that match the specified criteria.
2. `Name`: This is the field in the `Customer` table on which the filter is being applied. The `Name` field typically contains the names of the customers.
3. `'@' + Name + '*'`: This is the filter criteria. It consists of three parts:
- `'@'`: The `@` symbol is a special character in AL that indicates a case-insensitive search.
- `Name`: This is the variable or the current value of the `Name` field.
- `'*'`: The asterisk (`*`) is a wildcard character that matches zero or more characters.
Combined Explanation
The filter criteria `'@' + Name + '*'` means that the filter will match any customer names that start with the current value of the `Name` variable, regardless of case. For example, if `Name` is "Al", the filter will match "Al", "Albert", "ALBERT", "alex", and any other name that starts with "al" in any case.
Example
Let's say we have a table of customers with the following names:
- Alice
- Albert
- Alexander
- Bob
- Charlie
If the `Name` variable is set to "Al", the `Customer.SetFilter(Name, '@' + Name + '*');` statement will filter the `Customer` table to include only the following records:
- Alice
- Albert
- Alexander
These records are included because their names start with "Al" or "al", and the filter is case-insensitive due to the `@` symbol.
Practical Use
This type of filter is useful in scenarios where you need to find all customer names that start with a certain prefix, and you want to ignore the case of the characters in the name.
I hope this explanation helps! Let me know if you have any further questions.
Regards,
Dr. Gomathi
Second is how to open customer card using a action button on sales order by code not it's use property. If you have not time to make the video on this so please give some suggestion about this on the comment. How can we do it
Sure
@@gomstechtalks please tell me how this task will be done
Because this is urgent for me because I will work on project and this project use this to open customer card go through the sale order by a action button. so please help
You can use Runobject property to open
@@gomstechtalks actually ma'am I had done by using this property but but condition is that you not use runobject property. i have to do it by coding