Have you ever encountered a problem with Sage X3 where a certain field that needs to be changed adds a new line to the pricing list template instead of updating for a product? The identical problem occurred to us in both the sales and purchase pricing lists; however, we were able to resolve it by updating the line that required updating rather than creating a new one.
To showcase the solution, we will be taking the Purchase Price list.
Step 1: Go to All->Set Up->Import export template
New Stuff: Restrictions on Selection Exceeding the requested SO quantity from pick ticket
Step 2: In the left list look for template code PPL.
Step 3: Scroll to the Fields tab and add PLILIN Field of table PPRICLIST which is the line field.
You will now see the line number (1000, 2000) in the PLILIN field location when you export a price list. You may now import the data by modifying the field value you wish to update for the line number. You’ll see that the changes you made to the relevant field are displayed on the screen rather than a new line appearing on the screen.