All type of Adjustments

Guide for All type of Adjustments

  1. Keep this Calender and Date format like this for better Excel work. otherwise you may encounter date format Exception in excel while run Any Adjustments
    Screenshot of preparing creditors list
  2. In excel you have to enable macro in File> Options> Trust Center> Trust Center Settings> Macro Settings (if not enabled all Adjustments work will get failed) After close app will automatically reset to disable. check below last image
    Screenshot of preparing creditors list
  3. Prepare Creditors List
    Screenshot of preparing creditors list
  4. Select csv or excel file as per need
    P1
    P2
  5. Select Creditors excel file which is created (See Task Bar for excel icon and click)
    P3
    P4
    P5
  6. Repeat the process selecting until different asks
    P5
  7. Open File generated file and see for errors in Ready Datasheet
    P6
    P7
    P8
  8. After Close Office_Tools app will automatically set back to disable state for safety
    P6
Back to Home