Inventory Sales Query
The main query for inventory sales is where you select by individual, range or all, at the same time you can select from current month or history data or both, the system will access the data with your options and gives a resut data set on the screen.
After getting the result data set you can run report with another query.
Depending on the option you will get different columns:
- Invoice #
- Customer #
- Date
- Ship
- Discount
- Price
- Amount
Customer Sales Query
The main query for customer sales is where you select by individual, range or all, at the same time you can select from current month or history data or both, the system will access the data with your options and gives a resut data set on the screen.
After getting the result data set you can run report with another query.
Depending on the option you will get different columns:- Invoice #- Purchase Order #- Company- Date- Amount
After getting the result data set you can run report with another query.
Depending on the option you will get different columns:- Invoice #- Purchase Order #- Company- Date- Amount
Purchase Query
The main query for inventory purchase is where you select by individual, range or all, at the same time you can select from current month or history data or both, the system will access the data with your options and gives a resut data set on the screen.
After getting the result data set you can run report with another query.
Depending on the option you will get different columns:- Purchase Order #- Vendor #- Date- Received- Discount- Cost- Amount
After getting the result data set you can run report with another query.
Depending on the option you will get different columns:- Purchase Order #- Vendor #- Date- Received- Discount- Cost- Amount