Topic Options
#17314 - 05/20/09 08:55 AM First Shipment Date
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Hi All,

I need to find a way to quickly reference the first day a part was shipped (we are using OE 8.1B and IC 8.1A). I cannot find a field that does this, nor am I able to find a way to do this easily for all our parts (about 3,000).

The only way I can think to do this is to make an optional field and then dump the info into there. I need this field for a custom Crystal Report.

Please let me know if there is an easier way to do this, or if anyone has any ideas.

Thanks,

Cam

Top
#17325 - 05/20/09 05:45 PM Re: First Shipment Date [Re: Acrylon]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Hi Cam

If you view the item's transactions, the date of the first invoice (i.e. shipment) would be the date the part was first shipped.

If you need this for a Crystal Report, your idea of creating an optional field is a good one. To dump the info into that field, you don't have to key it in, you can use the import function after creating an Excel file (using Crystal Reports) listing items and the first ship date.

Steve

Top
#17419 - 05/29/09 10:55 AM Re: First Shipment Date [Re: Steve Schwartz]
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Hi Steve,

That's what I ended up doing and it's working great!

Thanks!

Cam

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 61 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14465 Topics
70658 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30