PO report with Landed Cost

Hi,

I am creating Purchase Order for each new purchase. On each line I am having cost that is coming from vendor then I add additional Landed cost from Manage charges and distribute it to all lines or net amount.

I want to get a report for each PO where I get details of each purchase order line with Cost (Included Landed Cost)

E.g.

Item - abc, xyz

Cost - 100 each item

Manage Charges - 10

I need report as

Item Cost

abc 105

xyz 105 (100+5 charges)

– Please note I need this report at the time when I receive the purchase Order.

Please can anyone help me how can I get this kind of report or data from the Purchase Order.

Thanks in Advance.

Himanshu

the charges are stored in MarkupTrans table. See it’s relations with the purchline in the relations node.

\Data Dictionary\Tables\MarkupTrans\Fields\CalculatedAmount

Do you mean that you want to show this data in purchPackingslip report?

Hi Kranthi,

Thanks a lot for your reply. I am creating an report externally. Once I receive the goods, I want to run my query in sql to get the cost included with Landed cost. Please note that

  1. I have created an item,
  2. Added Manage charges,
  3. Confirm PO
  4. Received the Quantity.

Please find below query I am using.

SELECT
p.SOURCEDOCUMENTHEADER, L.RECID, p.PURCHID,p.PURCHNAME,p.INVOICEACCOUNT,p.DELIVERYDATE,
L.ITEMID,L.NAME,L.QTYORDERED,L.PURCHUNIT,L.PURCHPRICE,L.CURRENCYCODE,
L.LINEAMOUNT,t.CALCULATEDAMOUNT
FROM PURCHTABLE P,PURCHLINE L ,markuptrans t
WHERE
P.PURCHID=L.PURCHID
AND
P.DATAAREAID=L.DATAAREAID
AND
T.DATAAREAID=P.DATAAREAID
and
l.RECID=t.TRANSRECID
AND
p.DATAAREAID=‘brnd’
and
p.PURCHID=‘PO-0000407’

When I am running this code, Calculate amount is 0.

PURCHID PURCHNAME INVOICEACCOUNT DELIVERYDATE ITEMID NAME QTYORDERED PURCHUNIT PURCHPRICE CURRENCYCODE LINEAMOUNT CALCULATEDAMOUNT
PO-0000407 PK Exporters 210 09-06-15 500100000000AXB ABC 1 PCs 100 USD 100 0

Manage cost should be 50 so total cost should be 150

Thanks in Advance…

Himanshu

Item QTY PURCHUNIT PURCHPRICE CURRENCYCODE LINEAMOUNT CALCULATEDAMOUNT
ABC 1 PCs 100 USD 100 0

This is same example as given in my previous post. FYI

I think the calculate amount is updated after the invoice gets posted(please check that). In such case you need to calculate the markup amount. If it is fixed type, you can take the value from markupTrans.value, look at \Classes\Markup\calcTrans