"Expense" items in the Part Master

Yahoo Archive
1
Yes

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 3:45 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] "Expense" items in the Part Master


Whoa, that sounds good! Will it get the expense account from the part
class?
Greg

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Wednesday, May 21, 2003 2:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


Make the Bins in Warehouse File Maint. "Non-Nettable" and the quantities
will not accumulate and the cost will go to expense.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, May 21, 2003 2:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


We have the same issue. I use the Control Account in Company Configuration
call Inventory Adjustment to use GL account number xx-xxxx-99 (I use 99 as a
suspense (reconcile it) department account).

I then run the Inventory WIP reconciliation with Offsetting accounts-full
detail for that account at month-end and re-class (journal entry) to all the
various expense accounts. Cumbersome, but working for now.

-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 1:01 PM
To: Vantage "Onelist" (E-mail)
Subject: [Vantage] "Expense" items in the Part Master

When we started up on version 4.0 we put a lot of our
repetitively purchased tooling in the part master as non stock items. This
made ordering much easier and also gave us good purchase history. We set
them up in a Tooling Expense" part class as standard cost parts with a
standard cost of $0.00 and defaulted to a separate tool crib warehouse
location. All purchases went into stock at zero value and their cost went
to the tooling expense account. This warehouse would accumulate quantities
but not inventory value and it was easy to check. I'm pretty sure the whole
set-up was even suggested by Vantage.
We upgraded through version 5.0 right into version 5.1 which
now reconciles inventory to the G/L. Instead of hitting the expense account
my tooling purchases now get lumped together on the income statement as
inventory adjustments. I've gone over this with support and cannot come up
with a workable solution. I thought we could do something with the part
class but the inventory adjustments only get an account number from the
control account or a reason code. Unfortunately, the inventory adjustments
are made automatically when these items are received (PUR-STK creates an
ADJ-CST). Since there's no opportunity to choose a reason code that won't
work.
We thought of purchasing to a perpetual "dummy" job and use
the Product Code to assign the expense account but that's a little messy and
poses other rproblems. Anyone else out there doing something similar? I
cannot accept that the only answer is to not have such parts in the part
master.
Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>
<mailto:gclauser@... <mailto:gclauser@...> >




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3313099.4604523.1261774/D=egroupweb/S=17050071
83:HM/A=1595055/R=0/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3313099&y
had=1595055> Click Here!

<http://us.adserver.yahoo.com/l?M=244522.3313099.4604523.1261774/D=egroupmai
l/S=:HM/A=1595055/rand=461204521>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
When we started up on version 4.0 we put a lot of our repetitively purchased
tooling in the part master as non stock items. This made ordering much
easier and also gave us good purchase history. We set them up in a Tooling
Expense" part class as standard cost parts with a standard cost of $0.00 and
defaulted to a separate tool crib warehouse location. All purchases went
into stock at zero value and their cost went to the tooling expense account.
This warehouse would accumulate quantities but not inventory value and it
was easy to check. I'm pretty sure the whole set-up was even suggested by
Vantage.

We upgraded through version 5.0 right into version 5.1 which now reconciles
inventory to the G/L. Instead of hitting the expense account my tooling
purchases now get lumped together on the income statement as inventory
adjustments. I've gone over this with support and cannot come up with a
workable solution. I thought we could do something with the part class but
the inventory adjustments only get an account number from the control
account or a reason code. Unfortunately, the inventory adjustments are made
automatically when these items are received (PUR-STK creates an ADJ-CST).
Since there's no opportunity to choose a reason code that won't work.

We thought of purchasing to a perpetual "dummy" job and use the Product Code
to assign the expense account but that's a little messy and poses other
rproblems. Anyone else out there doing something similar? I cannot accept
that the only answer is to not have such parts in the part master.

Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>
3
We have the same exact issue and were never happy with any of the solutions
provided. Sorry. But, if there's an enhancement request, I will add my
name to it.



[Non-text portions of this message have been removed]
4
I completely agree with both of you.

At the end of every month, I have to zero out all the purchased quantities.
Then I write a General Ledger entry at the end of every month to reverse the
expenses back into the various expense accounts instead of having a large
total in the inventory adj account. Annoying but true.

Way back in 3.0, we were able to have zero $ invoices or some fun thing that
did not require ANY G/L involvement. Ah...........some of the "gold old
features!"

Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, May 21, 2003 1:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


