SUPN - Simple Update Part Numbers

2.48 - 10/17/24

  • uses a .csv file uploaded to fixedfocus instead of reading Excel
2.47 - 4/30/20
  • bug fixed - was putting bin value in o.h. field for plus/minus transactions
2.46 - 3/2/16
  • updates from -MASTER with DS.MSTR.SUB
2.45 - 8/5/15
  • bin2, bin3 added
2.44 - 11/8/14
  • added mass change function
    • uses saved list
    • choose from 4 fields: BIN1, BIN2, SO, SS
    • enter new value, NONE to clear bin
2.43 - 8/21/2013
  • works for all combinations of XP, W7, Reflection, and Bluezone
  • file must be desktop/SUPN.xls
  • puts backup PART-NO. items pre-change in SUPN-FILE
  • no longer makes a .csv log file
2.42 - 5/14/12
  • extra days supply added
  • Runs on Windows 7 or XP (2 versions), but on XP, only works with Reflection
2.41 - 4/9/12
  • truncates numeric values to integer after multiplying * 100 in case more than 2 places after decimal
    if third character after decimal was 5 or higher, number is rounded up
2.3 - 12/31/11
  • works on Bluezone as well as Reflection
  • import from spreadsheet only
  • uses temp text file to speed import
  • writes .csv log file with same name as original .xls file showing changes
2.2 - 12/24/09
  • update sub added
2.1 - 12/11/09
  • if not updated by MASTER, then puts 1 in PAC and 1 in MULT
2.0 - 6/21/08
  • no macro needed
  • no setup needed
  • user browses for excel file
  • program responds according to what is on the header line
  • if adding a part number, the 2 transactions are ordered correctly