Purchase Price List by Item Category

(4) Share

Report

Posted on by Juliem

377

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

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (1)

Report
Customizing the Price Calculation Logic (Codeunit 7021 Modification):

You can extend or modify Codeunit 7021 ("Purchase Line - Price") to use your custom field (e.g., Item Category or another field) instead of the Asset No. for price calculations.

Steps to achieve this:

Extend Codeunit 7021: Instead of using GetAssetNo() to get the Asset No., you can write custom logic to check the Item Category (or another custom field). In the price calculation logic, after you retrieve the Item for the Purchase Line, you can check the Item Category or other relevant field on the Item. Use this field in your calculations for applying the purchase price

you can also create a custom field on the Purchase Price List and modify the lookup or filtering logic so that it doesn’t require an Asset No. if you're targeting a custom field for price assignment.

https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/codeunit/microsoft.purchases.pricing.purchase-line---price

Thanks, Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Juliem 377 on at

Like (0)

Report

Thank you @Ramesh Kumar for your reply but I have to admit I am new to Interfaces and it's still not clear.

Does that mean that I need to create a copy of codeunit 7002 "Price Calculation - V16" and a copy of codeunit 7021 "Purchase Line - Price" and change all the reference to "Purchase Line - Price" in my custom version of "Price Calculation - V16" to point to my custom version of "Purchase Line - Price"

If this is not the case, how do I tell the system to use my implementation of Pricing instead of the base implementation.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, for Interface, hope the following can give you some hints.

Business Central 2024 wave 2 (BC25): Extend AL interfaces

https://yzhums.com/56176/

And, the new price module will replace the original one from NAV, so if you want to customize it now, it is recommended to customize it based on the new module.

https://learn.microsoft.com/en-us/previous-versions/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/use-new-sales-pricing-experience-

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Extending Price Calculations - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://www.kwixand.com/post/how-to-use-the-price-list-feature-in-d365-business-central

https://learn.microsoft.com/en-us/dynamics365/business-central/across-prices-and-discounts?tabs=current-experience

Was this reply helpful? Yes No