Setting up a part as make AND buy

Yahoo Archive
1
Hi,

We have the same scenario where we buy a material for a particular job,
but sometimes we have to make this material in house. The way we got
around this was to simply have 2 revisions for the parent part. We have
revision A and revision B. A is the purchased material or sub-assembly
and B is the manufactured material or sub-assembly. If we choose to
manufacture the material, we will unapprove revision A and have revision
B approved. If we purchase the material we approve rev A and unapprove
rev B. This will allow the planner to only select the approved method
when getting the details for the job in Job Entry.

We are using 8.00.810C so I am not sure how different this might be in
8.03.



Hope this helps,



Cheers,





Jason Abramczyk

Quality / HR Co-ordinator



Precision Parts

5 Say st,

Wagga Wagga,

N.S.W, 2650

Australia



Ph: 02 6937 8800

Fax: 02 6921 7536

Email: jasona@...

WEB: www.precisionparts.com.au <http://www.precisionparts.com.au/>



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ed Ortiz
Sent: Wednesday, 14 March 2007 9:18 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Setting up a part as make AND buy



Hi Joe!

What we would do in your case would be to create two part numbers one
purchased and the other manufactured. Then we would create an "Alternate
Method of Manufacturing" which is a sub-revision of an existing revision
for the assembly where this part is used.

Then when you release the job you can pick which MOM to use. The basic
revision or the alternate method.

I hope this helps.

Ed Ortiz
Sr. Project Engineer
Manitex
Georgetown

Joe Rojas <jrojas@... <mailto:jrojas%40tnco-inc.com> > wrote:
Hello,

Vantage 8.03.

We have a part that we currently outsource but we have the capability to
manufacture in-house.

Ideally it would be nice to have this part setup so that it can be
purchased as well as manufactured.

How do others deal with situation?

We were thinking of having two part numbers, one for buy and one for
make, and have production control change the job materials accordingly
but we can't figure out how to deal with this from a regulatory stand
point where the MOM for a part that using this part can only refer to
one of two parts.

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

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





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





[Non-text portions of this message have been removed]
2
I am trying to come up with an inventory roll forward report and I just
can't find a good way to come up with the amount of inventory purchased.
Beginning inventory plus purchase (to wip & to raw) less cost of goods
sold should be ending inventory.. I just can't come up with a good way
to tally up the purchases. I have been trying to use the Material
Transactions Detail Report and that just doesn't work either. I am
hoping that some one has done this before and know what I am doing
wrong???!!!!

Stephanie





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

Not sure if I follow totally. But to track purchase cost and their
reflection in the gl. Then report on the part-trans table. Using PUR-
STK. Depending on your costing model then you would need to look at
ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-QTY.
You can track this down to lot level.

If you are average costing then it could be become a bit more
complicated. This is largely down to the timing issue with average
costing.

All things being equal, you should be able to right a report on the
part-trans table which matches off with the stock status report.

I hope this helps but not sure if it does.

--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...>
wrote:
>
> I am trying to come up with an inventory roll forward report and I
just
> can't find a good way to come up with the amount of inventory
purchased.
> Beginning inventory plus purchase (to wip & to raw) less cost of
goods
> sold should be ending inventory.. I just can't come up with a
good way
> to tally up the purchases. I have been trying to use the Material
> Transactions Detail Report and that just doesn't work either. I am
> hoping that some one has done this before and know what I am doing
> wrong???!!!!
>
> Stephanie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Yeah I tried this but it still doesn't add up. Not even close. But my
reconciliations tie out to within a few dollars...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Sunday, March 11, 2007 5:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report



Hi,

Not sure if I follow totally. But to track purchase cost and their
reflection in the gl. Then report on the part-trans table. Using PUR-
STK. Depending on your costing model then you would need to look at
ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-QTY.
You can track this down to lot level.

If you are average costing then it could be become a bit more
complicated. This is largely down to the timing issue with average
costing.

All things being equal, you should be able to right a report on the
part-trans table which matches off with the stock status report.

I hope this helps but not sure if it does.






[Non-text portions of this message have been removed]
5
This is possible, I have written a corvu report to tie the part trans
into the stock status report. I primarily wrote to identify bugs in
the costing routines, which have been fixed now. I am sorry but not
quite sure what you are trying to achieve.

In a simple example base on one GL raw stock account;

