Sage 100

 View Only
  • 1.  v4.4.19 standard...1. I have a problem when atte

    Posted 11-05-2014 07:19
    v4.4.19 standard... 1. I have a problem when attempting to create a Sales Order through SData.. I am getting the following error: ""This Order has no lines and has zero total amounts."" In my testing and playing around with values - I can get around this if I supply a value to the ""Discount"" amount field. I don't know why.. a 0 won't work, but if I supply a 1 it will. Obviously this is not ideal if there is really no discount on an order. 2.How do you query by a date field in Sage 100? Again I'm attempting to do this through SData. My filter looks like this: DateUpdated >= '2014-06-01' but I get an error message like ""Invalid operand for operator: >="" Any insight to these would be appreciated.


  • 2.  RE: v4.4.19 standard...1. I have a problem when atte

    Posted 11-05-2014 07:56
    I know nothing about sData, but i remember we used to wrap the dates in # signs (like '#2014-06-01#') using Access...