We have the same exact issue and were never happy with any of the solutions
provided. Sorry. But, if there's an enhancement request, I will add my
name to it.



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



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
5
We have items in the part master that are non-stock items that are expensed off each month. We check them as non-stock and put the account number on the part number itself. When the item is received the cost goes to the expense account. the only cost that goes to adjustment is any adj-pur. Is this amount what you are trying to clear up?
Greg Clauser <gclauser@...> wrote:When we started up on version 4.0 we put a lot of our repetitively purchased
tooling in the part master as non stock items. This made ordering much
easier and also gave us good purchase history. We set them up in a Tooling
Expense" part class as standard cost parts with a standard cost of $0.00 and
defaulted to a separate tool crib warehouse location. All purchases went
into stock at zero value and their cost went to the tooling expense account.
This warehouse would accumulate quantities but not inventory value and it
was easy to check. I'm pretty sure the whole set-up was even suggested by
Vantage.

We upgraded through version 5.0 right into version 5.1 which now reconciles
inventory to the G/L. Instead of hitting the expense account my tooling
purchases now get lumped together on the income statement as inventory
adjustments. I've gone over this with support and cannot come up with a
workable solution. I thought we could do something with the part class but
the inventory adjustments only get an account number from the control
account or a reason code. Unfortunately, the inventory adjustments are made
automatically when these items are received (PUR-STK creates an ADJ-CST).
Since there's no opportunity to choose a reason code that won't work.

We thought of purchasing to a perpetual "dummy" job and use the Product Code
to assign the expense account but that's a little messy and poses other
rproblems. Anyone else out there doing something similar? I cannot accept
that the only answer is to not have such parts in the part master.

Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>


Yahoo! Groups SponsorADVERTISEMENT

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

[Non-text portions of this message have been removed]
6
We have the same issue. I use the Control Account in Company Configuration
call Inventory Adjustment to use GL account number xx-xxxx-99 (I use 99 as a
suspense (reconcile it) department account).

I then run the Inventory WIP reconciliation with Offsetting accounts-full
detail for that account at month-end and re-class (journal entry) to all the
various expense accounts. Cumbersome, but working for now.

-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 1:01 PM
To: Vantage "Onelist" (E-mail)
Subject: [Vantage] "Expense" items in the Part Master

When we started up on version 4.0 we put a lot of our
repetitively purchased tooling in the part master as non stock items. This
made ordering much easier and also gave us good purchase history. We set
them up in a Tooling Expense" part class as standard cost parts with a
standard cost of $0.00 and defaulted to a separate tool crib warehouse
location. All purchases went into stock at zero value and their cost went
to the tooling expense account. This warehouse would accumulate quantities
but not inventory value and it was easy to check. I'm pretty sure the whole
set-up was even suggested by Vantage.
We upgraded through version 5.0 right into version 5.1 which
now reconciles inventory to the G/L. Instead of hitting the expense account
my tooling purchases now get lumped together on the income statement as
inventory adjustments. I've gone over this with support and cannot come up
with a workable solution. I thought we could do something with the part
class but the inventory adjustments only get an account number from the
control account or a reason code. Unfortunately, the inventory adjustments
are made automatically when these items are received (PUR-STK creates an
ADJ-CST). Since there's no opportunity to choose a reason code that won't
work.
We thought of purchasing to a perpetual "dummy" job and use
the Product Code to assign the expense account but that's a little messy and
poses other rproblems. Anyone else out there doing something similar? I
cannot accept that the only answer is to not have such parts in the part
master.
Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>
<mailto:gclauser@... <mailto:gclauser@...> >
7
Make the Bins in Warehouse File Maint. "Non-Nettable" and the quantities
will not accumulate and the cost will go to expense.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, May 21, 2003 2:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


We have the same issue. I use the Control Account in Company Configuration
call Inventory Adjustment to use GL account number xx-xxxx-99 (I use 99 as a
suspense (reconcile it) department account).

I then run the Inventory WIP reconciliation with Offsetting accounts-full
detail for that account at month-end and re-class (journal entry) to all the
various expense accounts. Cumbersome, but working for now.

-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 1:01 PM
To: Vantage "Onelist" (E-mail)
Subject: [Vantage] "Expense" items in the Part Master

When we started up on version 4.0 we put a lot of our
repetitively purchased tooling in the part master as non stock items. This
made ordering much easier and also gave us good purchase history. We set
them up in a Tooling Expense" part class as standard cost parts with a
standard cost of $0.00 and defaulted to a separate tool crib warehouse
location. All purchases went into stock at zero value and their cost went
to the tooling expense account. This warehouse would accumulate quantities
but not inventory value and it was easy to check. I'm pretty sure the whole
set-up was even suggested by Vantage.
We upgraded through version 5.0 right into version 5.1 which
now reconciles inventory to the G/L. Instead of hitting the expense account
my tooling purchases now get lumped together on the income statement as
inventory adjustments. I've gone over this with support and cannot come up
with a workable solution. I thought we could do something with the part
class but the inventory adjustments only get an account number from the
control account or a reason code. Unfortunately, the inventory adjustments
are made automatically when these items are received (PUR-STK creates an
ADJ-CST). Since there's no opportunity to choose a reason code that won't
work.
We thought of purchasing to a perpetual "dummy" job and use
the Product Code to assign the expense account but that's a little messy and
poses other rproblems. Anyone else out there doing something similar? I
cannot accept that the only answer is to not have such parts in the part
master.
Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>
<mailto:gclauser@... <mailto:gclauser@...> >




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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
8
Don't setup the part number in the Part Master, instead enter a PO for
Part # "Tool" or whatever part #+desc and then have a Part Class
("EXPENSE-Shop Tools") that is tied to an Expense account. You won't
have the purchase history but the PO recipt get charged to the expense
account.