Month 1 Month2 Month3
Stock Balance 10000 9000 15000
Purchase to Stock 0 2000 7000
Purchase to WIP 0 50 0
Issue to WIP 0 -3000 1000

Are you trying to track through the transactions against the stock
account to reach the 15,000?

As your reconciliations tie out then the inventory ledger is correct,
unless there are manual journals in there some where which would
offset any report based on the part trans table.




--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> Yeah I tried this but it still doesn't add up. Not even close.
But my
> reconciliations tie out to within a few dollars...
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brychanwilliams
> Sent: Sunday, March 11, 2007 5:13 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> Hi,
>
> Not sure if I follow totally. But to track purchase cost and their
> reflection in the gl. Then report on the part-trans table. Using
PUR-
> STK. Depending on your costing model then you would need to look at
> ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-QTY.
> You can track this down to lot level.
>
> If you are average costing then it could be become a bit more
> complicated. This is largely down to the timing issue with average
> costing.
>
> All things being equal, you should be able to right a report on the
> part-trans table which matches off with the stock status report.
>
> I hope this helps but not sure if it does.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Well we are an average costing company with some parts going to storage
and some shipping from manufacturing. And the inventory roll would
include raw material and wip. So we are dealing with burden as well.

So I am adding the change in raw, wip material, and cost of sales
material, wip subcontract, and cost of sales subcontract plus overhead
and direct labor - then subtracting cost of sales - this should be the
change in the total inventory amount but it isn't. I think the problem
is in the fact that some items are being shipped from FG so then you are
adding the material twice but the calculation for that isn't the
difference. So I am looking for some other problem with the theory.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Tuesday, March 13, 2007 9:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report



This is possible, I have written a corvu report to tie the part trans
into the stock status report. I primarily wrote to identify bugs in
the costing routines, which have been fixed now. I am sorry but not
quite sure what you are trying to achieve.

In a simple example base on one GL raw stock account;

Month 1 Month2 Month3
Stock Balance 10000 9000 15000
Purchase to Stock 0 2000 7000
Purchase to WIP 0 50 0
Issue to WIP 0 -3000 1000

Are you trying to track through the transactions against the stock
account to reach the 15,000?

As your reconciliations tie out then the inventory ledger is correct,
unless there are manual journals in there some where which would
offset any report based on the part trans table.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Geary, Stephanie" <sgeary@...> wrote:
>
> Yeah I tried this but it still doesn't add up. Not even close.
But my
> reconciliations tie out to within a few dollars...
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of brychanwilliams
> Sent: Sunday, March 11, 2007 5:13 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> Hi,
>
> Not sure if I follow totally. But to track purchase cost and their
> reflection in the gl. Then report on the part-trans table. Using
PUR-
> STK. Depending on your costing model then you would need to look at
> ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-QTY.
> You can track this down to lot level.
>
> If you are average costing then it could be become a bit more
> complicated. This is largely down to the timing issue with average
> costing.
>
> All things being equal, you should be able to right a report on the
> part-trans table which matches off with the stock status report.
>
> I hope this helps but not sure if it does.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>


This message has been processed via your triumphgroup.com e-mail
address.



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



Vantage 8.03.



We have a part that we currently outsource but we have the capability to
manufacture in-house.

Ideally it would be nice to have this part setup so that it can be
purchased as well as manufactured.



How do others deal with situation?



We were thinking of having two part numbers, one for buy and one for
make, and have production control change the job materials accordingly
but we can't figure out how to deal with this from a regulatory stand
point where the MOM for a part that using this part can only refer to
one of two parts.



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



[Non-text portions of this message have been removed]
8
Interesting and complicated. Does your calculation work out at the GL
level? How are you calculation the value changes?

Is there anything else that might affect inventory such as inspection
routines, manufacturing variances etc. If you are reporting off the
Part trans and trying to tie back to a GL balance then ensure that
everything has been captured and you are only using records marked as
GL posted, I got caught out on that.

