On this page
What it does
When many lines need fixing, Excel is faster than the grid. Export Excel writes an "AI Bill Correction Sheet": the bill header (Invoice Date, Invoice No, Supplier Name, Supplier Mobile, Supplier GST No, Invoice Value) and every line with Batch No, Expiry Date, MRP and Serial Nos. Correct the values, save the file, and click Import Excel on the same bill. The lines are replaced and the item matching is worked out again.
The AI returns five detail columns for each line: batch number, article number, size, colour and model, called Detail1 to Detail5. Your shop may keep different sub-item fields (defined under Items List → Settings → SubItem Master), such as Batch and Size for a footwear shop. Bill Pattern AI Model Training tells Speed Plus which Detail column fills which of your fields.
36.5Excel correction sheet and Bill Pattern training
Correct a long bill in Excel
When many lines need fixing, Excel is faster than the grid. Export Excel writes an "AI Bill Correction Sheet": the bill header (Invoice Date, Invoice No, Supplier Name, Supplier Mobile, Supplier GST No, Invoice Value) and every line with Batch No, Expiry Date, MRP and Serial Nos. Correct the values, save the file, and click Import Excel on the same bill. The lines are replaced and the item matching is worked out again.
Teach Speed Plus your sub-item fields
The AI returns five detail columns for each line: batch number, article number, size, colour and model, called Detail1 to Detail5. Your shop may keep different sub-item fields (defined under Items List → Settings → SubItem Master), such as Batch and Size for a footwear shop. Bill Pattern AI Model Training tells Speed Plus which Detail column fills which of your fields.
- On the review screen click Bill Pattern AI Model Training. A box shows one dropdown for each of your sub-item fields.
- Choose Detail1 to Detail5 for each field.
- Click the large icon button on the right of the box to save. The pattern is kept for this supplier and as the shop default. The small icon on the left deletes the pattern (Bill Pattern Deleted Successfully).
- Click Refresh. The review columns now carry your field names.
Read every step in the guide: Smart Tools, section 36.5
Questions and answers
The bill has no GSTIN. Will it find my supplier?
Yes, if the supplier's name or mobile number on the bill matches a party. The mobile number is matched on its last 10 digits.