Export Excel files from the RGHS (Government Portal) using Cross Software

How to Import Sales Invoice in Cross Software through RGHS (Govt. Portal) Excel Files



How to Import Sales Invoice in Cross through RGHS (Pensioners Billing Govt. Portal) Excel Files 


In this article, We have explained to you "How to Import Sales Invoice through RGHS (Pensioners) Excel Files " in Cross.


Please install the Latest Patch of our Cross Software through ftp.bhiwal.com.


Firstly Please download Excel files through Govt. Portal of RGHS for Pensioners Billing as per following:


1st FileBill_wise_sell.xlsx

Please select Date & press search then your portal display this report, after that please press on Excel button then your portal download this Bill_wise_sell.xlsx in your desktop machine. Please Download this file through the Sales Invoices-> Invoice Summary option. Screen as per below:


sales invoice


2nd FileMKT_GroupWise_Sales.xlsx

Please select Date & press search then your portal display this report, after that please press on Excel button then your portal download this MKT_GroupWise_Sales.xlsx in your desktop machine. Please Download this file through Sales Details-> Sales Details (MKT Group) option. Screen as per below:


sales details


After that please run our Cross Software & Import all Sales Invoices through these files. Please select the "Import RGHS File" option through System-> Import/Export menu. Screen as per below:


Import RGHS File


Please give the path of the downloaded file which you saved on your Desktop Machine. Please select Bill_wise_sell.xlsx file in Master Master file caption path & GroupWise_Sales.xlsx file in Detail File caption pathAfter that press OK then the software opens a Product mapping window. Please mention different Series for import RGHS Sales Invoices. 

The first time you should map all the products, after that next time software auto shows your already mapped product when you import again. Screen as per below:


mapped product


After mapping the all products, when you press the OK button then the software auto makes your Sales Invoice on the Same Number which you entered in Govt. Portal. Before importing this please check the same batch & sufficient stock is always available in your local database which you select at the time of making Sales Invoice on Govt. Portal. 


You should check your Sales Invoice through the Sales Invoice Browser table. Please check once your Sales Invoice matched or not with your Govt. Portal. 


At the time of Import Sales Invoice Software, auto makes these invoices as Credit & Patient Master also creates in Patient Master. Screen as per below: 

Import Sales Invoice


Software auto Create Patient in Patient Master under RGHS Category & Type. The software also selects by default posting A/c RGHS. Screen as per below: 


Patient Master under RGHS Category


After that please check your all Sales Invoice proper Import or not. Iyou facing any issues please make a Ticket on swildesk.com with mention your Anydesk  ID No. & after connect our SWIL Executive you can also start chat on Anydesk.


If you require support please read:  How to get online support (Guide & Video)



To avail of this facility, Please download our Latest Patch of Unisolve Software. To download the last patch please read: How to Download Last Patch (Guide)



For more details, please make a ticket at swildesk.com.




Thanks



SWIL Team


https://support.swildesk.com/portal/en/home

https://swindia.com

Unisolve Software



      • Related Articles

      • How to Copy Sales Invoice in Cross

        How to Copy Sales Invoice in Cross In this article, we have explained you how to copy all products with qty. of particular one Sales Invoice into new Sales Invoice No. Sometime User/Operator want to make same Invoice again which we make earlier due ...
      • How to Import Purchase through CSV file in Unisolve / Cross

        How to Import Purchase through CSV file   CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft ...
      • Generate Auto E-Invoice

        How to Generate Auto E-Invoice in the Unisolve Software What is E-Invoicing? 'E-invoicing' or 'electronic invoicing' is a system in which B2B invoices are authenticated electronically by GSTN for further use on the common GST portal. An e-invoice, or ...
      • Convert Purchased Products Directly into Sales Invoice in Unisolve Software

        How to Convert & Select Purchased Products Directly into Sales Invoice in Unisolve Unisolve software now includes a convenient feature that allows users to select purchased products and directly convert them into sales invoices. This feature is ...
      • How to Export Sales Invoice in CSV format in Cross

        How to Export Sales Invoice in CSV format in Cross CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as ...