I have been tasked with creating a matrixed price list report based on our customer price list - effectively a list of part, break qty 1 , break price 1, break qty 2, break price 2 …
We maintain our price lists in both a structured and an adhoc manner. The structured method is to load up via dmt with the breakqty,unit price fields that feed into the pricelist parts field populated as well as the fields that populate the plpartbreak table.
In between structured price list revisions we may add a new customer part, or a commodity used to make a some of parts in the pricelist may significantly increase in price and we may need to add or amend a few part prices. For a new part the process is to add a part to the existing price list and then add the relevant price breaks.
All works well from the point of view of the right prices being applied on order entry.
Looking at this from a reporting point of view and at the underlying tables (pricelistparts and plpartbreak) it seems that the dmt method and the manual method don’t populate the tables in the same way. DMT populates all of the fields specified in the import file in both tables. A manual update adding price breaks seems only to populate the plpartbreak , the only thing that goes to the pricelistparts table is the partnum. My guess is that this possibly happens to allow more than five price breaks on a price list.
I am guessing we are not the only folks that come across this so my question, before I go off and create an updateable dashboard to manually parts to a pricelist is whether there is anyway using standard functionality to update pricelists so that we can manually populate the pricelistparts table on and adhoc basis as above.
We are on 10.0.7.4