MFG-VAR on closed jobs

Yahoo Archive
1
Wayne

I am assuming that you found the MFG-VAR on your inventory/wip report?
What is the reference, that usually can point you in the right direction to
determine where it came from?

At 03:18 PM 9/7/01 -0500, you wrote:
>We do use receiving inspection, but haven't encountered this because we use
>it as method to decide IF an outside services or material transaction can be
>paid. Until it is released from inspection, the invoice doesn't even get
>entered into Vantage, let alone paid.
>
>Yes, I was referring to back or post-dated transactions. Particularly, the
>miscellaneous charges where the ADJ-PUR transactions could be handled by
>Vantage much more effectively (accurately). Especially frustrating at month
>end, when the A/P clearing account is affected by prior month transactions,
>which are received in the prior month, invoice entered into a prior month
>group and posted with its prior month invoice date, but since the
>transaction is entered into the prior month group in the current month,
>Vantage posts the adjustment to the current month. An August receipt of
>8/31 is not going to have the invoice on site on 8/31 except in rare
>situations. Some August invoices will need to be entered in Sept. Such
>transactions really play havoc with GAAP, and balance sheet account
>reconciliation. Of course, one solution is to not enter 8/31 invoices after
>8/31 and just write G/L entries. I view that type of workaround thought
>process as a decade or so backwards and generally inadequate. Not
>reconciling the A/P clearing account at all, or not to the penny, are other
>options.
>But not good options. Call #720661MPS.
>
>We are on Version 4, but Support assures me that Version 5 behaves the same
>unacceptable way.
>
>Yup, the soap box is travelling again today. Sorry not to have helped find
>a clue to your mystery. Since your dates are reasonably close, it sounds
>like we'll need to look elsewhere. You use Last cost and the closed job was
>affected. Hmm. I'll have to think on it, haven't encountered it before.
>Have a good weekend.
>Deb
>
>-----Original Message-----
>From: Wayne Cox [mailto:wmc@...]
>Sent: Friday, September 07, 2001 1:54 PM
>To: vantage@yahoogroups.com
>Subject: RE: [Vantage] MFG-VAR on closed jobs
>
>
>At 02:13 PM 9/7/2001 , you wrote:
>>Have you already checked the system dates in Job Tracker, in addition to
>>the transaction dates?
>
>Yes, they are all reasonably close. No back- or post-dated transactions,
>if that's what you mean.
>
>> I've had trouble with how Vantage handles ADJ-PUR
>> transactions. Wondering if you are encountering similar difficulties
>> with MFG-VAR transactions.
>
>I found a really confusing thing with ADJ-PURs that might explain what
>you're seeing. Do you use receiving inspection? If the item is in
>inspection when the Adj-Pur is generated, the adjustment goes to the
>inspection GL account, rather then WIP or inventory. There's no flag in
>the PartTran record to tell which one it used, except the account number
>itself. If you try to sum up all the PartTran records for a job, you'll
>get a total that doesn't match the job's total, *unless* you exclude the
>ones that have the inspection inventory chart number.
>
> -Wayne
>
>
>[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/
>
2
Does anyone know why Vantage 4 would generate fresh MFG-VAR transactions on
a job that was closed many months ago? It still shows a close date in Jan
2001 (period long since closed) and there haven't been any other
transactions on the part number.

-Thanks,
Wayne Cox
3
This has happened to us. We have shipped off of a job that was closed for
over a year. Purchasing has also received subcontracting costs to a closed
job. Run a production detail report on the job and check the dates. I
would have hoped that if the job is closed, when you try to enter these
things it would at least warn you first that the job is closed.

Jeni Wilson
Boyer Machine

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, September 07, 2001 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MFG-VAR on closed jobs

Does anyone know why Vantage 4 would generate fresh MFG-VAR transactions on
a job that was closed many months ago? It still shows a close date in Jan
2001 (period long since closed) and there haven't been any other
transactions on the part number.

-Thanks,
Wayne Cox




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/
4
One example would be if a material of subcontract item had been received at
one cost and then in a later period, after the job is shipped and closed, it
is invoiced at another cost. The difference would create the MFG-VAR


-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, September 07, 2001 11:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MFG-VAR on closed jobs

Does anyone know why Vantage 4 would generate fresh MFG-VAR transactions on
a job that was closed many months ago? It still shows a close date in Jan
2001 (period long since closed) and there haven't been any other
transactions on the part number.

-Thanks,
Wayne Cox




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/
5
wayne, we had the same thing occur last month from clearing some 'received
but not invoiced' material receipts. my first clue in tracking this down
was from the production detail report, material transactions which were
dated in the period i was closing, even though in my case, the job had been
closed for 9 months. james

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, September 07, 2001 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MFG-VAR on closed jobs


Does anyone know why Vantage 4 would generate fresh MFG-VAR transactions on
a job that was closed many months ago? It still shows a close date in Jan
2001 (period long since closed) and there haven't been any other
transactions on the part number.

-Thanks,
Wayne Cox




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/
6
This is an interesting thread for us as we just converted to Standard Cost. Has anyone seen this closed job MFG-VAR transaction in Vantage 5.0?

Troy Funte
Liberty Electronics

----- Original Message -----
From: James Martin Jr.
To: 'vantage@yahoogroups.com'
Sent: Friday, September 07, 2001 11:37 AM
Subject: RE: [Vantage] MFG-VAR on closed jobs


wayne, we had the same thing occur last month from clearing some 'received
but not invoiced' material receipts. my first clue in tracking this down
was from the production detail report, material transactions which were
dated in the period i was closing, even though in my case, the job had been
closed for 9 months. james

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, September 07, 2001 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MFG-VAR on closed jobs


Does anyone know why Vantage 4 would generate fresh MFG-VAR transactions on
a job that was closed many months ago? It still shows a close date in Jan
2001 (period long since closed) and there haven't been any other
transactions on the part number.

-Thanks,
Wayne Cox




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/


Yahoo! Groups Sponsor



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.



[Non-text portions of this message have been removed]
7
Thanks for the input on the mystery Mfg-Var transactions. But none of the
situations suggested seem to apply here. I'm still stumped.

* There have been no shipments from the job, or *any* other transactions
for that part#, the the mfg-vars.
* No receiving or invoicing activity on it.
* No component or labor transactions on the PDR since 11/2000.
* Part is coded for last cost.
* The Mfg-Vars are all to assy 0, seq 0 of the job, no mention of any other
related documents or transactions.

Any other ideas?

-Thanks,
Wayne Cox
8
Wayne,

Does the production detail cost match up with the cost that shows in job
tracker? Are there any subcontract operations on the job?

Jim

> -----Original Message-----
> From: Wayne Cox [mailto:wmc@...]
> Sent: Friday, September 07, 2001 12:31 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MFG-VAR on closed jobs
>
>
> Thanks for the input on the mystery Mfg-Var transactions. But
> none of the
> situations suggested seem to apply here. I'm still stumped.
>
> * There have been no shipments from the job, or *any* other transactions
> for that part#, the the mfg-vars.
> * No receiving or invoicing activity on it.
> * No component or labor transactions on the PDR since 11/2000.
> * Part is coded for last cost.
> * The Mfg-Vars are all to assy 0, seq 0 of the job, no mention of
> any other
> related documents or transactions.
>
> Any other ideas?
>
> -Thanks,
> Wayne Cox
>
>
>
> 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
Have you already checked the system dates in Job Tracker, in addition to the
transaction dates? I've had trouble with how Vantage handles ADJ-PUR
transactions. Wondering if you are encountering similar difficulties with
MFG-VAR transactions.

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, September 07, 2001 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] MFG-VAR on closed jobs


