I need FMS query for transportation cost field that check customer city name from customer master data and fetch the value of that city from UDO city wise transportation cost.
Query required customer wise pick list data who have open invoices and who have no invoices.
I want a where condition OINV."DocStatus" = 'O' and (who have no invoices).
When I do not write a condition (OINV."DocStatus" = 'O') then all released pi...
Thanks, Jitin Chawla for your response. I don't have S-User ID and I don't find any link without S-User ID to download SAP Business One 10 Trial Version.
Dear gergely.tyukos .I need a query of rows deleted items in production order after adding a production order with a production order number and user who deleted this rows.ThanksWarm RegardsHaseeb Baig
This error has occurred while using this code(SUBSTRING("Credit Days", 1, SUBSTR_BEFORE('D', "Credit Days")-1 ) ) as "DAYS"Error message invalid number: attribute value is not a number;string midstru(string "COL$11$", int '1', int sqladd(int [here]i...