New at this looking for solution
New at this looking for solution
This is being used by another software to create reports for us.
I have tweaked the template to match what we need with one exception.
I need to know how to create basically an if/then option.
I have a field that if a product has a serial number, it creates a barcode & lists the serial number.
That is perfect, unless an item has no serial number. For that I want the barcode created to read the part number
since there is no serial for that item. Is this possible?
I have tweaked the template to match what we need with one exception.
I need to know how to create basically an if/then option.
I have a field that if a product has a serial number, it creates a barcode & lists the serial number.
That is perfect, unless an item has no serial number. For that I want the barcode created to read the part number
since there is no serial for that item. Is this possible?
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: New at this looking for solution
Hello,
You can use the IIF() function from the Dictionary.
Thank you.
You can use the IIF() function from the Dictionary.
Thank you.
Re: New at this looking for solution
I thought that may be it. I just do not know the commands well enough & the help file ...well doesnt help.
What I am trying to do is for it to check if there is a serial number. If there is a serial number, then print the number & unse that info to create a barcode.
(this part already works finr). Then If there is no serial number (trackby) then I want it to print the part number and use the part number to create the barcode.
What I am trying to do is for it to check if there is a serial number. If there is a serial number, then print the number & unse that info to create a barcode.
(this part already works finr). Then If there is no serial number (trackby) then I want it to print the part number and use the part number to create the barcode.
Re: New at this looking for solution
Let me see if I can simplify my request.
On a Packlist report, we use a barcode to show the serial number on units that have a serial number.
What I want to be able to do on items that do not have serial numbers, is use the part number instead to create the barcode.
This way, when the customer scans in the receiver, it will either give a serial number or part number.
Hopefully this is more clear.
On a Packlist report, we use a barcode to show the serial number on units that have a serial number.
What I want to be able to do on items that do not have serial numbers, is use the part number instead to create the barcode.
This way, when the customer scans in the receiver, it will either give a serial number or part number.
Hopefully this is more clear.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: New at this looking for solution
Hello,
You can use {IIF(serialNumber == "", partNumber, serialNumber)}
Thank you.
You can use {IIF(serialNumber == "", partNumber, serialNumber)}
Thank you.
Re: New at this looking for solution
Lech, Thank you. I will try this as soon as I get a chance. Hopefully this is it & one more thing off my list. You have been a great help.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: New at this looking for solution
Hello
We are always glad to help you!
Thank you.
We are always glad to help you!
Thank you.
Re: New at this looking for solution
Something still is not right.
It does return the serial number (TrackBy) if there is one.
I just cannot get it to read the Part number (item number) It just returns a blank as the barcode.
And after a few tweaks, I got it to read & return the part(item) number but not the serial (trackby).
I need it to either show serial(trackby) if there is one, OR part(item) number.
It does return the serial number (TrackBy) if there is one.
I just cannot get it to read the Part number (item number) It just returns a blank as the barcode.
And after a few tweaks, I got it to read & return the part(item) number but not the serial (trackby).
I need it to either show serial(trackby) if there is one, OR part(item) number.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: New at this looking for solution
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: New at this looking for solution
Im attaching a report. The left column needs to be either part number or serial number. Once I have the right statement, I can apply it to the barcode.
- Attachments
-
- Packing Slip (29).pdf
- (165.13 KiB) Downloaded 185 times