| S.No. | Description |
| 1. | All Data should be filled in Sheet1. like Template |
| 2. | Code,ItemDescription,Quantity Complasary & the Same Order |
| 3. | In Excel ItemDescription Should not Contain any Special Character, and Before or after More Space |
| 4. | Date Should be MM/DD/YY eg.07/26/13 |
| 5. | Either Discount Amount or Discount Percentage ( Discount Percentage is not greater then 100 and Product.MaximumDiscount) |
| 6. |
Not Null Columns in Batches if those columns not Contain in Excel
--> ItemCost, MRP, PurchasePrice, PurchaseUnit, SalePrice, SaleUnit, PurchaseTaxCode, SalesTaxCode |