Thanks for the input on the mystery Mfg-Var transactions. But none of the
situations suggested seem to apply here. I'm still stumped.

* There have been no shipments from the job, or *any* other transactions
for that part#, the the mfg-vars.
* No receiving or invoicing activity on it.
* No component or labor transactions on the PDR since 11/2000.
* Part is coded for last cost.
* The Mfg-Vars are all to assy 0, seq 0 of the job, no mention of any other
related documents or transactions.

Any other ideas?

-Thanks,
Wayne Cox




[Non-text portions of this message have been removed]
10
At 02:18 PM 9/7/2001 , you wrote:
>Does the production detail cost match up with the cost that shows in job
>tracker?

Yup. ALL my jobs do! :) But only after a massive effort over the last
month... but that's another long story.

>Are there any subcontract operations on the job?

Yes, a few on lower lever assys. They were all received & invoiced before
the job completed or closed.

-Wayne Cox
11
At 02:13 PM 9/7/2001 , you wrote:
>Have you already checked the system dates in Job Tracker, in addition to
>the transaction dates?

Yes, they are all reasonably close. No back- or post-dated transactions,
if that's what you mean.

> I've had trouble with how Vantage handles ADJ-PUR
> transactions. Wondering if you are encountering similar difficulties
> with MFG-VAR transactions.