--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> Well we are an average costing company with some parts going to
storage
> and some shipping from manufacturing. And the inventory roll would
> include raw material and wip. So we are dealing with burden as
well.
>
> So I am adding the change in raw, wip material, and cost of sales
> material, wip subcontract, and cost of sales subcontract plus
overhead
> and direct labor - then subtracting cost of sales - this should be
the
> change in the total inventory amount but it isn't. I think the
problem
> is in the fact that some items are being shipped from FG so then
you are
> adding the material twice but the calculation for that isn't the
> difference. So I am looking for some other problem with the theory.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brychanwilliams
> Sent: Tuesday, March 13, 2007 9:24 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> This is possible, I have written a corvu report to tie the part
trans
> into the stock status report. I primarily wrote to identify bugs in
> the costing routines, which have been fixed now. I am sorry but not
> quite sure what you are trying to achieve.
>
> In a simple example base on one GL raw stock account;
>
> Month 1 Month2 Month3
> Stock Balance 10000 9000 15000
> Purchase to Stock 0 2000 7000
> Purchase to WIP 0 50 0
> Issue to WIP 0 -3000 1000
>
> Are you trying to track through the transactions against the stock
> account to reach the 15,000?
>
> As your reconciliations tie out then the inventory ledger is
correct,
> unless there are manual journals in there some where which would
> offset any report based on the part trans table.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Geary, Stephanie" <sgeary@> wrote:
> >
> > Yeah I tried this but it still doesn't add up. Not even close.
> But my
> > reconciliations tie out to within a few dollars...
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of brychanwilliams
> > Sent: Sunday, March 11, 2007 5:13 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
> >
> >
> >
> > Hi,
> >
> > Not sure if I follow totally. But to track purchase cost and
their
> > reflection in the gl. Then report on the part-trans table. Using
> PUR-
> > STK. Depending on your costing model then you would need to look
at
> > ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-
QTY.
> > You can track this down to lot level.
> >
> > If you are average costing then it could be become a bit more
> > complicated. This is largely down to the timing issue with
average
> > costing.
> >
> > All things being equal, you should be able to right a report on
the
> > part-trans table which matches off with the stock status report.
> >
> > I hope this helps but not sure if it does.
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
>
>
> [Non-text portions of this message have been removed]
>
9
The change is coming from the change in the account balances so I don't
think it could be anything that doesn't get posted. So it takes the
debits less the credits to come up with the change. It all makes sense
logically it just doesn't tie out. I created a financial report in
Vantage to calculate this on a monthly basis. We do use the Quality
Module but the changes in those accounts do not equal the variance that
I have. I just don't know if it is something that I can come up with
inside of Vantage because we ship from storage and manufacturing and
parts put in storage could have been put to stores in the current month
or a prior month. Burden and Labor being part of inventory for Finished
Goods but not part of material as far as Cost of Sales.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Tuesday, March 13, 2007 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report



Interesting and complicated. Does your calculation work out at the GL
level? How are you calculation the value changes?

Is there anything else that might affect inventory such as inspection
routines, manufacturing variances etc. If you are reporting off the
Part trans and trying to tie back to a GL balance then ensure that
everything has been captured and you are only using records marked as
GL posted, I got caught out on that.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Geary, Stephanie" <sgeary@...> wrote:
>
> Well we are an average costing company with some parts going to
storage
> and some shipping from manufacturing. And the inventory roll would
> include raw material and wip. So we are dealing with burden as
well.
>
> So I am adding the change in raw, wip material, and cost of sales
> material, wip subcontract, and cost of sales subcontract plus
overhead
> and direct labor - then subtracting cost of sales - this should be
the
> change in the total inventory amount but it isn't. I think the
problem
> is in the fact that some items are being shipped from FG so then
you are
> adding the material twice but the calculation for that isn't the
> difference. So I am looking for some other problem with the theory.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of brychanwilliams
> Sent: Tuesday, March 13, 2007 9:24 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> This is possible, I have written a corvu report to tie the part
trans
> into the stock status report. I primarily wrote to identify bugs in
> the costing routines, which have been fixed now. I am sorry but not
> quite sure what you are trying to achieve.
>
> In a simple example base on one GL raw stock account;
>
> Month 1 Month2 Month3
> Stock Balance 10000 9000 15000
> Purchase to Stock 0 2000 7000
> Purchase to WIP 0 50 0
> Issue to WIP 0 -3000 1000
>
> Are you trying to track through the transactions against the stock
> account to reach the 15,000?
>
> As your reconciliations tie out then the inventory ledger is
correct,
> unless there are manual journals in there some where which would
> offset any report based on the part trans table.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Geary, Stephanie" <sgeary@> wrote:
> >
> > Yeah I tried this but it still doesn't add up. Not even close.
> But my
> > reconciliations tie out to within a few dollars...
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of brychanwilliams
> > Sent: Sunday, March 11, 2007 5:13 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
> >
> >
> >
> > Hi,
> >
> > Not sure if I follow totally. But to track purchase cost and
their
> > reflection in the gl. Then report on the part-trans table. Using
> PUR-
> > STK. Depending on your costing model then you would need to look
at
> > ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-
QTY.
> > You can track this down to lot level.
> >
> > If you are average costing then it could be become a bit more
> > complicated. This is largely down to the timing issue with
average
> > costing.
> >
> > All things being equal, you should be able to right a report on
the
> > part-trans table which matches off with the stock status report.
> >
> > I hope this helps but not sure if it does.
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
>
>
> [Non-text portions of this message have been removed]
>


