CD_DN_Prepare

Guide for CD_DN_Prepare

  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. Office_Tools app doesn't needed macro enabled Excel. You can keep disabled in Trust Center.
  3. Prepare Creditors List
    Screenshot of preparing creditors list
  4. Select downloaded CN_DN file (ex: csv flile for entry purpose)
    CD1
    CD2
  5. Select Creditors excel file which is created
    CD3
    P4
  6. Open File generated file and see for errors in Ready Datasheet
    CD4
  7. It will generate Ready file for use
    CD5
  8. 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.
    P7
    P8
Back to Home