Dave Gutman

1. Community
2. Community Questions and Answers
3. Add days and Date Calculation

Hi Larisa,  This can be done using the SQL helper, which allows you to create a SELECT statement that returns the date in the desired format.  The online help has a few examples of using SELECT to ...

• View comment
• Dave Gutman
• April 26, 2021 12:28
• 0 votes

1. Community
2. Community Questions and Answers
3. Invalid column name in sql expression

Hi Larisa, It looks like the code that assigned @STORE17  is having problems with the use of quotes.   I copied your code to my system and replaced the UDF in OITM with another field.  When I ran i...

• View comment
• Dave Gutman
• April 23, 2021 16:08
• 0 votes

1. Community
2. Feature Requests - B1 Usability Package
3. Create a Generic Condition System that can be tied to "all" features

The need to make rows in Mandatory Fields definitions conditional came up today on a project I'm working on.  The best solution would be to have a 'SQL Condition' column in the grids for each of th...

• View comment
• Dave Gutman
• March 31, 2021 17:20
• 0 votes

1. Community
2. Feature Requests - B1 Usability Package
3. B1UP - Show in a message function (Or macro) from which validation the function was triggered

New Dynamic Syntax - $[DEFINITION_CODE] and $[DEFINITION_NAME] – Boyum Helpcenter (boyum-it.com) is similar.  Maybe add to this $[CALLING_DEFINITION_TYPE] (it could be called by another UF, Validat...

• View comment
• Dave Gutman
• March 22, 2021 13:11
• 1 vote

1. Community
2. Feature Requests - B1 Usability Package
3. Create a Generic Condition System that can be tied to "all" features

I think this FR is related: Right-click Menu Creator - Ability to use -1 or similar to initiate menu's across the entire SAP B1 (all forms) – Boyum Helpcenter (boyum-it.com)  

• View comment
• Dave Gutman
• March 19, 2021 12:41
• 0 votes

1. Community
2. Feature Requests - B1 Usability Package
3. Resource Master Data manager

Gregory Coucke would this include the ability for the proposed Resource MDM to maintain Resource Costs, Warehouse Capacities, Planning Data, Fixed Assets, etc. for each Resource?  I'm guessing thes...

• View comment
• Dave Gutman
• March 19, 2021 12:24
• 0 votes

1. Community
2. Community Questions and Answers
3. @STORE variable conflicts

Hi Alex, This can be done using the B1UP SQL function.  B1UP interprets the function's argument as SQL code.  For example: @STORE1 = SQL(SELECT LastPurPrc FROM OITM WHERE ItemCode LIKE '[$38.14.0]');

• View comment
• Dave Gutman
• March 03, 2021 13:28
• 0 votes

1. Community
2. Feature Requests - Produmex WMS
3. Import tool: import moveable locations

Luuk Jansen  Please vote for your Feature Request by clicking the Up-Arrow button.  We evaluate FRs by the number votes from unique companies.  

• View comment
• Dave Gutman
• February 23, 2021 13:24
• 0 votes

1. Community
2. Feature Requests - Produmex WMS
3. Delete locations in bulk from the import tool

Please be sure to VOTE for your request.  We look at Feature Requests sorted descending by number of votes.   Click that Up-Arrow icon to vote: 

• View comment
• Dave Gutman
• February 17, 2021 17:36
• 0 votes

1. Community
2. Community Questions and Answers
3. Determine if new Business Partner address is Bill To or Ship To

Hi Jennifer,   You can set a @STORE variable which you can test against.  For example: @STORE1 = SQL(SELECT T0.[AdresType] FROM CRD1 T0 WHERE {your logic} ) ; IF (@STORE1 = 'S') BEGIN    MESSAGEBOX...

• View comment
• Dave Gutman
• February 02, 2021 00:56
• 0 votes