Users use "Configuration Package" to update Sales price.
For Logos, existing created for Purchase Price and Sales Price.
1) Search "Configuration Package".
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) If users used adding new line approach, delete the exsisting line, just leave the new line in the template.
**If do NOT do that, the system will get stuck since so many lines to be imported while a lot are without changes.
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.
