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)
Item - abc, xyz
Cost - 100 each item
Manage Charges - 10
I need report as
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.
the charges are stored in MarkupTrans table. See it’s relations with the purchline in the relations node.
Do you mean that you want to show this data in purchPackingslip report?
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
- I have created an item,
- Added Manage charges,
- Confirm PO
- Received the Quantity.
Please find below query I am using.
p.SOURCEDOCUMENTHEADER, L.RECID, p.PURCHID,p.PURCHNAME,p.INVOICEACCOUNT,p.DELIVERYDATE,
FROM PURCHTABLE P,PURCHLINE L ,markuptrans t
When I am running this code, Calculate amount is 0.
Manage cost should be 50 so total cost should be 150
Thanks in Advance…
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