This message has been processed via your triumphgroup.com e-mail
address.



[Non-text portions of this message have been removed]
10
Hi Joe!

What we would do in your case would be to create two part numbers one purchased and the other manufactured. Then we would create an "Alternate Method of Manufacturing" which is a sub-revision of an existing revision for the assembly where this part is used.

Then when you release the job you can pick which MOM to use. The basic revision or the alternate method.

I hope this helps.

Ed Ortiz
Sr. Project Engineer
Manitex
Georgetown


Joe Rojas <jrojas@...> wrote: Hello,

Vantage 8.03.

We have a part that we currently outsource but we have the capability to
manufacture in-house.

Ideally it would be nice to have this part setup so that it can be
purchased as well as manufactured.

How do others deal with situation?

We were thinking of having two part numbers, one for buy and one for
make, and have production control change the job materials accordingly
but we can't figure out how to deal with this from a regulatory stand
point where the MOM for a part that using this part can only refer to
one of two parts.

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...

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






[Non-text portions of this message have been removed]
11
We have the same situation, where we are able to manufacture some of the
parts we buy.

We use one part number, and leave it set as purchased. We attach a MOM
to the part. Because we leave it as purchased, MRP suggestions are to
buy, not manufacture. If the decision is made to manufacture a part, we
are able to raise a job to do so, using the attached MOM, and the
purchasing suggestion will go away.

The only drawback is costing, you need to set your standard cost to one
or the other, so you will get variances when using these materials or
putting them into stock. This is an inconvenience to us, compared to the
ability to keep the MOM on record, and raise a job simply, without
having to change part numbers in parent MOM's to make it work.

Hope my explanation isn't too unclear!



Stuart Noble
Thompson Meat Machinery


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, 13 March 2007 11:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Setting up a part as make AND buy



Hello,

Vantage 8.03.

We have a part that we currently outsource but we have the capability to
manufacture in-house.

Ideally it would be nice to have this part setup so that it can be
purchased as well as manufactured.

How do others deal with situation?

We were thinking of having two part numbers, one for buy and one for
make, and have production control change the job materials accordingly
but we can't figure out how to deal with this from a regulatory stand
point where the MOM for a part that using this part can only refer to
one of two parts.

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>





[Non-text portions of this message have been removed]
12
Can you tie out your raw material account? Can you do the same on the
other accounts?

The other option is to run the Inv-wip report on all the accounts and
see what transaction types are being used. This should tie out to
your gl balances if everything is posted.