I found a really confusing thing with ADJ-PURs that might explain what
you're seeing. Do you use receiving inspection? If the item is in
inspection when the Adj-Pur is generated, the adjustment goes to the
inspection GL account, rather then WIP or inventory. There's no flag in
the PartTran record to tell which one it used, except the account number
itself. If you try to sum up all the PartTran records for a job, you'll
get a total that doesn't match the job's total, *unless* you exclude the
ones that have the inspection inventory chart number.

-Wayne
12
We do use receiving inspection, but haven't encountered this because we use
it as method to decide IF an outside services or material transaction can be
paid. Until it is released from inspection, the invoice doesn't even get
entered into Vantage, let alone paid.

Yes, I was referring to back or post-dated transactions. Particularly, the
miscellaneous charges where the ADJ-PUR transactions could be handled by
Vantage much more effectively (accurately). Especially frustrating at month
end, when the A/P clearing account is affected by prior month transactions,
which are received in the prior month, invoice entered into a prior month
group and posted with its prior month invoice date, but since the
transaction is entered into the prior month group in the current month,
Vantage posts the adjustment to the current month. An August receipt of
8/31 is not going to have the invoice on site on 8/31 except in rare
situations. Some August invoices will need to be entered in Sept. Such
transactions really play havoc with GAAP, and balance sheet account
reconciliation. Of course, one solution is to not enter 8/31 invoices after
8/31 and just write G/L entries. I view that type of workaround thought
process as a decade or so backwards and generally inadequate. Not
reconciling the A/P clearing account at all, or not to the penny, are other
options.
But not good options. Call #720661MPS.

We are on Version 4, but Support assures me that Version 5 behaves the same
unacceptable way.

Yup, the soap box is travelling again today. Sorry not to have helped find
a clue to your mystery. Since your dates are reasonably close, it sounds
like we'll need to look elsewhere. You use Last cost and the closed job was
affected. Hmm. I'll have to think on it, haven't encountered it before.
Have a good weekend.
Deb

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Friday, September 07, 2001 1:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MFG-VAR on closed jobs


At 02:13 PM 9/7/2001 , you wrote:
>Have you already checked the system dates in Job Tracker, in addition to
>the transaction dates?

Yes, they are all reasonably close. No back- or post-dated transactions,
if that's what you mean.

> I've had trouble with how Vantage handles ADJ-PUR
> transactions. Wondering if you are encountering similar difficulties
> with MFG-VAR transactions.

I found a really confusing thing with ADJ-PURs that might explain what
you're seeing. Do you use receiving inspection? If the item is in
inspection when the Adj-Pur is generated, the adjustment goes to the
inspection GL account, rather then WIP or inventory. There's no flag in
the PartTran record to tell which one it used, except the account number
itself. If you try to sum up all the PartTran records for a job, you'll
get a total that doesn't match the job's total, *unless* you exclude the
ones that have the inspection inventory chart number.

-Wayne


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