| Description |
Originally we made the PriceID the same as the price. However, multiple products can have the same price. This is causing conflicts in BASE, so we need to change the priceID to be a unique value that is not the price. Entity may work, but it appears we are taking pricing from inventory and dispatch which have different entity pools. A duplicate, while unlikely, is possible if using entity. We will need to assign a unique integer value to the pricing that can be consistently assigned not only in the Product Pricing export, but for the Products, Asset Accounting and Dispatch exports as well.
The IDs need only be consistent for each set of export files. It won't be a problem if the IDs change between export sets, as long as the IDs match in Products, Product Pricing, Asset Accounting and Dispatch on a per export set basis.
These are the affected views/sp that will need to have PriceID changed to a matching unique integer value.
Product Pricing - vyuTMBEExportPrice
Products - uspICTMExportProducts
Asset Accounting - vyuTMBEExportAssetAct
Dispatch - vyuTMBEExportDispatch
|