PartTran Question

In the eyes of the two there is no difference except for a reason code. You might want to look at that.

Charlie Smith
Smith Business Services / 2W Technologies LLC
www.vistaconsultant.com/ www.2WTech.com




From: dswmaom
Sent: Wed 7/7/2010 5:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PartTran Question



Hi Group.
I am using PartTran to create a cycle count metric and an inventory adjustment metric but can't find a way to seperate the two. It seems as though these are both considered INV-ADJ transaction types but I can't see how to seperate the two for reporting purposes. Any ideas?
thx,
Dale.






[Non-text portions of this message have been removed]
Hi Group.
I am using PartTran to create a cycle count metric and an inventory adjustment metric but can't find a way to seperate the two. It seems as though these are both considered INV-ADJ transaction types but I can't see how to seperate the two for reporting purposes. Any ideas?
thx,
Dale.
You should be able to join in the count group detail table so you can tell which adjustments resulted from a count group close & update.

(Which fields specifically to join thru I can't recall... I don't have the data dictionary in front of me.)

Are you sure PartTran records don't have a cycle count update generated standard comment entered in one of there many fields (perhaps a reason code of some type) that would allow a simple single table query differentiation?

...I seem to recall it does but it's over 100 degrees here today (again) & I'm fuzzy from the heat.

If you don't find anything, please let me know. I have a bunch of adjustment & cycle count oriented BAQs & would be glad to check them tomorrow.

Rob

--- Original Message ---
From:"dswmaom" <dwalker@...>
Sent:Wed 7/7/10 5:07 pm
To:vantage@yahoogroups.com
Subj:[Vantage] PartTran Question

Hi Group.
I am using PartTran to create a cycle count metric and an inventory adjustment metric but can't find a way to seperate the two. It seems as though these are both considered INV-ADJ transaction types but I can't see how to seperate the two for reporting purposes. Any ideas?
thx,
Dale.
FYI - I found it.

It is called the Adjustment Source.
P=physical inventory adj
C=cycle count adj
O=other

thanks anyway,
Dale.



--- In vantage@yahoogroups.com, "dswmaom" <dwalker@...> wrote:
>
> Hi Group.
> I am using PartTran to create a cycle count metric and an inventory adjustment metric but can't find a way to seperate the two. It seems as though these are both considered INV-ADJ transaction types but I can't see how to seperate the two for reporting purposes. Any ideas?
> thx,
> Dale.
>