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:
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:
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:
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:
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.
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:
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.
SWIL Team
|
|