Users use "Configuration Package" to update Sales price.
1) Search "Configuration Package" and create a package for updating price list.
E.g. the code = price list, select tableID = 7001
2) select the fields to be exported, here are reference.
Case 1) For Sales Price, update Unit Price + Line Discount %
Case 2) For Purchase Price, update Direct Unit Cost + Line Discount %
*User can do filter of which price list to be amended.
**If not set filter, all line will be generated.
Export the file
3) Add a new line, by adding new item / same item but new starting / ending date, or edit the existing line with new price.
**New Line Number = last line number + 10000
*If users want to edit the oringal line, suggest to use vlookup to lookup the new price / cost and discount.
E.g. Use "T" or "F" to determine which line item to be found from another file (items to be updated). Delete all line with "F", then vlookup the price / cost / discount from another file.
4) Delete the exsisting line, just leave the new line in the template.
Import back to the system and apply.
**Only Text in Red, means the file is compatible.
If it's in Green Color, export the file again and import.
*If user would like to delete the existing line, please adjust the unit price to be "0" in the template, and import to the system. (No delete can be done by configuration package the Line No. is still there)
Go to the related price list, filter all line unit price = "0", and delete those lines.
4) After finished, please verify the line of the sales price list.
**If not verify, those price will not be activated.
