Sales Order>Totals computation

Finance and Operations/AX User Forum
1

HI,

I would like to ask if possible to compute the Totals on Sales Order based on my Item last purchased Price aside from Weighted Average(WA)??

thanks and regards,

Bella

2

Not clear about your requirement. But,

last purchase price can be saved by using the latest purchase price on item/product.

cost price can be found from \Data Dictionary\Tables\InventSum\Methods\costPricePcs

3

Hi Kranthi,

I’m on a customization right now, I want to compute another Margin based on my last purchased price.

2548.5.JPG
2548.5.JPG592×592 60.7 KB

SellingPrice=P4,000.00 less PurchasedPrice=P3,900.00 equals Margin.

5852.4.JPG
5852.4.JPG841×464 88.8 KB

Can you help me on this matter please.

Thanks,

Bella