E1 43: Mass Update to Supplier Catalog Writes Same or Last Price to Various Quantity Records (R41061M) (Doc ID 2999524.1)

Last updated on SEPTEMBER 26, 2024

Applies to:

Symptoms

When run R41061M over a flat file with multiple updates for a single Item supplier combination, such as with different price break records for various quantities, each unique quantity record is assigned the same price, independent of the quantity break.  The last quantity price break amount is written to each quantity record.  

Each record gets the same the applied price break adjustment, independent of the quantity break, as if system updates all existing F41061 records for that item and supplier, independent of the quantity break. 

Steps:  

1. Create multiple Item Supplier price break records in a csv flat file.  Populate unique price for various quantities, such as 1, 10, 100, etc.  
2. Place the comma delimited csv file is a server path location.  
3. Copy the as shipped XJDE0001 version of R41061M, making no changes to the data selection.
   IF   AddressNumber (F41061)(AN8)[MATH_NUMERIC]    ==    Literal:  
   AND  CatalogName (F41061)(CATN)[String]    ==    Literal:  
   Where the literal == <blank>  
4. R41061M  - Set the processing options to run in final mode and populate the option for the flat file path and file, flat file tab, option 1.  
5. P41061 - Verify that for records in the flat file that were Added, the supplier, Item, Quantity, and Price are written to the P41061 records as expected.  
6. R41061M - Update the processing options, such as for a change to effectivity dates.  Rerun R41061M, with no further changes.  
7. Verify that for existing records, the update changes the price break records all to the same price.

Changes

Cause