Sales Price Worksheet- putting an end date on previous sales price line

(1) Share

Report

Posted on by JT-04111931-0

My company uses the Sales Price Worksheet to mass update pricing around twice per year based on many different filters (ie. Replenishment System, Item Category Code, ect...) This tool works well; however, I haven't found a way to populate the END DATE of the previous sales price other than manually doing it. The issue is we have thousands of part numbers, so to have to do this manually is not efficient. Any suggestions would be greatly appreciated.

Categories:

Business Central

All responses (3)

Answers (0)

Suggested answer

Jun Wang 7,355 Super User 2024 Season 2 on at

Like (0)

Report

Sales Price Worksheet- putting an end date on previous sales price line

Is the end date an out of box field? It is on my standard BC.
Suggested answer

gdrenteria 10,600 Most Valuable Professional on at

Like (1)

Report

Sales Price Worksheet- putting an end date on previous sales price line

Hi

I hope this can help you and give you some hints

Dynamics 365 Business Central: Bulk update records/fields | Dynamics 365 Lab

Table Data Editor 2.0

Best

GR
Suggested answer

YUN ZHU 71,307 Super User 2024 Season 2 on at

Like (1)

Report

Sales Price Worksheet- putting an end date on previous sales price line

If you don't customize it, using Configuration Package is the fastest way. Export existing records -> Update END DATE -> Import

Hope the following helps.

Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Thanks.

ZHU