| Purchase ID | Purchase No | Vendor | Item Name | Category | Qty | Unit Price | Total | Department | Status | Purchase Date | Invoice No | Remarks | Created Date | Updated Date | created By | Updated By | Action | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ row.purchaseId }} | {{ row.purchaseNumber }} | {{ row.vendorName }} | {{ row.itemName }} | {{ row.itemCategory }} | {{ row.quantity }} | {{ row.unitPrice }} | {{ row.totalAmount }} | {{ row.departmentId }} | {{ row.stockStatus }} | {{ row.purchaseDate }} | {{ row.invoiceNumber }} | {{ row.remarks }} | {{ row.createdDate }} | {{ row.updatedDate }} | {{ row.createdBy }} | {{ row.updatedBy || '-' }} | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| No Data Found | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Select file to import(Only doc,excel,csv,txt files):
| # | Tab | Purpose | Instructions |
|---|---|---|---|
| 1 | Details | View and manage purchased assets |
• View asset master records • Search by Asset Code, Item Name, Brand, Department • Sort columns using arrows • Click Asset ID to view full asset details • Click Edit to update asset information |
| 2 | New Record | Add new purchased asset |
• Enter Asset Code (or auto-generated) • Select Department & Asset Category • Enter Asset Type, Item Name, Brand & Model • Add Warranty / AMC details • Click Save to store asset |
| 3 | Bulk Import | Import multiple purchased assets |
• Upload CSV / Excel / DOCX / TXT file • File must follow Assets Bought format • Invalid rows will be skipped or flagged |
| 4 | Bulk Export | Download asset master reports |
• Select date range • Choose export format (CSV / Excel / PDF) • Asset master report downloads instantly |
| 5 | Help | User guidance & clarification |
• Refer examples before data entry • Follow validation messages • Use this section for support & understanding |
| Tab | Action | Steps | Result |
|---|---|---|---|
| New Record | Add Asset | Enter Asset Code → Select Category & Type → Fill Item, Brand, Model → Add Warranty & Vendor → Save | Asset visible in Details tab |
| Tab | Action | Steps | Result |
|---|---|---|---|
| Bulk Import | Import Assets | Upload valid Assets Bought file | Assets added to master list |
| Bulk Export | Download Report | Select date range and format | Asset master report downloaded |