Load Sanction (From Excel) (BD71) Previous Top Next

 
FunctionFacility to load sanctions from a MS-Excel file. The Excel worksheet is given as a template to the user specifying precisely the fields to be entered and the number of rows that can be entered into the file.
  
How To UseSample Excel Worksheet

Absorb Sanctions

  
Area 1é0Click on Select File and select a file through the interface provided. Click on Read File to read the file. On successful absorption of sanctions, the file is moved to the directory specified in line 2.
  
Area 2Details as read from the file are shown here.
  
Area 3The Billing Details as entered in the Excel worksheet are displayed here.
  
Area 4Any errors arising during sanction absorption are shown here.
  
Start DebugClick this button before clicking Read File to get a step by step confirmation of the process being done. The button changes to End Debug – click to stop the confirmations.
  
XL FormatClick to get a screen shot of the format of Excel file to be used.
  
Absorb SancSanctions Absorbed

Screen shows Sanctions successfully loaded, sanctions skipped and Sanctions with errors.
  
Pre-requisites 
  
Notes