Print Dataset based on Group
Hello,
I would like to print item prices according to the item group.
I have a list of items, this list contains the item several times, each with a price for printing.
So first the customer group must be selected.
(This should only be necessary at the start of the process) Do I need to create another data entry field for this?
The item can then be searched for using a barcode or item number, etc. If there are any matches, these can be displayed beforehand.
The price and name found are then displayed below.
You should now be able to select how many of the selected items should be printed with the (previously) determined price/customer group.
After printing, it should clear the input and I can search for an item again.
I have already created a few templates, but I'm stuck with this project. Does anyone know how I should proceed?
Many thanks. I created a mockup of the data entry (the group is also on here, don't know if it would work like that)
I also shared a link to see how the data would be available (later SQL)
Data Example:
https://docs.google.com/spreadsheets/d/1Rly3Unn-I-0Z8xMpFXNzAu9VKjHbXhqsJNsr90TAteE/edit?usp=sharing
-
Hi Erwin,
To clarify this is what you are looking to setup.
- Filter the item list by the Group.
- Select the required items by searching for the barcode or article name.
- Specify the number of labels to print for the selected items.
Thanks for the example data, here’s how you can set this up:
Step 1: Setting up Query Prompts
- In the database setup, create a query prompt for the Customer Group Name. This will allow you to filter the items based on the selected group dynamically.
Step 2: Configuring the Form
-
Add a Dropdown List:
- Drag the query prompt created into the form and choose the control type to a Dropdown List
2. Include a Record Picker:- Add a record picker from the data entry controls to the form.
- This will display the filtered list of items based on the selected group.
Step 3: Setting up Quantities
- In the record picker’s properties, configure the Selector Column to represent Quantity.
- This setup allows users to:
- Select the rows they want to print.
- Specify individual quantities for each row.
Below is an example screenshot demonstrating the filtering process:
- Filtering by Customer Group.
- Further narrowing down through Article Number.
- Selecting different quantities for each item before printing.
Hopefully this helps you!
0 -
Have you tried setting up a Database Filter for the Customer Group and then adding a Record Picker to you Data Entry Form? The record picker selector could be set to quantity so that you have to enter in how many of each of the displayed records you want.
0 -
Hello, thank you, yes, yes, we are making progress.
I like to use a custom SQL prompt (because I don't want to load all the columns, there are just too many).
Yes,
I could do that with an export and read it in, then your description works well (not finished testing yet)But I would prefer to use a custom query. (Then the export/import procedure is also eliminated)
But it doesn't work with my idea, the selection remains empty.
I can't create classic filters like usual
SELECT
a.kArtikel,
a.cArtNr,
ab.cName AS Artikelname,
ab.cKurzBeschreibung,
a.cBarcode,
a.fVKNetto AS Standard_VK,
p.kKundenGruppe,
kg.cName AS KundenGruppeName,
p.fNettoPreis AS Preis_Fuer_Kundengruppe
FROM .tArtikel a
INNER JOIN .tArtikelBeschreibung ab
ON a.kArtikel = ab.kArtikel
LEFT JOIN [Preisliste].[vPreislisteNetto] p
ON a.kArtikel = p.kArtikel
AND p.kShop = 0
LEFT JOIN [eazybusiness].[dbo].[tKundenGruppe] kg
ON p.kKundenGruppe = kg.kKundenGruppe
WHERE
ab.kSprache = 1AND (
p.kKundenGruppe IS NULL
OR p.kKundenGruppe NOT IN (
10,32,30,29,28,27,24,23,22,20,
19,18,17,15,13,12,11,6,4,9,2
)
)
-- Nur Artikel mit abweichendem Preis
AND (
p.fNettoPreis IS NULL
OR p.fNettoPreis <> a.fVKNetto
)
-- Artikelnummern, die NICHT mit '400-' beginnen
AND a.cArtNr NOT LIKE '400-%'AND kg.cName = '?Abfrage-Eingabe1'
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare