Absorb Bill Reqn from XL Data (SO71) Previous Top Next

 
FunctionFacility to absorb Billing Requisition data from an Excel worksheet.
  
How To UseAbsorb BR from XL

Enter a Excel file to be read using Select File Button. Click Read File to read the file. The output path is the path to which the Excel file is moved on successful completion of absorption. Click Start Debug to get the debug messages during file absorption. Click Stop Debug once it is over. Click XL Format to view the Excel format to be used. Click Errors to view errors during read if any.Click Absorb SO once read is over for absorption of BRs.
  
XL FormatFormat of the Excel File to be Used

  
Absorb SOAuto Number Strip Form

Enter the Doc type and date and click "Next".BR Absorbed

Click OK to Save BR details.Modify Address

Use buttons and to add / delete address lines. Click OK to save changes.Modify Terms

Make changes if any and click OK to save.Add Items

Enter the Product Code, Quantity and remarks and click OK to save. Tariff and Budget Contributions for the product can be set using the respective Buttons.Note: Only Products that have been registered for the distributor and area will be Displayed in the List of Products to select from.

Click Modify to modify the item details including Tariff and Budget Contributions.Click Delete to delete the item from the billing requisition.Click Copy to copy a product from sanction for Below PL Sale.Click View More to view all details about the item, its tariff and Contribution.Click Addl Tariff to add additional tariff to the item.

Use buttons , , and to select tariffs to be applied. Click OK to save additional tariff details.Click Tariff Breakup to view breakup on tariff. PDC Details

  
Pre-requisites 
  
Notes