In B1 UP How to get the form number ?

Answered

Patrice Vigier

• October 31, 2016 15:04

Hello,

I have done a macro to automatically sort Items Properties in Items Master Data form (Properties tab).

I want also to sort the same universal function/macro in the Item Properties setup form.

I use SortColumn($[$item.col.0]); and my code is

SortColumn($[$129.1.0]|ASC);
SortColumn($[$21.1.0]|ASC);

In order to avoid error and sort the right $[$item.col.0] I need to get the form number so I can write something like
If Form = 150 //Items Master Data
BEGIN
SortColumn($[$129.1.0]|ASC);
END

If Form = 429 //Irem Property setup
BEGIN
SortColumn($[$21.1.0]|ASC);
END


How can I retrieve it?

Thank you

Vote

0

• Official comment

  

  Thomas

  • November 01, 2016 11:48

  Hi Patrice,

   

  You need an .NET snippet in order to get this to work. Please see this video https://www.youtube.com/watch?v=YSZ8wMTOLHg which covers the topic.

  There is also an example in the comments on how to get the form id.

   

  I hope this helps!

  -Thomas
• 

  Patrice Vigier

  • November 01, 2016 16:31

  Hello Thomas and THANK YOU.

  I have seen this viedo before but I cannot get it works, I have an error when clicking on "Find" (that is a button called "add" in the video).

  

  My code is the sample from the video, so basic.

  

  I have noticed that the button "Test compile code is not enabled", probably because when I click on "Find" there is an error.

  I have contacted my SAP B1 partner but they do not want to help!

  This is why I need help ;=)

   

   

   
• 

  Thomas

  • November 02, 2016 13:57

  Hi Patrice,

  Unfortunately this is something you need to ask your partner. C# related questions are always paid support (as you can see from your screenshot written in red).

  Thanks,

  Thomas
• 

  Patrice Vigier

  • November 02, 2016 14:02

  Hello Thomas,

  Yes I know but they do not want to give support. They wrote me:

  Unfortunately we can not help you on Code.Net type functions that are solely dedicated to developer.
  Applications on Code.Net type functions are not snuff supported by the support

  If anybody can help me I will appreciate a lot.

  Sincerely

  Patrice
• 

  Yaremi Miranda Lopez

  • November 03, 2016 18:23

  Hello Patrice,

  In this case you need to request the paid support to your parter, we can't sell directly this service hours. Thank you for your understanding.
• 

  gl

  • October 04, 2022 05:31

  The correct code to get the form number is :

  return form.TypeEx;

  2.13.0.0

Please sign in to leave a comment.