Bin Location on Job Traveler

Yahoo Archive
1
We had this same issue to deal with. I believe our solution was to establish 'permanent' warehouse bins by setting them up as zero qty stock transfer kan-bans. The part/warehouse/bin relationship is then retained even if O/H goes to zero and the data is accessible via PartBinInfo.

Rob Brown

--- On Mon, 6/30/08, John Atwood <John.Atwood@...> wrote:
From: John Atwood <John.Atwood@...>
Subject: [Vantage] Re: Bin Location on Job Traveler
To: vantage@yahoogroups.com
Date: Monday, June 30, 2008, 9:26 PM











A possible source of your problem may be if the part in question has

an on hand qty. The PartBin table only has records for parts on hand.

If the part in question doesn't have any on hand, the resulting

records may be null, possibly causing your problem.

I had a similar situation for a job pick list and used the PartPlant

table to find the PrimWhse for the part and then the PlantWhse table

to determine the PrimBin for that warehouse. In our environment, each

part is assigned to a discrete primary bin. I actually ended up using

MS Access and ODBC to write the pick list report, I couldn't figure

it out with Vantage/Crystal and it also is pulling data from outside

Vantage.

John Atwood

Stellar Micro



--- In vantage@yahoogroups .com, "Thomas Delicati"

<thomas.delicati@ ...> wrote:

>

> I would like the primary bin location to show up on my Job Traveler

> report for the Part being produced. I've tried to update my Job

> Traveler form to include the PartBin table, but every time I add the

> BinNum to the report - it doesn't matter what report section I add

it to

> - the entire report goes blank and all I get are the outlines of

each

> section. It's as if the table is not joined properly or something

along

> those lines. Has anyone had any luck with adding the primary bin

> location to the crystal report job traveler form in Vantage

8.03.400?

>

>

>

>

>

> Thomas Delicati

> Information Systems Manager

> Ottenweller Company

> 3011 Congressional Parkway

> Fort Wayne, IN 46808

>

> Phone: ext. 258

> Fax:

> Website: http://www.ottenwel ler.com <http://www.ottenwel ler.com/>

>

>

>

>

>

> [Non-text portions of this message have been removed]

>
2
I would like the primary bin location to show up on my Job Traveler
report for the Part being produced. I've tried to update my Job
Traveler form to include the PartBin table, but every time I add the
BinNum to the report - it doesn't matter what report section I add it to
- the entire report goes blank and all I get are the outlines of each
section. It's as if the table is not joined properly or something along
those lines. Has anyone had any luck with adding the primary bin
location to the crystal report job traveler form in Vantage 8.03.400?





Thomas Delicati
Information Systems Manager
Ottenweller Company
3011 Congressional Parkway
Fort Wayne, IN 46808

Phone: (260) 484-3166 ext. 258
Fax: (260) 484-9798
Website: http://www.ottenweller.com <http://www.ottenweller.com/>





[Non-text portions of this message have been removed]
3
Thomas,

When this symptom occurs within Crystal (form goes blank), it's
indicative of a bad join within CR.

I'm assuming you added the PartBin table to the Report Data Definition
in Vantage with a correct relationship. Have you examined the output
XML data file to see if the data looks good (mfgsysdata\reports\user)?
You must also duplicate the joining of the PartBin table within Crystal,
too, under Database --> Database Expert.

If you're still getting the "blank form" after doing all of this, then
it may be a deeper problem.

Feel free to email me your Job Traveler and the XML and I'll spend a
couple minutes examining it for you at lunch.



Vic Drecchio
ERP Administrator

TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...
Office: 336.668.4410 x3091
Mobile: 704.530.3092


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Delicati
Sent: Monday, June 30, 2008 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Bin Location on Job Traveler



I would like the primary bin location to show up on my Job Traveler
report for the Part being produced. I've tried to update my Job
Traveler form to include the PartBin table, but every time I add the
BinNum to the report - it doesn't matter what report section I add it to
- the entire report goes blank and all I get are the outlines of each
section. It's as if the table is not joined properly or something along
those lines. Has anyone had any luck with adding the primary bin
location to the crystal report job traveler form in Vantage 8.03.400?

Thomas Delicati
Information Systems Manager
Ottenweller Company
3011 Congressional Parkway
Fort Wayne, IN 46808

Phone: (260) 484-3166 ext. 258
Fax: (260) 484-9798
Website: http://www.ottenweller.com <http://www.ottenweller.com>
<http://www.ottenweller.com/ <http://www.ottenweller.com/> >

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
A possible source of your problem may be if the part in question has
an on hand qty. The PartBin table only has records for parts on hand.
If the part in question doesn't have any on hand, the resulting
records may be null, possibly causing your problem.
I had a similar situation for a job pick list and used the PartPlant
table to find the PrimWhse for the part and then the PlantWhse table
to determine the PrimBin for that warehouse. In our environment, each
part is assigned to a discrete primary bin. I actually ended up using
MS Access and ODBC to write the pick list report, I couldn't figure
it out with Vantage/Crystal and it also is pulling data from outside
Vantage.
John Atwood
Stellar Micro

--- In vantage@yahoogroups.com, "Thomas Delicati"
<thomas.delicati@...> wrote:
>
> I would like the primary bin location to show up on my Job Traveler
> report for the Part being produced. I've tried to update my Job
> Traveler form to include the PartBin table, but every time I add the
> BinNum to the report - it doesn't matter what report section I add
it to
> - the entire report goes blank and all I get are the outlines of
each
> section. It's as if the table is not joined properly or something
along
> those lines. Has anyone had any luck with adding the primary bin
> location to the crystal report job traveler form in Vantage
8.03.400?
>
>
>
>
>
> Thomas Delicati
> Information Systems Manager
> Ottenweller Company
> 3011 Congressional Parkway
> Fort Wayne, IN 46808
>
> Phone: (260) 484-3166 ext. 258
> Fax: (260) 484-9798
> Website: http://www.ottenweller.com <http://www.ottenweller.com/>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>