SQL query for items on hand and sold

Help me with a query for eash item qty on hand and sold in one statement? I know on hand comes from item.quantity and sold qty comes from transactionentry.quantity but I don't know how to show them together in a report.

Reply to
sammm
Loading thread data ...

Help me with a query for eash item qty on hand and sold in one statement? I know on hand comes from item.quantity and sold qty comes from transactionentry.quantity but I don't know how to show them together in a report.

Reply to
cptsoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.