--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> The change is coming from the change in the account balances so I
don't
> think it could be anything that doesn't get posted. So it takes the
> debits less the credits to come up with the change. It all makes
sense
> logically it just doesn't tie out. I created a financial report in
> Vantage to calculate this on a monthly basis. We do use the Quality
> Module but the changes in those accounts do not equal the variance
that
> I have. I just don't know if it is something that I can come up
with
> inside of Vantage because we ship from storage and manufacturing and
> parts put in storage could have been put to stores in the current
month
> or a prior month. Burden and Labor being part of inventory for
Finished
> Goods but not part of material as far as Cost of Sales.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brychanwilliams
> Sent: Tuesday, March 13, 2007 10:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> Interesting and complicated. Does your calculation work out at the
GL
> level? How are you calculation the value changes?
>
> Is there anything else that might affect inventory such as
inspection
> routines, manufacturing variances etc. If you are reporting off the
> Part trans and trying to tie back to a GL balance then ensure that
> everything has been captured and you are only using records marked
as
> GL posted, I got caught out on that.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Geary, Stephanie" <sgeary@> wrote:
> >
> > Well we are an average costing company with some parts going to
> storage
> > and some shipping from manufacturing. And the inventory roll would
> > include raw material and wip. So we are dealing with burden as
> well.
> >
> > So I am adding the change in raw, wip material, and cost of sales
> > material, wip subcontract, and cost of sales subcontract plus
> overhead
> > and direct labor - then subtracting cost of sales - this should
be
> the
> > change in the total inventory amount but it isn't. I think the
> problem
> > is in the fact that some items are being shipped from FG so then
> you are
> > adding the material twice but the calculation for that isn't the
> > difference. So I am looking for some other problem with the
theory.
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of brychanwilliams
> > Sent: Tuesday, March 13, 2007 9:24 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
> >
> >
> >
> > This is possible, I have written a corvu report to tie the part
> trans
> > into the stock status report. I primarily wrote to identify bugs
in
> > the costing routines, which have been fixed now. I am sorry but
not
> > quite sure what you are trying to achieve.
> >
> > In a simple example base on one GL raw stock account;
> >
> > Month 1 Month2 Month3
> > Stock Balance 10000 9000 15000
> > Purchase to Stock 0 2000 7000
> > Purchase to WIP 0 50 0
> > Issue to WIP 0 -3000 1000
> >
> > Are you trying to track through the transactions against the
stock
> > account to reach the 15,000?
> >
> > As your reconciliations tie out then the inventory ledger is
> correct,
> > unless there are manual journals in there some where which would
> > offset any report based on the part trans table.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Geary, Stephanie" <sgeary@> wrote:
> > >
> > > Yeah I tried this but it still doesn't add up. Not even close.
> > But my
> > > reconciliations tie out to within a few dollars...
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > > Of brychanwilliams
> > > Sent: Sunday, March 11, 2007 5:13 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward
Report
> > >
> > >
> > >
> > > Hi,
> > >
> > > Not sure if I follow totally. But to track purchase cost and
> their
> > > reflection in the gl. Then report on the part-trans table.
Using
> > PUR-
> > > STK. Depending on your costing model then you would need to
look
> at
> > > ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-
> QTY.
> > > You can track this down to lot level.
> > >
> > > If you are average costing then it could be become a bit more
> > > complicated. This is largely down to the timing issue with
> average
> > > costing.
> > >
> > > All things being equal, you should be able to right a report on
> the
> > > part-trans table which matches off with the stock status report.
> > >
> > > I hope this helps but not sure if it does.
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> > This message has been processed via your triumphgroup.com e-mail
> > address.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
>
>
> [Non-text portions of this message have been removed]
>
13
I can account for everything flowing through the accounts through access
adjusting for journal entries but I just can't figure a way to do it
with financial reports in vantage. It has to be the way FG are handled.
Labor and Burden being a part of Inventory as a whole and then broken
back out as they are shipped. I just don't think there is anyway to
define that kind of a sort in Vantage.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Wednesday, March 14, 2007 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report



Can you tie out your raw material account? Can you do the same on the
other accounts?

