Hi, What would be the query to list all checks with their statuses? I would like to know if a check has been collected, not just deposited. I know the available statuses for OCHH.Deposited are 'As Cash', 'As Postdated' and 'No', but how can know if...

Hi, I was requested to build a report containing the following and would like know the query for it: For each Purchase Order: 1. Total amount 2. Total down payment 3. Total paid, whether for down payment or separately. If for down payment, ...

Hi, I'm trying to write a query to get total sales per sales employee less canceled invoices and credit memos. Both A/R and A/R reserve invoices are being used in the system. I'm having difficulties connecting the tables OINV, INV1, ORIN and RIN1...