Help with Purchase Price Variance Report

Yahoo Archive
1
Rob/Reggie



To track down PPV, you have the Transaction Detail Report and the
INV/WIP reconciliation report. Filter either of them by transaction
type ADJ-PUR.

They do just give you the variance and not the two actual but it's a
start.

If required, you can modify/write the periodic posting cost detail into
the general ledger report give the extra information you might need



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of robertb_versa@...
Sent: 16 May 2009 19:53
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Help with Purchase Price Variance Report.








Reggie,
I'm cleaning out my inbox & don't see any replies to your question.
To my knowledge no native PPV report exists. One area I can't speak from
memory on though is the costing tools.
I would think (to support Average Cost defined parts) that some type of
PPV like actual cost history display tools might exist.
If you find nothing suitable, it should be a fairly simple BAQ report to
write. Your decision to make would be whether to base it on PartTrans
receipt record listed cost (PO cost based) or actual Invoiced cost of
receipts. (Just a few additional tables to add to the BAQ.)
Rob

--- Original Message ---
From:"bjcracosta" <racosta@...
<mailto:racosta%40brownjordan.com> >
Sent:Fri 5/8/09 4:54 pm
To:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subj:[Vantage] Help with Purchase Price Variance Report.

As far as I can tell, Vantage doesn't have a canned PPV report. We are
on v8.03.406A. I am still learning the Vantage database and don't know
which tables and fields are needed to create a PPV report. Any help with
a BAQ or crystal report will be appreciated.

Thanks,
Reggie Acosta





[Non-text portions of this message have been removed]
2
As far as I can tell, Vantage doesn't have a canned PPV report. We are on v8.03.406A. I am still learning the Vantage database and don't know which tables and fields are needed to create a PPV report. Any help with a BAQ or crystal report will be appreciated.

Thanks,
Reggie Acosta
3
Reggie,
Take a look under the system management for the data dictionary to see all of the tables. The PPV would show up based on how you have set up the part class, and the accounts that you have it pointing to.
GL transactions? A quick BAQ could check that area.


Brz in Minneapolis.

--- In vantage@yahoogroups.com, "bjcracosta" <racosta@...> wrote:
>
> As far as I can tell, Vantage doesn't have a canned PPV report. We are on v8.03.406A. I am still learning the Vantage database and don't know which tables and fields are needed to create a PPV report. Any help with a BAQ or crystal report will be appreciated.
>
> Thanks,
> Reggie Acosta
>
4
Reggie,
I'm cleaning out my inbox & don't see any replies to your question.
To my knowledge no native PPV report exists. One area I can't speak from memory on though is the costing tools.
I would think (to support Average Cost defined parts) that some type of PPV like actual cost history display tools might exist.
If you find nothing suitable, it should be a fairly simple BAQ report to write. Your decision to make would be whether to base it on PartTrans receipt record listed cost (PO cost based) or actual Invoiced cost of receipts. (Just a few additional tables to add to the BAQ.)
Rob

--- Original Message ---
From:"bjcracosta" <racosta@...>
Sent:Fri 5/8/09 4:54 pm
To:vantage@yahoogroups.com
Subj:[Vantage] Help with Purchase Price Variance Report.

As far as I can tell, Vantage doesn't have a canned PPV report. We are on v8.03.406A. I am still learning the Vantage database and don't know which tables and fields are needed to create a PPV report. Any help with a BAQ or crystal report will be appreciated.

Thanks,
Reggie Acosta