The other way to do this for a part # in stock is to do a Misc Issue to
a Reason Code that has the expense account tied to it

Dan Tisone
Operations / IT Consultant
dan.tisone@...
(949) 440-3685 x148
Cel (714) 227-4173





-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 11:01 AM
To: Vantage "Onelist" (E-mail)
Subject: [Vantage] "Expense" items in the Part Master


When we started up on version 4.0 we put a lot of our repetitively
purchased tooling in the part master as non stock items. This made
ordering much easier and also gave us good purchase history. We set
them up in a Tooling Expense" part class as standard cost parts with a
standard cost of $0.00 and defaulted to a separate tool crib warehouse
location. All purchases went into stock at zero value and their cost
went to the tooling expense account. This warehouse would accumulate
quantities but not inventory value and it was easy to check. I'm pretty
sure the whole set-up was even suggested by Vantage.

We upgraded through version 5.0 right into version 5.1 which now
reconciles inventory to the G/L. Instead of hitting the expense account
my tooling purchases now get lumped together on the income statement as
inventory adjustments. I've gone over this with support and cannot come
up with a workable solution. I thought we could do something with the
part class but the inventory adjustments only get an account number from
the control account or a reason code. Unfortunately, the inventory
adjustments are made automatically when these items are received
(PUR-STK creates an ADJ-CST). Since there's no opportunity to choose a
reason code that won't work.

We thought of purchasing to a perpetual "dummy" job and use the Product
Code to assign the expense account but that's a little messy and poses
other rproblems. Anyone else out there doing something similar? I
cannot accept that the only answer is to not have such parts in the part
master.

Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>



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/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
9
Whoa, that sounds good! Will it get the expense account from the part
class?
Greg

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Wednesday, May 21, 2003 2:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


Make the Bins in Warehouse File Maint. "Non-Nettable" and the quantities
will not accumulate and the cost will go to expense.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, May 21, 2003 2:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


We have the same issue. I use the Control Account in Company Configuration
call Inventory Adjustment to use GL account number xx-xxxx-99 (I use 99 as a
suspense (reconcile it) department account).

I then run the Inventory WIP reconciliation with Offsetting accounts-full
detail for that account at month-end and re-class (journal entry) to all the
various expense accounts. Cumbersome, but working for now.

-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 1:01 PM
To: Vantage "Onelist" (E-mail)
Subject: [Vantage] "Expense" items in the Part Master

When we started up on version 4.0 we put a lot of our
repetitively purchased tooling in the part master as non stock items. This
made ordering much easier and also gave us good purchase history. We set
them up in a Tooling Expense" part class as standard cost parts with a
standard cost of $0.00 and defaulted to a separate tool crib warehouse
location. All purchases went into stock at zero value and their cost went
to the tooling expense account. This warehouse would accumulate quantities
but not inventory value and it was easy to check. I'm pretty sure the whole
set-up was even suggested by Vantage.
We upgraded through version 5.0 right into version 5.1 which
now reconciles inventory to the G/L. Instead of hitting the expense account
my tooling purchases now get lumped together on the income statement as
inventory adjustments. I've gone over this with support and cannot come up
with a workable solution. I thought we could do something with the part
class but the inventory adjustments only get an account number from the
control account or a reason code. Unfortunately, the inventory adjustments
are made automatically when these items are received (PUR-STK creates an
ADJ-CST). Since there's no opportunity to choose a reason code that won't
work.
We thought of purchasing to a perpetual "dummy" job and use
the Product Code to assign the expense account but that's a little messy and
poses other rproblems. Anyone else out there doing something similar? I
cannot accept that the only answer is to not have such parts in the part
master.
Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>
<mailto:gclauser@... <mailto:gclauser@...> >




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3313099.4604523.1261774/D=egroupweb/S=17050071
83:HM/A=1595055/R=0/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3313099&y
had=1595055> Click Here!

<http://us.adserver.yahoo.com/l?M=244522.3313099.4604523.1261774/D=egroupmai
l/S=:HM/A=1595055/rand=461204521>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
10
This sounds like the the most foolproof way...Excellent!
Thanks
Greg

