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.
SQL query for items on hand and sold
Sep 16, 2009
1 Replies
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.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required