Purchase Price List by Item Category

Hi,

Our NAV2018 client is migrating to BC SaaS. We did a modification to the purchase prices in Nav to be able to set purchase prices based on a custom field on the Item.

For this example, let's say it was based on the Item Category.

How can I reproduce something similar using the Purchase Price List?

I have followed one of the exemples here https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-best-price-calculations#examples-of-extended-price-calculations

The one related to Adding a Fixed Assets as a Product Type.

The issue is that in Codeunit 7021 "Purchase Line - Price", the system automatically assigned the purchase line "no." field to the "asset no." for the price calculation.

In my case, it's not the item no. that I want but another field from that Item.

There is no GetAssetNo() function like there is one for GetAssetType()

I also thought about adding a custom field on the purchase price list that I could filter on, but then, I can't leave Asset No. field blank to consider all items with that custom field set to the same value

I tried setting the Product Type (Asset Type) to All but the system doesn't let me. It removes the value and put Item instead

Any idea on what I should try next?

Thanks

-Julie

Categories:

Dynamics 365 Business Central

Quick Links