The other option is to run the Inv-wip report on all the accounts and
see what transaction types are being used. This should tie out to
your gl balances if everything is posted.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Geary, Stephanie" <sgeary@...> wrote:
>
> The change is coming from the change in the account balances so I
don't
> think it could be anything that doesn't get posted. So it takes the
> debits less the credits to come up with the change. It all makes
sense
> logically it just doesn't tie out. I created a financial report in
> Vantage to calculate this on a monthly basis. We do use the Quality
> Module but the changes in those accounts do not equal the variance
that
> I have. I just don't know if it is something that I can come up
with
> inside of Vantage because we ship from storage and manufacturing and
> parts put in storage could have been put to stores in the current
month
> or a prior month. Burden and Labor being part of inventory for
Finished
> Goods but not part of material as far as Cost of Sales.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of brychanwilliams
> Sent: Tuesday, March 13, 2007 10:50 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> Interesting and complicated. Does your calculation work out at the
GL
> level? How are you calculation the value changes?
>
> Is there anything else that might affect inventory such as
inspection
> routines, manufacturing variances etc. If you are reporting off the
> Part trans and trying to tie back to a GL balance then ensure that
> everything has been captured and you are only using records marked
as
> GL posted, I got caught out on that.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Geary, Stephanie" <sgeary@> wrote:
> >
> > Well we are an average costing company with some parts going to
> storage
> > and some shipping from manufacturing. And the inventory roll would
> > include raw material and wip. So we are dealing with burden as
> well.
> >
> > So I am adding the change in raw, wip material, and cost of sales
> > material, wip subcontract, and cost of sales subcontract plus
> overhead
> > and direct labor - then subtracting cost of sales - this should
be
> the
> > change in the total inventory amount but it isn't. I think the
> problem
> > is in the fact that some items are being shipped from FG so then
> you are
> > adding the material twice but the calculation for that isn't the
> > difference. So I am looking for some other problem with the
theory.
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of brychanwilliams
> > Sent: Tuesday, March 13, 2007 9:24 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
> >
> >
> >
> > This is possible, I have written a corvu report to tie the part
> trans
> > into the stock status report. I primarily wrote to identify bugs
in
> > the costing routines, which have been fixed now. I am sorry but
not
> > quite sure what you are trying to achieve.
> >
> > In a simple example base on one GL raw stock account;
> >
> > Month 1 Month2 Month3
> > Stock Balance 10000 9000 15000
> > Purchase to Stock 0 2000 7000
> > Purchase to WIP 0 50 0
> > Issue to WIP 0 -3000 1000
> >
> > Are you trying to track through the transactions against the
stock
> > account to reach the 15,000?
> >
> > As your reconciliations tie out then the inventory ledger is
> correct,
> > unless there are manual journals in there some where which would
> > offset any report based on the part trans table.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Geary, Stephanie" <sgeary@> wrote:
> > >
> > > Yeah I tried this but it still doesn't add up. Not even close.
> > But my
> > > reconciliations tie out to within a few dollars...
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > > Of brychanwilliams
> > > Sent: Sunday, March 11, 2007 5:13 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward
Report
> > >
> > >
> > >
> > > Hi,
> > >
> > > Not sure if I follow totally. But to track purchase cost and
> their
> > > reflection in the gl. Then report on the part-trans table.
Using
> > PUR-
> > > STK. Depending on your costing model then you would need to
look
> at
> > > ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-
> QTY.
> > > You can track this down to lot level.
> > >
> > > If you are average costing then it could be become a bit more
> > > complicated. This is largely down to the timing issue with
> average
> > > costing.
> > >
> > > All things being equal, you should be able to right a report on
> the
> > > part-trans table which matches off with the stock status report.
> > >
> > > I hope this helps but not sure if it does.
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> > This message has been processed via your triumphgroup.com e-mail
> > address.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
>
>
> [Non-text portions of this message have been removed]
>


This message has been processed via your triumphgroup.com e-mail
address.



[Non-text portions of this message have been removed]
14
I think you right using the financial report designer in vantage.
Does it have to be in the financial report designer?

