Bin locations on Job Traveler

Yahoo Archive
1
I have completely changed our Traveler from the canned one. So I do not know
exactly where you want to place the Primary Bin but I added a Subreport,
utilizing ODBC instead of the Data Definition, to my Job Traveler to display
the Job Material that is tied to each operation. It also shows Required Qty,
IUM, Warehouse and Primary Bin unless it is a Purchase Direct then it states
Purchase Direct.

The Tables I included in the Subreport are:

JobMtl
JobAsmbl
PlantWhse

And are linked in the Subreport as:

JobMtl.Company -> JobAsmbl.Company
JobMtl.JobNum -> JobAsmbl.JobNum
JobMtl.AssemblySeq -> JobAsmbl.AssemblySeq
JobMtl.Company -> PlantWhse.Company
JobMtl.PartNum -> PlantWhse.PartNum
JobMtl.WarehouseCode -> PlantWhse.WarehouseCode

The Subreport Links are:

JobAsmbl.JobNum to JobAsmbl.JobNum
JobOper.OprSeq to JobMtl.RelatedOperation
JobAsmbl.AssemblySeq to JobAsmbl.AssemblySeq

Since the report not only pulls the info from the XML file Vantage generates
it also does the ODBC connection to the database for the Subreport. So you
need to enter the ODBC Username and Password into the ODBC connection in the
Registry of Windows so that it does not prompt the user for a username or
password.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ofcwiz
Sent: Tuesday, August 05, 2008 10:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Bin locations on Job Traveler

We need to place the primary bin locations on the Job Traveler. There
is a WHSE on the Traveler out of the box but we are running Vista and
only have one warehouse. We also have stock distributed throughout the
warehouse and not in a stockroom. The picklist is not printed and is
unnecessary.
Does anyone have a modified Job Traveler or suggestions for this
modification?

Thanks,
Dave


------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
We need to place the primary bin locations on the Job Traveler. There
is a WHSE on the Traveler out of the box but we are running Vista and
only have one warehouse. We also have stock distributed throughout the
warehouse and not in a stockroom. The picklist is not printed and is
unnecessary.
Does anyone have a modified Job Traveler or suggestions for this
modification?

Thanks,
Dave