| Absorb Bill Reqn from XL Data (SO71) | Previous Top Next |
| Function | Facility to absorb Billing Requisition data from an Excel worksheet. |
| How To Use | Absorb 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 Format | Format of the Excel File to be Used |
| Absorb SO | Auto Number Strip Form Enter the Doc type and date and click "Next".BR Absorbed Click OK to Save BR details.Modify Address Use buttons 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 |
| Pre-requisites | |
| Notes |