TracerPlus Desktop

[Rao]

Location
Item#
Qty

Records are listed as

Location,Item,Qty
loc1,1234,5
loc1,1234,2
loc2,1111,1



Is there a way to add the qty's for the same item number . I am getting multiple records for the
same item number . I want the sfotware to add the qty's if I scan the same item number .

I want the data to show
loc1,1234,7
loc2,1111,1

 

[Jeff Benefiel]

In the advanced settings of the session:
1. Select Update existing record
2. Check Append if not found
3. Select Based on: item#

 

[Didier]

Or
1. Field Item :
On the After Scan TAB, tick the "Auto find on scan" option
2. Field Qty :


Then

 

[zishan ali khan]

hi didier,
this is not working, i did the exact steps but its not working as expected.
i am building an app that counts linen for example Bedsheets, pillows, duvets any suggestions will be appreciated.

regards
zishan

 

[Didier]

Hi zishan,
This works well on my side, I have a similar application as yours.
The "Auto Find on scan" option will help you to not duplicate the Items.
What problem are you facing ?
Could you send what you did ?
Regards,
Didier

 

[zishan ali khan]

Hi Didlier,

it's working but few issues,

1. every time i scan same nfc tag, qty value increased by 1, rather value should only be increased for the different tags but same item number. And not scanning the same tag with same item number. how to rectify ?

2. the initial value in the qty field is coming as 1 instead of 0 ?

3. ideally what i want is after every scan relevant fields should populate automatically ? for example.
Fitted Sheet LN1001 - qty (increase as scan goes)
Flat Sheet LN1002 - qty (increase as scan goes)
Pillows LN1003 - qty (increase as scan goes)
Duvets LN1004 - qty (increase as scan goes)


below are the details, for simplicity i just opened two fields for now, Fitted Sheet and Quantity,

fitted sheet





then for qty






data capture settings



regards
zishan

 

[Didier]

Hi Zishan,

For a RFID usage, on the Data Capture TAB, you have to set :
- Enable RFID scanner
- Scan Stop to "Tag read"

I cannot see this option for a NFC usage, anyone ?

Regards

Didier

 

[zishan ali khan]

Hi Didlier,
i have not purchased any rfid equipment but experimenting with nfc tags first to build the concept. my plan is to use on android based rfid hardware so will purchase later. basically scan logic will be same i hope. so i am not using rfid considering this how can i overcome 3 issues listed in my previous reply.

regards
zishan

 

[zishan ali khan]

fyi
issue 2 i had resolved, i am just concentrating on issue 1 now, checking validation tab but no luck.

 

[Didier]

Hi Zishan,

For the issue 1, a solution is to make a session 2 like "Code list" and from session 1 use the "lookup" option.
First, you have to fill in the list code session with some bar codes ex: 650240005428 Pills ( I used items that I had at hand).
Second, scan the boxes.
I attached an example in order to help you to better understand.
If it can help you, I used an Access Database with TracerPlus connect to manage an industrial laundry application.
Regards,
Didier

 

[zishan ali khan]

Hi Didlier,

sorry for the late reply, i will surely try the method.
thanks for sharing the file but it's blank, not coming anything. please see below.
can you please send the file again ?




regards
zishan

 

[zishan ali khan]

also i tried with another session with dropdown and lookups configured but it's not working, for your reference i have attached the zip.
can you please check what wrong i am doing ?

regards
zishan

 

[Didier]

Hello Zishan,
Sorry for the emplty file, here is the good one...

Regards,

Didier