Saturday, August 8, 2020
CSI POS BULK UPLOAD FILE CREATOR Version 5.0.0
What is new in version 5.0.0
1. Bulk file creation is compatible with POS version 4.2.
2. Issue of batch_id is fixed. In version 4.0.0 while deletion of all articles it became zero (0) when no other batches were available. Batch_id starts at number 1 (one).
3. Activation of the this software is needed. To activate use menu activation in home screen.
Version History : Version 4.0.0
1. New UI.
2. Added support of file creation in TXT file format.
3. Compatible with POS version 4.
4. Batch concept is dispensed with separate screen for every category of articles.
5. Auto saving of batch with ID of every category up to 5 bulk.
6. Auto deletion of bulk older than 5.
7. Added support for bulk IPO.
8. Added support for bulk VPL/VPP.
9. Added support for either pincode or post office search in every category of data entry screen.
Version History : Version 3.0.0
1. Added support for bulk Service RLs.
2. Added support for creation of upload file in Excel (XLS) file format.
3. Data entry in auto CAPS mode is added.
4. Auto entry in REF field is removed.
5. As XLS file is creation feature is added, this tool name is changed from "CSI POS BULK UPLOAD CSV Creator" to "CSI POS BULK UPLOAD FILE Creator".
6. Minor UI changes in data entry as well as find pincode.
Version History : Version 2.0.0
1. Added support for bulk EMO.
2. Added support for bulk articles with cash.
3. Added support for franchise outlet.
Version History : Version 1.0.0
1. Support for COD, BNPL, Prepaid With PS/SS/FM.
Help :
1. This tool is provided to process bulk articles and generate CSV or XLS of TXT file to be upload in CSI POS. This tool supports BPCOD, BNPL, Prepaid bulk articles with PS/SS/FM, EMO, Bulk articles without prepaid postage, Articles presented by Franchise Outlet, Service Articles, VPL/VPP and IPO.
2. This tool is designed in such a way to enhance the speed of making data entry with ease.
3. Barcode validation is provided to avoid wrong entry of invalid barcode.
4. It is designed to support batch by batch processing of bulk articles. The batch is not bound with any particular date. That means that processing of a particular bulk of articles can be continued for more than one day. Five batches are auto saved with ID. Batch older than five will be auto deleted.
5. It will be more easy if the articles are sorted pincode and then weight and then amount wise before processing.
6. To delete any wrong entry of any article select the wrong entry and give delete.
7. To edit article menu is removed.
8. To create bulk upload file click create file and save it. The default location is desktop.
9. To find either pincode or postoffice click pincode. Searched pincode can be exported to CSV file and then can be viewed in MS-Excel.
10. This tool is not for bulk foreign articles.
That's it.
CLICK HERE TO DOWNLOAD
Sunday, January 13, 2019
OFFLINE DELIVERY AND DESPATCH TOOL Version 2.0.0
Help
What is new version 2.0.0
1. Integrated VP/COD Intimation slip printing.
2. Increased the size of barcode for better scanning by scanner.
3. Increased maximum no. of Beat and BO each from 30 to 50.
4. In the office setup, name and pincode is separated. Office reset is required after this update.
5. Two extra formats of delivery slip printing for the purpose saving paper.
Introduction
This tool is provided as an aid and an alternative to spreadsheet to perform offline delivery and despatch work in case of inaccessibility of SAP by any means, otherwise use of this tool should strictly be avoided and is not recommended. The developer is not responsible for any misuse and unauthorized use of this tool. See disclaimer under about menu. The disclaimer is clearly stated in accordance with widely accepted licensing model and accepted principles of law.
User
Access to this tool is protected by means of username and password. Multiple users are supported. Minimum password length should be 8 eight chars with any combinations. Anybody can create a user and start to work. All users will have same access rights. Users can change his password at their convenience. User id can not be deleted. Every user is responsible for authenticity of data and safety of database. Logged in user id will be shown when you are logged in. Log info is not stored in Database. Password is stored in DB in encrypted form.
Setup
Configuration is needed when it is used for the first time. Office name has to be entered. Beat and BO details can be entered up to 30 each. In destination, all destinations to which bags are closed and despatched are entered.
Validation
Article barcode number validation is incorporated which will prevent invalid barcode usage.
Bag barcode number validation is incorporated which will prevent invalid inclusion of any article in the unsupported bag.
To make the task easier, it is designed that opening of bag, delivery and despatch is not interlinked and will work separately without depend on each other. Which means that straight away delivery can be made even without opening of bag and straight away despatch can be made even without opening of bag and without making delivery.
Opening of Bag
Opening of bag is to be done under Bag Open menu. Bag can be opened and reopened any number of times. Reopening can be done in case of alteration. Recd. Bag manifest can be printed under Recd. Bag Manifest under Report menu. In which enter bag id and print manifest for any date. The manifest can be printed in two different form ie) with or without barcode in it. Barcode will make the task of later bag opening in SAP-DPMS easier in case of articles were sent out for delivery.
Issue of Articles for Delivery
Beat issue and BO issue can be made under Issue under Delivery menu. If name and address is needed uncheck auto save checkbox. It is auto saved after every article is invoiced. Delivery slip can be printed there itself. Delivery slip will be saved in Documents folder by default. Wrong entry can be deleted by selection. Same article can not be issued more than once in a working day but different day possible. Issue of articles can not be made after returns taken. The same is applicable to BOs also.
Intimation slip for VP or COD can be prepared. Slip can be printed one by one or in all. Slip will be treated as printed after print is over. In case of reprint is required use RePrint option. History is maintained after every entry of VP or COD.
Returns
Beat returns can be made under beat returns under delivery menu. Returns can be taken for any pending date and beat. When you click on submit, returns will be completed. Summary will be shown. Only three remarks can be give namely “Delivered”, “On Hold” and “Despatch”. Excel file containing delivered articles and on hold articles can be generated for any date for every beat and BO under Export under Report menu. The files will be saved in a newly created folder under Desktop. The folder name will be date of working. If any file is created with the same name available in that folder, will be overwritten. The exported files can be uploaded in SAP using t-code provided by CEPT.
BO returns can be made under BO returns under delivery menu. List of all pending articles will be shown for every BO. Select article number, date of remark and remark and then click on mark button for every article and finally give submit to finish returns. BO returns can be recurred until all pending is over. Rest is same as Beat returns.
Return remark can be modified for any article under Modify Returns under Delivery menu.
Despatch
Despatch of articles can be made under despatch menu. Before invoicing of articles, bag should be created under Create Bag menu. Created bag can be deleted by selection if it is in open status. Any invoiced articles will also be deleted. Closed and despatched bags can not be deleted. When you create, bag status will be open. Bag closing can be made under Close bag menu. When you click on Re(Scan) button, bag status will be changed to open. When you click on Re(Close) button status will be changed to Closed. Bags can be reopened and closed for any number of times before despatch. Despatched bags can not be reopened. Despatch manifest can be printed with barcode or without barcode. Barcode printed on the manifest will make the task of later closing of bag in SAP easier in case of bags were despatched offline.
Despatch of bags can be done under despatch bags menu. List of all pending closed bags will be shown. You can despatch one by one or all at once.
Report
Recd. bag manifest can be printed later under report menu.
Despatched bag manifest can be printed later under report menu.
List delivered and on hold articles for any date of remark can be generated under export menu for any date. All generated files will be stored in a newly created folder in desktop. The folder name will be date of working day.
Details of any article can be searched in find article menu.
Under print barcode menu, barcodes can be printed for article numbers. Copy form spreadsheet and paste it. Minimum columns should be one. Maximum three columns are supported. Any excess pasted columns will clipped off while printing of barcodes. First row should contain headers. First column will be barcoded.
Prerequisites
All components are bundled with this tool and hence will not need any prerequisites and will run on most windows platform.
Database
Data is permanent unless deleted by user.
This tool is not designed to support to work with multiple users at the same time. It is not designed to work as server and client. If this tool is required to be shifted to another computer without loss of data, first of all take backup of the database to external drive. Install this tool in another computer. Create one temp user. Login with that user. After that restore the database in the new machine from the backup. This tool will now be entered into the state like in the old computer. Newly created temp user will be lost.
Database option is used to backup database, restore database and delete old data. It is recommended to take periodic backup of database for safety. When database is corrupted or lost by any means, restore the database from backup. Database includes user credentials and all data. When the database is restored, the state of the tool goes back to the time when the backup took place. It means that any newly created users along with newly worked out data will be lost. It is recommended to periodically delete old data of unwanted period to improve database performance.
To completely remove this tool, go to programs and features under control panel and uninstall it. First of all it is recommended to take backup of database.
That's it.
Monday, December 24, 2018
FO TEXT TO POS BULK UPLOAD FILE CREATOR Version 2.0.0
What's new in version 2.0.0
========================================
Added support for articles with only cash booked by FO is supported.
Version History : Version 1.0.0
========================================
Articles with only prepaid postage booked by FO is supported.
Help :
=====
- Use this tool to create CSI POS bulk upload file in TXT or CSV or XLS format from text file received from Franchise Outlet.
- Use this tool to search Pincode & Post office and export to CSV file for the purpose of printing etc..
- The format of contents inside the text file should conform to the sample files provided in this tool otherwise won't work.
- Use Start Batch menu to start a new batch. All previous batch data will be lost. Create upload file to avoid loss of work before starting new batch.
- Use Process Articles menu to process loaded articles. All loaded articles should be processed to include in bulk upload file. The text file does not contain sender pincode and hence individual processing is required.
- This tool will not create bulk file for foreign articles.
- That's it.
CLICK HERE DOWNLOAD
Sunday, August 12, 2018
LIC TEXT TO POS BULK UPLOAD FILE CREATOR Version 3.0.0
What is new in version 3.0.0
- Added support for BNPL.
- Minor UI changes.
- New UI
- Added support for text file creation.
- Compatible with POS version 4.
- Minor UI changes.
- Added support for data entry in auto caps mode.
- Support for csv and xls file creation.
- Use this tool to create CSI POS bulk upload File in CSV of XLS format from text file received from LIC of India who is presenting special journal of franked Registered articles and BNPL articles.
- Use this tool to search Pincode & Post office and export to CSV file for the purpose of printing etc..
- The format of contents inside the text file should almost conforms to the sample file provided in this tool otherwise won't work.
- Use Start Batch menu to start a new batch. All previous batch data will be deleted. Create upload file to avoid loss of work before starting new batch.
- Use Process Articles menu to process loaded articles. All loaded articles should be processed to include in upload file.
- Use Fix Barcode menu to change any wrong barcode in the loaded articles not in the processed articles.
- Use Edit Articles menu to edit any related fields in any processed articles.
- That's it.
Saturday, August 11, 2018
TA BILL CREATOR Version 2.0.0
I received some feedback from our dop employees from various locations to update the tool to support multiple spells of travel in a bill. So I updated the tool to suite to IP and SA.
What is new in version 2.0.0
- Major update to support to add multiple spells of travel.
- Minor change in TA Bill format.
- Major update to support to add multiple spells of lodging.
- Major update to support to add multiple spells of leave.
- Major update to add default values as history at initial user creation itself.
- Improved help.
- Minor user interface changes.
- Only one spell of travel, lodging and leave during tour was supported in a bill.
Subscribe to:
Posts
(
Atom
)
