ROSS: Pricing Load new prices

Created by Kathy Kale, Modified on Tue, 28 Jan at 9:06 AM by Kathy Kale

ROSS:  Pricing Load new prices


  1. change dates on old prices to day before the increase
  2. load export of old prices into spreadsheet
  3. load new price into spreadsheet - match them to the old part codes
  4. map export to new load format
  5. make sure new price is loaded in new load format
  6. Copy new prices in new format - only lines with real prices
  7. Paste Values - into "Input File Format" from Load SOP_Prices
    1. so that the values come over and not the formulas.
  8. save full spreadsheet for reference
  9. Save As   "CSV"  - make sure you are in the "Input File Format" tab
    1. this message will come up - OK - this will save only the "Input File Format" tab.
  10. Copy into your Ross Folder
  11. in ROSS, run   Load Sales Price  option
    1. Import Filename:   sop_price_load.csv
    2. Log Filename:  sop_price_load_log.lis
    3. Get a message of how many lines
      1. Read:  83
      2. Add:  82
      3. Modify:  1
      4. Error:  0    
  12. SCC Pricing Maint - export prices and compare new prices to what was passed to be loaded.




Paste Values 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article