-----Original Message-----
From: Stephanie Geary [mailto:sageary25@...]
Sent: Wednesday, May 21, 2003 1:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] "Expense" items in the Part Master


We have items in the part master that are non-stock items that are expensed
off each month. We check them as non-stock and put the account number on
the part number itself. When the item is received the cost goes to the
expense account. the only cost that goes to adjustment is any adj-pur. Is
this amount what you are trying to clear up?


Greg Clauser <gclauser@...> wrote:
When we started up on version 4.0 we put a lot of our repetitively purchased
tooling in the part master as non stock items. This made ordering much
easier and also gave us good purchase history. We set them up in a Tooling
Expense" part class as standard cost parts with a standard cost of $0.00 and
defaulted to a separate tool crib warehouse location. All purchases went
into stock at zero value and their cost went to the tooling expense account.
This warehouse would accumulate quantities but not inventory value and it
was easy to check. I'm pretty sure the whole set-up was even suggested by
Vantage.

We upgraded through version 5.0 right into version 5.1 which now reconciles
inventory to the G/L. Instead of hitting the expense account my tooling
purchases now get lumped together on the income statement as inventory
adjustments. I've gone over this with support and cannot come up with a
workable solution. I thought we could do something with the part class but
the inventory adjustments only get an account number from the control
account or a reason code. Unfortunately, the inventory adjustments are made
automatically when these items are received (PUR-STK creates an ADJ-CST).
Since there's no opportunity to choose a reason code that won't work.

We thought of purchasing to a perpetual "dummy" job and use the Product Code
to assign the expense account but that's a little messy and poses other
rproblems. Anyone else out there doing something similar? I cannot accept
that the only answer is to not have such parts in the part master.

Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>


Yahoo! Groups SponsorADVERTISEMENT

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1564415/R=0/*http://www.netflix.com/Default?mqso=60164784&partid=317
0658>

<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1564415/rand=492980443>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
11
Yes as long as you assign the expense account to the part
class...otherwise it goes to the control account defaults

Dan Tisone
Operations / IT Consultant
dan.tisone@...
(949) 440-3685 x148
Cel (714) 227-4173





-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 12:45 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] "Expense" items in the Part Master


Whoa, that sounds good! Will it get the expense account from the part
class? Greg

-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Wednesday, May 21, 2003 2:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


Make the Bins in Warehouse File Maint. "Non-Nettable" and the quantities
will not accumulate and the cost will go to expense.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, May 21, 2003 2:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Expense" items in the Part Master


We have the same issue. I use the Control Account in Company
Configuration call Inventory Adjustment to use GL account number
xx-xxxx-99 (I use 99 as a suspense (reconcile it) department account).

I then run the Inventory WIP reconciliation with Offsetting
accounts-full detail for that account at month-end and re-class (journal
entry) to all the various expense accounts. Cumbersome, but working for
now.

-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Wednesday, May 21, 2003 1:01 PM
To: Vantage "Onelist" (E-mail)
Subject: [Vantage] "Expense" items in the Part Master

When we started up on version 4.0 we put a lot of our
repetitively purchased tooling in the part master as non stock items.
This made ordering much easier and also gave us good purchase history.
We set them up in a Tooling Expense" part class as standard cost parts
with a standard cost of $0.00 and defaulted to a separate tool crib
warehouse location. All purchases went into stock at zero value and
their cost went to the tooling expense account. This warehouse would
accumulate quantities but not inventory value and it was easy to check.
I'm pretty sure the whole set-up was even suggested by Vantage.
We upgraded through version 5.0 right into version 5.1 which
now reconciles inventory to the G/L. Instead of hitting the expense
account my tooling purchases now get lumped together on the income
statement as inventory adjustments. I've gone over this with support
and cannot come up with a workable solution. I thought we could do
something with the part class but the inventory adjustments only get an
account number from the control account or a reason code.
Unfortunately, the inventory adjustments are made automatically when
these items are received (PUR-STK creates an ADJ-CST). Since there's no
opportunity to choose a reason code that won't work.
We thought of purchasing to a perpetual "dummy" job and use
the Product Code to assign the expense account but that's a little messy
and poses other rproblems. Anyone else out there doing something
similar? I cannot accept that the only answer is to not have such parts
in the part master.
Greg Clauser
Lakin General Corporation
773-871-9604 FAX: 773-871-1265
gclauser@... <mailto:gclauser@...>
<mailto:gclauser@... <mailto:gclauser@...> >




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3313099.4604523.1261774/D=egroupweb/S=1705
0071
83:HM/A=1595055/R=0/*http://ashnin.com/clk/muryutaitakenattogyo?YH=33130
99&y
had=1595055> Click Here!

<http://us.adserver.yahoo.com/l?M=244522.3313099.4604523.1261774/D=egrou
pmai
l/S=:HM/A=1595055/rand=461204521>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



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/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/