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
   
2. Office_Tools app doesn't needed macro enabled Excel. You can keep disabled in Trust Center.
3. Prepare Creditors List
   
4. Select csv or excel file as per need
   
   
5. Select Creditors excel file which is created.
   
   
6. Open File generated file and see for errors in Ready Datasheet
   
   
7. 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.
   
   
8. See for Create Ledger? if Yes, and If you have #NA in Name field (Ready Datasheet), that means NEW GSTIN not present in Creditors list, Lets update the name field like above and dont change Create Ledger? field., this should be added to Create Ledger on XML Generator.
   
9. For Sales Choose Sales_X or Sales_S see for Sales_others_Prepare_format help
10. If your data has same Bill No. more than once and the Total is Same for related bill no. use Sales_others_X, if the Total is different use Sales_others_S