How to Generate NDPS Sales & Purchase Report in Unisolve/Cross
Recently The Rajasthan Government demanded a NDPS report from all Wholesale, Distributors and Retail chemist shops. So we are providing that NDPS Sales & Purchase Report to our Clients.
In this article we have explained you how to generate NDPS Sales & Purchase Report in Unisolve/Cross. To generate this report please follow steps as per: (For Unisolve) : -
Step 1: First of all we need to enter NDPS Category and Generic Name in Product Master. To enter this please select Product Name through Product Master (System-> Master Data-> Product Information) & Modify it & enter Category & Generic Name. Screen as per below:
Step 2: After that please check & correct Product's Packing (Contains, Sell Loose) because as per Govt. rule Qty. should required in NDPS Report in Loose. So please correct packing in Product Master. To correct this, Please select Product & Modify the same & after that press F2 button to change or correct the packing of this product. In case of 10 tablet of strip size, please mention 10 Tab in contains & also tick on Sell/Loose option. In case of Syrup not required to enable on Sell/Loose option. Screen as per below:
You can directly update the Category and Generic fields for all the products using the options provided in the product menu.
(For Unisolve) Go to the System> Master Data> Product> Update Category and Update Generic.
Reference image:
(For Cross) Go to the System> Master Data> Change Product> Update Category and Update Generic.
Reference image:
How to Update Product Category
- Click on the Update Category Option.
- Here you have to select Master Group, Group, Category and Product to view the products details.
- After selecting the Master Group, Group, Category, and Product, you need to click on the "Show Products" option to display all the product details in the columns below.
- After displaying the product details, you can select "Narcotics" from the "Select Category" column to update the category for all the products.
- Click on the "Update Category To All" button.
- After selecting "Narcotics" in the "Select Category" column, the category has been updated for all the selected products.
- Lastly click on the "Update Category" button.
Reference image:
How to Update Product Generic
- Click on the Update Generic Option.
- Here you have to select Master Group, Group, Generic and Product to view the products details.
- After selecting the Master Group, Group, Generic, and Product, you need to click on the "Show Products" option to display all the product details in the columns below.
- After displaying the product details, you can select "Generic name" from the "Select Generic" column to update the Generic for all the products.
- Click on the "Update Generic To All" button.
- After selecting "Generic name" in the "Select Generic" column, the Generic name has been updated for all the selected products.
- Lastly click on the "Update Generic" button.
Reference image:
Step 3: After that select NDPS Drugs Sales Statement & Purchase Statement Report through Reports –> Sales & Stock Statement –> menu. Screen as per below:
Step 4: - After selection of NDPS Sales/Purchase Statement Report, Software will open Report Parameters & selection option to select Generic Name, Master Group, Group, Category (Narcotics), Product as per your requirement.
When you select Generic Name through Generic List & select Company through Master Group then software auto pick these Generics product only in List. When you open this report then option to select some parameters, Details as per below:
Enter Date Range: Please enter Date range as per your requirement.
Consider Challan: If you want to consider Challan Qty. also in this report then please select this. By Default it's Disable.
Consider Returns: If you want to consider Returns Qty. also in this report then please select this. By Default it's Disable.
Print Qty. (In Strips): If you wants to print Strip Qty. also in this report then please select this. By Default it's Disable because as per Govt.
record this report generates only in Tabs (Loose Qty.), so no need to print this.
Print Qty. (In Tab): As per Govt. record this report required Qty. only in Loose Qty. (Tabs), So by defaults it's Enable.
Print Generic Name: To print Generic Name in this report please select this. As per govt. report required to print Generic Name in this report, so need to print this.
Print Entry No. & Date: If you wants to print Purchase Entry No. & Purchase Entry Date also in this report then please select this. By Default it's Disable because in this report required only Supplier's Bill No. & Date, so need to print this.
Print Bill No. & Date: To print Bill No. & Date in this report then please select this. By Default it's Enable because Supplier's Bill No. & Date required in this report, so need to print this.
Print Packing: To print Product's Packing in this report please select this. As per govt. report required to print Product's Packing in this report, so need to print this.
Print D.L. No. & Date: If you want to print Customer/Supplier D.L. No. & Date also in this report then please select this.
Screen as per below:
Step 5: Now you'll find the NDPS Sales & Purchase reports in excel format.
You can export the excel file from Unisolve/Cross and upload the Sales & Purchase separately on Govt. portal.
Reference image: