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 2 Excel files through Govt. Portal of RGHS for Pensioners Billing as per following:


1st File: Bill_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 File: MKT_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 path. After 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. If you 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