[Vantage 8.03] ARInvoice Line Cost

Yep, it sure is there. Right in Invcdtl. I looked there before but i
must have just skimmed over it. Thanks for the help!


--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Its located in the Invcdtl tables as elemental unit costs. Multiply
> this by the ship qty.
>
> Gary Parfrey
>
The AR Invoice tables show the line selling price to the customer but
do not display our cost of the part. Does anyone know where the cost
is located? When you run the Sales Gross Margin report it displays
the Total Cost. I looked in the report definition but the cost that
it displays is from a calculated field, so i am not able to see what
Vantage uses to calculate this. Does anyone have any ideas?
> The AR Invoice tables show the line selling price to the customer but
> do not display our cost of the part. Does anyone know where the cost
> is located? When you run the Sales Gross Margin report it displays
> the Total Cost. I looked in the report definition but the cost that
> it displays is from a calculated field, so i am not able to see what
> Vantage uses to calculate this. Does anyone have any ideas?

What costing system(s) are you using (STD, AVG, ...)?

Are you shipping directly from Jobs?

Mark W.
We are using avg costing method, always shipping from inventory.


> What costing system(s) are you using (STD, AVG, ...)?
>
> Are you shipping directly from Jobs?
>
> Mark W.
>
>
> We are using avg costing method, always shipping from inventory.
>

I'm not as familiar with average costing but I would assume that whatever the
average cost *at the time of shipping* would be the cost in the Invoice Line
record. If other receipts occur after shipping, the average cost would be
updated if I understand average-costing. The cost used should be visible in
the Part Transaction file (STK-CUS).

Mark W.
Its located in the Invcdtl tables as elemental unit costs. Multiply
this by the ship qty.

Gary Parfrey

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: 25 May 2007 13:46
To: vantage@yahoogroups.com
Subject: [Vantage] [Vantage 8.03] ARInvoice Line Cost



The AR Invoice tables show the line selling price to the customer but
do not display our cost of the part. Does anyone know where the cost
is located? When you run the Sales Gross Margin report it displays
the Total Cost. I looked in the report definition but the cost that
it displays is from a calculated field, so i am not able to see what
Vantage uses to calculate this. Does anyone have any ideas?





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