Method Community

Hi CDS_Josh, I'm not advising you to hardcode it. The string you are sending has been hardcoded to sSelectWhere = "ActivityType like 'OB%' and NOT(AnalyzorName is Null) and NOT(AnalyzorName = '') and (DueDateStart >= STARTDATE OR ActualCompletedDate >= STARTDATE)" Since STARTDATE is not a field in your table ...

Hi CDS_Josh, Based on the error message it looks like you are not actually populating the startdate variable in your code. ie. you are using sSelectWhere = "ActivityType like 'OB%' and NOT(AnalyzorName is Null) and NOT(AnalyzorName = '') and (DueDateStart >= STARTDATE OR ActualCompletedDate >= STARTDATE)" when ...

Hi Jonsturm34, Before the user is prompted to pay has the api inserted the sales order and line items in method? During the save/update process is when the tax calculations are done. So you would need to save it in method first....then you should be able to retrieve the tax that was calculated.   Dave

Hi Jonsturm34, Can you clarify, where do you have the tax rates /codes and calculations set up? For example are they part of a custom screen? The API cannot run actions on a screen since they are independent of each other. Dave  

Hi gbisaga, Don't forget all tables have a column called recordid so you can always filter on that Paging has never come up before. Row_Number and Top would be part of the select statement which we do not allow to be directly set by users since the security risks are too high. Dave

Hi gbisaga, I think you misunderstood my response....using a date field was just an example. You can filter by any combination of fields in the table. If it is there you can add it to the where clause with a conditon. So if you had a string field, a numeric field, and a datefield you can build something like. myField1 = ...

Hi gbisaga, We don't run MySQL we run SqlServer...so in a word no....since limit is not a part of standard sql. However what you can do to limit data is use the where clause to filter data. For example I might have a table with a date field and only want orders from today onwards. So I might pass in to the where clause something iike ...

Hi PetzLife D, I've moved this to the appropriate forum to be answered Dave

Hi Lucas,   I've moved this to the appropriate forum to be answered   Dave

Hi theavspecialist,   I've moved this to the appropriate forum to be answered   Dave