Guide for CD_DN_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
   
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
   
3. Prepare Creditors List
   
4. Select downloaded CN_DN file (ex: csv flile for entry purpose) First you need to seperate Credit Note and Debit Note
   
   
5. Select Creditors excel file which is created (See Task Bar for excel icon and click)
   
6. Open File generated file and see for errors in Ready Datasheet
   
   
7. After Create Seperation file Choose Credit Note or Debit Note for Adjustments purpose
   
8. Select CN_DN seperated file, it auto selects Credit Note or Debit Note sheet from Excel
   
   
9. It will generate Ready file for use
   
10. If you see #NA in Name field (Ready Datasheet), that means NEW GSTIN not present in Creditors list, lets update in Both Creditors Sheet as well as in your Original Creditors list Excel file for future proof.
    
    
11. After Close Office_Tools app will automatically set back to disable state for safety