Excel templates are available inwards CSI Point of Sale software (POS>> Business Services >> Upload Bulk/Upload Prepaid Bulk >> Click "?" assist picture on the meridian correct >> Click link inwards Web page) which tin last copied in addition to used for uploading of Bulk articles received from BNPL customers in addition to Prepaid articles (affixed amongst PS, FM, SS) received from diverse volume customers/Bulk Postal Service letters
Most of the Data similar Name, Address 1, Address 2, Destination City, PIN codes, Mobile numbers are provided past times the virtually of the volume BNPL customers/ prepaid volume senders inwards Excel files through email/CD every bit these basic information are already available amongst them inwards their system/database.
Few volume customers also include Article Barcode numbers inwards the Excel canvass provided past times them, if barcode serial already supplied to them.
Using those basic data, nosotros may convey to deport out for sure COPY, PASTE, EDIT, FORMAT industrial plant entirely inwards prescribed Excel templates for making the file ready for uploading.
Only real few customers who are non using arrangement mostly reject to render higher upwardly said basic information inwards Excel file. For those articles entirely nosotros may last supposed to educate Excel template.
In such cases,
Doing Data entry of Articles information inwards Excel template itself is the easier i comparison to using diverse information entry tools meant for creating volume templates.
Advantages of doing Data entry inwards Excel template itself:
1) Sl.No., Reference number, weight, Prepaid mode, FM license ID, SOM Numbers all tin last easily filled inwards Excel past times using simply drag downward (fill series/ re-create cells) selection inwards Excel every bit the illustration may be.
2) Barcode numbers tin last scanned continuously every bit afterwards scanning each in addition to every article, cursor automatically movement to adjacent jail cellular telephone inwards lower row. Scanning of articles tin last easily done inwards Excel file (Sequence of articles should non last shuffled till successful upload of articles).
3) Moving from i jail cellular telephone to roughly other is real tardily (by using move into / navigation arrows) spell doing Data entry inwards Excel template when comparison to dull information entry procedure inwards Point of sale / Any other Data entry tool similar to betoken of sale booking screen.
Caution :
1) Sequence of articles spell doing Data entry in addition to scanning articles should last same. Should non last shuffled at whatever terms till uploading inwards POS volume upload.
2) PIN code plain has to last uniformely changed to publish format (using format cells).
3) Always salve the Excel inwards ".xls" file format. Please don't salve inwards ".xlsx" file format.
4) Tally full publish of articles earlier uploading.
5) Delete whatever other additional rows/columns (with whatever data) unknowingly available below actual rows to last uploaded.
6) Please don't type name/address to a greater extent than than xl characters every bit prescribed.
7) All mandatory fields should last filled inwards the template (SL.No, Ref No., Barcode no., Name, Address 1, Address 3, City, PIN, weight). For prepaid bulk, trend of prepaid, Prepaid total should last entered. For FM prepaid bulk, FM license ID in addition to SOM should last additionally entered.
Tag :
Latest Software Updates
0 Komentar untuk "Bulk Booking Of Articles Inwards Csi Signal Of Sale Through Excel File Upload"