Avatar of Danny Kon
Danny Kon
Flag for Netherlands

asked on 

Query to get name from article and how many items sold on openbravo POS MYSQL

I am using a POS system based on openbravo
running on windows 10, mysql 5.6
The database model http://wiki.openbravo.com/wiki/POS/2.30/Database_Model
Can somebody help me to get a Query to get names from article's If stock is higher or lower than zero and see the stock amounts

cola -10 this i want to see
fanta 10 this i want to see
sprite 0 this i dont want to see

Thanks for helping Danny
MySQL ServerMiscellaneousSQL

Avatar of undefined
Last Comment
Danny Kon

8/22/2022 - Mon