Discussion Forum: Thread 306568 |
|
|
| | Author: | calsbricks | Posted: | Jul 15, 2021 10:31 | Subject: | Sellers tools - Query by Form (QBF) | Viewed: | 96 times | Topic: | General | |
|
| Sellers Tools – Query by Form
Here is an idea which could help both sellers and buyers using a simple Query
by form (qbf)
I am not a software screen or form designer but the fields could be something
like this:
Top half of screen
Lot No/Product Code Lot no brings up product description, clour and condition;
Product
code lets you key in colour and condition
Colour Bricklink colour
Condition Bricklink conditions
Date Range Could include all or various ranges including custom
Sort on Could have default or by any of the array fields
Transaction Type Should show Manual add, order, adjustment; part out; mass upload,
etc
Once those key choices are made the system then goes and finds the transactions
that fit your criteria
The array fields should show at least the following
Qty
Date
TransType
Reference
Unit Value
Total value
Balance
Could make the array a lot more complex with avg value calculated etc, costing
etc but initially this QBF would be of value to sellers and could be used by
buyers to see their buying history by product
If I forgot anything you think might be useful, please feel free to comment/add.
|
|
|
| | | | | |
| | | | Author: | ErwinNL | Posted: | Jul 15, 2021 10:42 | Subject: | Re: Sellers tools - Query by Form (QBF) | Viewed: | 25 times | Topic: | General | |
|
| In General, calsbricks writes:
| Sellers Tools – Query by Form
Here is an idea which could help both sellers and buyers using a simple Query
by form (qbf)
I am not a software screen or form designer but the fields could be something
like this:
Top half of screen
Lot No/Product Code Lot no brings up product description, clour and condition;
Product
code lets you key in colour and condition
Colour Bricklink colour
Condition Bricklink conditions
Date Range Could include all or various ranges including custom
Sort on Could have default or by any of the array fields
Transaction Type Should show Manual add, order, adjustment; part out; mass upload,
etc
Once those key choices are made the system then goes and finds the transactions
that fit your criteria
The array fields should show at least the following
Qty
Date
TransType
Reference
Unit Value
Total value
Balance
Could make the array a lot more complex with avg value calculated etc, costing
etc but initially this QBF would be of value to sellers and could be used by
buyers to see their buying history by product
If I forgot anything you think might be useful, please feel free to comment/add.
|
I made a search feature like this, one that you can use to filter orders and
it is really useful for administration, research on what sells, finding orders
with specific pieces, etc.
+1
|
|
|
| | | | | | | | | |
| | | | | | Author: | calsbricks | Posted: | Jul 15, 2021 10:48 | Subject: | Re: Sellers tools - Query by Form (QBF) | Viewed: | 24 times | Topic: | General | |
|
| In General, ErwinNL writes:
| In General, calsbricks writes:
| Sellers Tools – Query by Form
Here is an idea which could help both sellers and buyers using a simple Query
by form (qbf)
I am not a software screen or form designer but the fields could be something
like this:
Top half of screen
Lot No/Product Code Lot no brings up product description, clour and condition;
Product
code lets you key in colour and condition
Colour Bricklink colour
Condition Bricklink conditions
Date Range Could include all or various ranges including custom
Sort on Could have default or by any of the array fields
Transaction Type Should show Manual add, order, adjustment; part out; mass upload,
etc
Once those key choices are made the system then goes and finds the transactions
that fit your criteria
The array fields should show at least the following
Qty
Date
TransType
Reference
Unit Value
Total value
Balance
Could make the array a lot more complex with avg value calculated etc, costing
etc but initially this QBF would be of value to sellers and could be used by
buyers to see their buying history by product
If I forgot anything you think might be useful, please feel free to comment/add.
|
I made a search feature like this, one that you can use to filter orders and
it is really useful for administration, research on what sells, finding orders
with specific pieces, etc.
+1
|
We have something similar in our internal system and it works great. Would be
very useful here.
|
|
|
| | | | | |
| | | | Author: | calsbricks | Posted: | Jul 16, 2021 08:32 | Subject: | Re: Sellers tools - Query by Form (QBF) | Viewed: | 35 times | Topic: | General | |
|
| In General, calsbricks writes:
| Sellers Tools – Query by Form
Here is an idea which could help both sellers and buyers using a simple Query
by form (qbf)
I am not a software screen or form designer but the fields could be something
like this:
Top half of screen
Lot No/Product Code Lot no brings up product description, clour and condition;
Product
code lets you key in colour and condition
Colour Bricklink colour
Condition Bricklink conditions
Date Range Could include all or various ranges including custom
Sort on Could have default or by any of the array fields
Transaction Type Should show Manual add, order, adjustment; part out; mass upload,
etc
Once those key choices are made the system then goes and finds the transactions
that fit your criteria
The array fields should show at least the following
Qty
Date
TransType
Reference
Unit Value
Total value
Balance
Could make the array a lot more complex with avg value calculated etc, costing
etc but initially this QBF would be of value to sellers and could be used by
buyers to see their buying history by product
If I forgot anything you think might be useful, please feel free to comment/add.
|
Okay - a private message said pictures are worth a lot more than words as well
as offering some additional thoughts. Please see embedded (done in Word)
|
|
|
|
|
|
|
|