VBI query for spend with supplier

Yahoo Archive
1
Hi,

There is a canned report called AP Historical by Vendor/Year/Period.
This would be a good starting point. The Problem with doing it from
the PO side is a timing one. Firstly the PO order date can be changed
by the user and PO can be changed while it is open. Using the AP
Invoice will at least tie with the accounts.

--- In vantage@yahoogroups.com, "Kunze, Kim" <kkunze@...> wrote:
>
> Has anyone done any VBI queries for determining the spend with a
vendor
> for a specific time period? I've looked at it from both the
Purchase
> Order side as well as the AP side and am asking if your experience
> suggests one approach vs. the other? I'm also hoping to find
someone
> willing to share the query or at least some initial guidance. In
our
> environment I need to include the misc header and line charges for
each
> PO as well. My initial thought was that approaching from the AP
side
> would be less complicated than the PO side. I'm only interested in
the
> total po price in determining the total spend.
>
>
>
> Thanks.
>
>
>
> Kim Kunze
>
> 715-846-3244
>
>
>
> [Non-text portions of this message have been removed]
>
2
Has anyone done any VBI queries for determining the spend with a vendor
for a specific time period? I've looked at it from both the Purchase
Order side as well as the AP side and am asking if your experience
suggests one approach vs. the other? I'm also hoping to find someone
willing to share the query or at least some initial guidance. In our
environment I need to include the misc header and line charges for each
PO as well. My initial thought was that approaching from the AP side
would be less complicated than the PO side. I'm only interested in the
total po price in determining the total spend.



Thanks.



Kim Kunze

715-846-3244



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