Unique Blend Of ERP + India Taxation For Pharma Company

1. Unique Blend Of ERP + India Taxation For Pharma Company Pioneer of Excise Software Udyog Implementation Partner Udyog Standalone Excise Software Udyog’s Excise Software which can be integrated BPCS ERP of INFOR Implemented at Glaxo Pharma Company where BPCS & iTAX is Installed

2. Facts • Glaxo is renowned Pharmacy company • They are using BPCS ERP which is not providing Excise reports • Customized Excise Solution was developed , which was DOS based with DBF back end. Problems • Regular data corruption because Excise software had DBF back end • Reporting was not available as per requirement • Updating on regular basis was problem.

3. Data Import & Export Functionality iTAX Data Imported Data Stored in Particular Folder Data Exported BPCS ERP

4. Common Transactions involved in ERP And Udyog Excise Software Purchase It IS Imported from BPCS in per transaction basis Output From Production Imported on periodic basis Pre Sales Generated in Udyog Sales Generated in Udyog

5. Purchase Transaction Is Being Imported Button To Pick Up CSV File, exported from JD Edward

6. Purchase Transaction Is Being Imported Select CSV file to be imported

7. Purchase Transaction Is Being Imported • Purchase Transaction Exported from JD Edward in CSV file has details like • Item Code & Item Name • Party Code & Party Name • Date & Time • Quantity & UOM • It is missing certain information for inventory purpose like lot or Batch number. • It is missing certain information from Excise point of view like. • RG Page no. • RG Serial no. • Software will generate all the missing information and generate RG-23A I & RG-23A I

8. Production Transaction Is Being Imported Select file on periodic basis

9. Production Transaction Is Being Imported • Productions Transaction Exported from JD Edward in CSV file has details like • Item Code & Item Name • Party Code & Party Name • Date & Time • Quantity & UOM • Batch no. • It convert small loose quantity (tablets) into SKU. • It is missing certain information from Excise point of view like. • RG Page no. • RG Serial no. • Software will generate all the missing information and generate RG- I, It maintains RG-I for loose as well as in Packet Quantity.

10. Dispatch is being Generated In iTAX

11. Dispatch is being Generated In iTAX Batch Selection

12. Dispatch is being Generated In iTAX • Dispatch is planned for different type of sales like • Excise Goods Sales • Non- Excisesable Goods Sales • Sample Goods Sales • It is generated irrespective of type of sales • This transaction has no any direct link with excise documentation, it only gives bifurcation of sales based on above mentioned type.

13. Objective Achieved • Seamless integration avoided duplication of data entry. • No more reconciliation is required between ERP and Excise Solution • No more data corruption because of SQL back end used in USquare. • All reports can be exported to Excel for further MIS • Year end is done easily from Excise point of view, which created new page number and serial number for all the required Excise registers and challans • No more last moment trouble shooting is required because of tried & tested solution with latest technologies.

14. Disclaimer All logos are properties of respective companies and are used only for identification only