--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> I can account for everything flowing through the accounts through
access
> adjusting for journal entries but I just can't figure a way to do it
> with financial reports in vantage. It has to be the way FG are
handled.
> Labor and Burden being a part of Inventory as a whole and then
broken
> back out as they are shipped. I just don't think there is anyway to
> define that kind of a sort in Vantage.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brychanwilliams
> Sent: Wednesday, March 14, 2007 9:46 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
>
>
>
> Can you tie out your raw material account? Can you do the same on
the
> other accounts?
>
> The other option is to run the Inv-wip report on all the accounts
and
> see what transaction types are being used. This should tie out to
> your gl balances if everything is posted.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Geary, Stephanie" <sgeary@> wrote:
> >
> > The change is coming from the change in the account balances so I
> don't
> > think it could be anything that doesn't get posted. So it takes
the
> > debits less the credits to come up with the change. It all makes
> sense
> > logically it just doesn't tie out. I created a financial report in
> > Vantage to calculate this on a monthly basis. We do use the
Quality
> > Module but the changes in those accounts do not equal the
variance
> that
> > I have. I just don't know if it is something that I can come up
> with
> > inside of Vantage because we ship from storage and manufacturing
and
> > parts put in storage could have been put to stores in the current
> month
> > or a prior month. Burden and Labor being part of inventory for
> Finished
> > Goods but not part of material as far as Cost of Sales.
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of brychanwilliams
> > Sent: Tuesday, March 13, 2007 10:50 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report
> >
> >
> >
> > Interesting and complicated. Does your calculation work out at
the
> GL
> > level? How are you calculation the value changes?
> >
> > Is there anything else that might affect inventory such as
> inspection
> > routines, manufacturing variances etc. If you are reporting off
the
> > Part trans and trying to tie back to a GL balance then ensure
that
> > everything has been captured and you are only using records
marked
> as
> > GL posted, I got caught out on that.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Geary, Stephanie" <sgeary@> wrote:
> > >
> > > Well we are an average costing company with some parts going to
> > storage
> > > and some shipping from manufacturing. And the inventory roll
would
> > > include raw material and wip. So we are dealing with burden as
> > well.
> > >
> > > So I am adding the change in raw, wip material, and cost of
sales
> > > material, wip subcontract, and cost of sales subcontract plus
> > overhead
> > > and direct labor - then subtracting cost of sales - this should
> be
> > the
> > > change in the total inventory amount but it isn't. I think the
> > problem
> > > is in the fact that some items are being shipped from FG so
then
> > you are
> > > adding the material twice but the calculation for that isn't the
> > > difference. So I am looking for some other problem with the
> theory.
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > > Of brychanwilliams
> > > Sent: Tuesday, March 13, 2007 9:24 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward
Report
> > >
> > >
> > >
> > > This is possible, I have written a corvu report to tie the part
> > trans
> > > into the stock status report. I primarily wrote to identify
bugs
> in
> > > the costing routines, which have been fixed now. I am sorry but
> not
> > > quite sure what you are trying to achieve.
> > >
> > > In a simple example base on one GL raw stock account;
> > >
> > > Month 1 Month2 Month3
> > > Stock Balance 10000 9000 15000
> > > Purchase to Stock 0 2000 7000
> > > Purchase to WIP 0 50 0
> > > Issue to WIP 0 -3000 1000
> > >
> > > Are you trying to track through the transactions against the
> stock
> > > account to reach the 15,000?
> > >
> > > As your reconciliations tie out then the inventory ledger is
> > correct,
> > > unless there are manual journals in there some where which
would
> > > offset any report based on the part trans table.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Geary, Stephanie" <sgeary@> wrote:
> > > >
> > > > Yeah I tried this but it still doesn't add up. Not even
close.
> > > But my
> > > > reconciliations tie out to within a few dollars...
> > > >
> > > >
> > > >
> > > > ________________________________
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%
> > 40yahoogroups.com> ] On
> > > Behalf
> > > > Of brychanwilliams
> > > > Sent: Sunday, March 11, 2007 5:13 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward
> Report
> > > >
> > > >
> > > >
> > > > Hi,
> > > >
> > > > Not sure if I follow totally. But to track purchase cost and
> > their
> > > > reflection in the gl. Then report on the part-trans table.
> Using
> > > PUR-
> > > > STK. Depending on your costing model then you would need to
> look
> > at
> > > > ADJ-CST and ADJ_PUR. Any stock takes should be covered by ADJ-
> > QTY.
> > > > You can track this down to lot level.
> > > >
> > > > If you are average costing then it could be become a bit more
> > > > complicated. This is largely down to the timing issue with
> > average
> > > > costing.
> > > >
> > > > All things being equal, you should be able to right a report
on
> > the
> > > > part-trans table which matches off with the stock status
report.
> > > >
> > > > I hope this helps but not sure if it does.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > > This message has been processed via your triumphgroup.com e-mail
> > > address.
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> > This message has been processed via your triumphgroup.com e-mail
> > address.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
>
>
> [Non-text portions of this message have been removed]
>
15
No. It is just that I am an accountant not a computer person. So I
fumble a little. I was going to try and do it all in Access. Just
don't know if I can find all the information the way I need.





[Non-text portions of this message have been removed]
16
I think it is certainly possible through some sort of reporting
application , whether it would be access or whatever. Do you have corvu
at your company?

--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> No. It is just that I am an accountant not a computer person. So I
> fumble a little. I was going to try and do it all in Access. Just
> don't know if I can find all the information the way I need.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
17
No. I don't even know what it is.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Wednesday, March 14, 2007 12:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1 - Inventory Rollforward Report



I think it is certainly possible through some sort of reporting
application , whether it would be access or whatever. Do you have corvu
at your company?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Geary, Stephanie" <sgeary@...> wrote:
>
> No. It is just that I am an accountant not a computer person. So I
> fumble a little. I was going to try and do it all in Access. Just
> don't know if I can find all the information the way I need.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>


This message has been processed via your triumphgroup.com e-mail
address.



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