User Tools

Site Tools


Parent Article: step_05does_the_counting_group_need_some_adjustments_to_this_file

Excel export clean-up (from external physical count method)

  • The most likely clean-up that may be required is that the blank part numbers lines will need to be filled in.
  • In the case that the file needs to have the blank part number cells fixed: you will need to insert a new column for the clean part number and use a formula to fill in the part numbers on all lines.
  • If you enter the formula into cell B2 as shown and copy it down, you will have fixed the issue
  • A final step is to select column b > copy > paste special (values)
  • The paste value process above will allow you to remove column A without damaging column B.
physical_inventory_count_external_count_method/physical_count_external_count_method_excel_export_cleanup.txt · Last modified: 2014/12/01 14:51 (10 years ago) by cliff