26-12-2022
----------
 This version  includes the options to prepare Lab Testing reports in Hospital Type.
    Guidelines:
	  0. Set firmtype as hospital in firm mgmt.
	  1. Create separate billing series for the following type
          [General Billing],[OPD consultg],[LAB Charging],[IPD Charging],[Advance Receipts],[Retail Billing],[IPD Final]
      2. In ItemMgmt all items should be set as following chargingtype
	         [Pharma Items],[Services],[LabTestings],[Consumables],[Equipments],[Consultancy]
         here  LabTestings items will be billed in Lab charging series
         and   Consultancy items will be billed in OPD Consultg series. 		 

      3. For LabTestings items , no of observations ,Testing Group, Sampling Type, Testing Methods , Normal values have to defined.
	     in item mgmt.
	  4. In Sales you may select tests by group-wise (By pressing @ and groupwise on billed item window]
         [ By pressing "/" (Slash)  on billed item window , if special group of items already made in item-->special group]
		 [and entering each test item individually.]
		 
	  5. After getting test results , you have to enter values by pressing F2 on LabTesting bill.

      6. Design your own testing report in the format 001 
         H226,H227,H228 c321,c322,c323,c324,c325,c326 etc created for this purpose.
         Patient details are same sa prescription.		 




3-5-2022
---------
Guidelines to get IRN of E-Invoice automatically.
  Create API connection accoarding video as below.   
   0. https://www.youtube.com/watch?v=w1mZcxdNxCM
   1. Update with latest EPL
   2. Enter Saral Code(CustCode)  in Utils64->Firms-Mgmt->Advance Param
   3. Go to 1-Report-GST Report->E-Invoice-->Credentials
      (Enter usre-id and password of supplier as registered on GST-EINVOICE-Portal.)
   4. Go to Outward->SalesMgmt->BillsList->Press (*) on bill for which IRN to be fetched.-->Press <Y>       to confirm
      IRN is automatically fetched and inserted in the said bill.
	  
	  
      



30-3-2022
--------
Guidelines for E-Invoice.
   0. Update with latest EPL
   1. Download E-Invoice offline tool from gst portal.
   1. Enter Saral Code(CustCode)  in Utils64->Firms-Mgmt->Advance Param
   2. Go to 1-Report-GST Report->E-Invoice
      It has three options
       (option-1)  If your bills have a few items .
       (option-2)  If your bills have more items.
       

       you may create csv file  from above by selecting b2b bills and create json from offlinetool.
       or
       directly create json and upload GST portal using partylogin. and download irn xlsx file from
       the portal. IRN nos so downloaded will be updated by (option-3) into your sales bill.

       you may get  irn nos of multiple bills from the portal  in one shot.
       
       you may add  QRCode (H291) of  EINVOICE in output format.








8-11-2021
---------

Guidelines for pharmarack integration.
   
     0. Updae with latest EPL   
     1. Select "Yes" in Utils->Firms-Mgmt->Advance Param->Pending Order.
        and  Enter  "Y"  in Utils->Firms-Mgmt->Advance Param->Patch Integration.

     2. Restructure,Reindex,rewrite,Reindex
        (a) A folder PHARMARACK is created on the drive of saral.
        (b) This folder has following subfolders
             Export: csvfiles to be exported to Pharmarack portal will be stored here.
                     Folder name will be defined in pharmarack App.
   
             Import: csvfiles to be imported from Pharmarack portal will be stored here.
                     Folder name will be defined in pharmarack App.
                     (Ph_Ord,Ph_PMT,Ph_SCR subfolders to hold imported order,payments and
                       creditnotes files)                     
 
             Processed: Order files log after updating 
                      (Ph_Ord,Ph_PMT,Ph_SCR subfolders to hold Processed orders,payments and
                       creditnotes files) 

             Temp: For internal use.

      3. First Select Others-->Pharmarack Int-->Services-->Mannual
          Then define Settings of Firmdata. (FirmId supplied by pharmarack)
          After that you have to define settings of all export/import options
          for  sync time.

         There are  three methods for importing of PHARMARACK Sales orders. you have to define 
         one method in settings of Pharmarack Sales-Order.
         1. Import PharmaRack Sales Order into Others->PretradeMgmt->SalesOrder.
            (If any selesorder is pending it will be shown on the bill table of bills-mgmt)
            (<+> is used to convert salesorder into sales bills)
         2. Importing PharmaRack Sales Order into Outward>BillsMgmt->NewBill
            or 
         3. Challans ,if challan system is active.
          
         (You have to define also  series of SalesOrder or sale bills in settings of 
           pharmarack sales-order.)
                     

        First check all export and import options in service-->mannual mode.

         and see outputs in respective folders.
  
       if all is well , then make service-->auto-running.

 
        

           


30-10-2021
-----------
Guidelines for color output formats (If user has color priner)
  1. Add a description line selecting color by F8 before the text.
  2. it will something like that X057+"255,0,255,255"+X057
     (Here Transparency/Opacity of color is 255, means opacity is zero)
  3. After colored text add a new description line having y231 to activate old color again.

  4. For backcolor of a text
     a. Add a new description line selecting backcolor by F8 before the text.
     b. create a box  as  Y228+"x1,y1,wd,ht"+y228  
        which covers the text. x1,y1 is location and wd,ht is size of box. 
     c. Add a new description line selecting forecolor by F8 before the text.

  5. For Watermarks and print diagonally.
     a.To set transparency/opacity of a color use 255-0 in transparency field asked 
       just after selection of color by F8 (128 means half transparent and so on)
     b. For a diagonal watermark textline
        Add a new description line as Y229+"x1,y1,width,angle,Text"+Y229
        Here x1,y1 start location
             width is diagonal length upto text will be stretched.
             angle=45  (For diagonal or any angle)
             (Put (-) if text is printed from (bottom left to top right)
             Text = String to be printed diagonally.
      c. Add a new description line having y231 to activate old color again.
  6. For watermark logo.
      a.  First create a visible transparency into the logo using any picture editor.
      b. Add following stmts. on footer and pgbrk section)
		Y225+"logofile,X1,Y1"+Y225
		Here name of logofileshould be without folder and with extension.
		x1 are y1 starting coordinates of logo in pixels. 1 inch=100
		logofile should be copied into software folder.
         (WaterMark Logo print stmts should be taken on the starting of the header.)




12-7-2021
----------
1. This update is for tds under 194q.

   Any business unit having turnover of 10 cr in previous year is  liable for TCS on Sale 
   and TDS on purchase.
   
   Enter 1 in SalesBypass entry no 81. (For TCS on Sale)
   Enter 1 in PurchaseBypass entry no. 59 (For TDS on purchase)
   (It will check the threshhold limit of 50 lacs for sales and purchase)
   
   You have to define tdshead as same as tcshead previously in dealers-mgmt. 
   there are two heads , TG058 (if tds is calculated of gross value) 
    TG057 (if tds is calculated on purchase  value (before GST))
   
    Some suppliers are deducting tds in their invoice value and some are not
   we have both options , while entering our purchase invoice.
 


24-09-2020
----------
1. This update is TCS compatible.
   TCS will be collected by the firms having turnover more than 10 crore in the previous year and from the customer 
   having supply  more than 50 lacs in the previous year . It is applicable w.e.f. 1-oct-2020.
   
   Steps to implement.
   1. Update with new version.
   2. Define TAN in the firm mgmt in utils64.
   3. Enter TCS head in Dealers-Mgmt , it will be TAX 0.075 %  if customer has PAN or Tax 1 % if not
   4. Variables are available in report 001,004,005,006.
   6. 27-EQ annexure is added for GST-Report
   
29-2-2020
---------
1.Removing bug of mixing items of bills on LAN.
2. Add logo on output format of sale bill on the laser printer.
    (Add following stmts. on footer and pgbrk section)
		Y225+"IMAGEFILE,X1,Y1"+Y225
		Here name of imagefile should be without folder and with extension.
		x1 are y1 starting coordinates of logo in pixels. 1 inch=100
		imagefile should be copied into software folder.
		




26-02-2020
----------
Guidelines for format design for laser printer.
y179,y180,y191,y192,y193,y194,y195,y196,y197 are active for laserprinter.

You may create line by y222+"x1,y1,x2,y2"+y222  where x1,y1 are starting co-ordinates in pixels and x2,y2 are ending point coordinates on the page
where  1 inch has 100 pixels.
 
For vertical lines x1 and x2 will be the same.
For Horizontal lines y1 and y2 will be the same.

You may create box  by y223+"x1,y1,wt,ht"+y223  where x1,y1 are starting co-ordinates in pixels and wt,ht are width and height of box on the page
where  1 inch has 100 pixels.

laser printer Sizes must cancelled by x002 at the end of the line .

Box and line statements should be taken in headers and footers only. 

16-02-2020
----------
1. Fixing bugs as received so far.
2. Speed improvement on item listing on LAN .
3. Accout list filter (F7),adding one  option to get customers with missing/invalid GSTIN 
   of active on specified period billing.
 4. Item list filter (F7),adding one  option to get customers with missing/invalid GSTIN 
   of active on specified period billing.  




12-02-2020
--------
1. This update contains a hotkey (F6) or (rightclick) execution for item-ledger anywhere.
2. This has an export feature (SaralToSaral) by pressing  @ on the bill table.
3. And import facility from marg/saral/aiocd fixed format.







27-1-2019
---------
This update contains the feature of of auto/mannual backup of business data on the local 
as well as cloud drive.

To define backup option GoTo  Utils64-->FirmsMgmt-->Define Business Unit
These parameters should be defined.
    1. BackupType  -- Mannual ->A hot Key Alt-B (or in RightClick-Hot-Options) is available throught the software.
	                  Auto    ->Backup is automatically executed after a defined interval in background without 
                                interrupting current working.

    2. Backup Drive --Local    ->Target drive of backup will be of local PC.
	                --Cloud    ->Target drive be will google-drive as well as local drive.
    
	3. Repeat After --In Minutes--> It should be defined in minutes , backup will be executed after this interval
	                                if backuptype is auto.
									
	4. Local Folder --  Local Folder on the PC for backup.	

    5.  Gmail-ID    --  Gmail-ID  of google-drive (Quick-start credintials for google-drive will be asked on firsttime
                                                   uploading)  	




23-1-2019
---------
1. Update uploaded after fixing all bugs as received so far.



9-10-2019
---------

1. Bugs Fixed as received so far, including printing problems.
    (Now there is no need to define printercode in autoexec.nt)

2. Option to adjust CreditNotes prepared in outward when created or by pressing (<F4><F4>) on outward list. 






6-9-2019 (For both epl00 and epl64)
--------
In this update you may  temporarily create all sales/purchase/trans  entries  into  a single date xml file 
then check upload of this file into educational/trial version of tally, correct errors from tally.imp if found any.
if no errors found  then create xml again on actual date.  try  if it works.







8-8-19
-------
1. Bugs fixed as received so far. in EPL64 (SaralHybrid)
2. Read ReadMe.1st for SaralHybrid installation


30-7-2019
---------
1. Bugs fixed as received so far.

2. Now saralhybrid is mouse compatible.
   (plz check SaralHybrid-ICON-->PROPERTIES-->OPTION-->  "QUICK EDIT MODE"  -->UNCHECK
                                              and   --> CNTRL+SHIFT+C/V --uncheck



22-7-2019
---------
1. Steps To setup printers in epl64 (SaralHybrid)
  In Option "Define printers" of  UTILS.EXE 

    *For  Single computers
	       *For DMP Printers  attached on LPT1 or LPT2 or LPT3
		       
			   make all/Only  attached LPT ports   "ACTIVE" as the case may be.

            * For DMP Printers   attached on USB.
                      make all/Only  attached LPT ports   "ACTIVE" as the case may be.
			
			     		and 
                        Set your printer/computer Network-shared and rename by simple names
                        eg. MYPRINTER and MyComp using control panel(device & printers)
                        and then add follwing lines in the  last of ../system32/autoexec.nt
                        NET USE  LPT1    /DELETE  
                        NET USE  LPT1    \\MyComp\MYPRINTER  /PERSISTENT:YES
						or
                        NET USE  LPT2    /DELETE  
                        NET USE  LPT2    \\MyComp\MYPRINTER  /PERSISTENT:YES
						or
			            NET USE  LPT3    /DELETE  
                        NET USE  LPT3    \\MyComp\MYPRINTER  /PERSISTENT:YES
						
             * For Laser Printers   attached on USB.
                    Add new printer in Define Printers of UTILS.EXE
			        and make it active.
			 
			 
	 (Add Environment variable "PrnDrivers" )
	 
	 
	  In Autoexec.nt   
	 Set PrnDrivers=PrnCode
	 
	  or 
	 
	 in MyCompuer-->Property-->Advance-->EnvironmentVariables
	
    	VariableName=PrnDrivers
	    VariableValue=PrnCode
	  
	 (PrnCode and PdfCode are the single letter code of drivers from the Utils-->Define Printers List)
	  PrnCode=Code of printer driver.
	
	 eg in autoexec.nt

	 Set PrnDrivers=1
         (it will select "LPT1" as printer driver .)
			 


19-7-2019
-------
1. Bugs fixed as recd so far in epl64. and new options added.


24-6-19
-------
1.epl64 uploaded, plz check it thoroughly, it will replace old epl00 after few days.
2. Consolidation of gstr1 csv files in single xlsx file .
3. View of csv files within the software.
4. sending emails (bills,ledgers,company stmt etc within the software.)




18-6-19
--------
GSTR9 reports added 
1. Error removed as recd so far in epl64 and epl00
2. For GSTR9 Sale/Purchase heads for TradingItems, Fixed assets items  and P & L items must be defined separately.
3. Voucher-EntryType for gst payment vouchers must be defined in vouchers mgmt by F1.



10-06-2019
----------
EPL Trial version for 64 bit machines has been uploaded.
Plz make different icons  using utils64.exe 

Change Target  <mlan64.bat>  for LAN use



Change Target  <saral64.bat> For Single use

and   <utils64.exe> as utility

plz  define layout of icons (after right-click icons and select property--layout--Screen Buffer Size (Width=80,Height=25)
                                                                                --Window Size  (Width=80,Height=25)
															change property-font- as fit to your monitor screen.


Other settings and data will be same as the previous.															









6-5-2019
--------

1. SALE BILLS ME ITEM QTY PAR F4 PRESS KARNE PAR LINK FIRM LIST KHULTI HE , JISME 'Y' SE FIRM LINK 
KARTE HE TO USKE BAAD PREVIOUS YEAR DATA FILE NOT LINK MESSAGE SHOW HOTI HE. (DO SE ADHIK FIRM HO TO)
JABKI VO DATA FOLDER SOFTWARE FOLDER ME HE. 

---corrected 

2. MANAGE STOCK > CR-NOTE PROBLEM : OLD FIRM SE NEW FIRM CREATE KARKE DATA TRANSFER KARNE PAR NEW YEAR KE 
CR-NOTE ME KEWAL EK HI ITEM TRANSFER HOTA HE. VO BHI US CR-NOT KA ITEM NAHI HE. 
CHECK 31/03/19 KE LAST CR-NOTE.

--corrected.

3. SALE BILL ME ITEM BATCH TABLE PAR ITEM KA NEW BATCH (SELF STOCK ADDITION) SE BANANE PAR PRICE PAR 
TAB PRESS KARNE PAR PAHLE PAID RATE KA OPTION AATA THA JO ABA NAHI AA RAHA HE.

---corrected

4. CUSTOMER KO 'NET' RATE PAR ITEM SALE KARTE HE , LEKIN SALE RETURN PAR ITEM 'MRP' RATE SE LETA HE. 
SALE RETURN 'NET' RATE PAR HONA CHAHIYE. (RETAIL FIRM ME) 

----corrected.

5. BACKUP LOAD PROBLEM :
?????_?.000 SE BANANE WALI BKUP FILE BKUP SE LOAD NAHI HOTI (ISAKO ?????_?.000 SE ?????_?.ZIP ME RENAME KARKE 
DATA FOLDER ME UNZIP /O SE KARNA HE.)

--Unzip.Exe is not compatible in higher versions of windows within the other exe 
  like utils.exe (It should be unziped separately on dos prompt or by batchfile) 


----corrected.


6. Pending Bills of previous year will be transfered with full and part amount.

--Corrected.

7. Some correction in gstr2a (b2b) compare.

   Removing blank lines.





11-4-2019
-------
1. Error removed as received so far.
2. Two columns for stock head name and code  added in output format of 053 (2) to verify 
   summary of stocks by detailed itemwise closing stock.
 



5-4-2019
--------
1. You may re-transfer opening stocks in transfer masters (option-16) in utils, if you found any inconsistency in opening stock.
   eg. not showing schemes etc. in current batch table.
2.  A compare excel report is added to check the proper transfer of items in new year.
    Items-->Advance Options--->Compare Opng 


 

26-3-2019
-----------
1. Error removed as received so far. 
2. Verification of gstr2a  (b2b)
   a. Download gstr2a from GST-Portal
   b. Copy b2b sheet of gstr2a into a new excel sheet.
   c. Change all date columns of b2b new sheet in the format dd/mm/yyyy
   d. Save above xlsx as new csv(msdos).
   e. Compare this file in 1-Report-GstReports-Compare(GSTR2a)
      in to corresponding financial year data.
   f. An * is marked on purchase list (Inward) before (Cash/Credit) if the invoice is found
      on gst-portal (gstr2a(b2b)).(purchase invoice no and date of gstr2a(b2b) should be 
      matched exactly with your purchase sheet)

   e. All invoices which exist in gstr2a(b2b)  but not in  purchase sheet will found in
      gstr2a_m.csv  into your software folder.
   f. You may also mannually enter verified flag "yes" on purchase sheet by f11. 
      (if  purchase invoice no and date of gstr2a(b2b) are not exactly matched with your
      purchase sheet but you observe it is the same invoice)

2-3-2019
---------
1. Error removed as received so far. (For stock/batch table sync.)
2. Reindex.exe ,Rewrite.exe and Restruct.exe added saperatly for large data firms ,
   useful specially for 64 bit machines where Base RAM is less available.
   






12-02-2019
---------
1. Error removed as received so far.

10-12-2018
----------
1. Error removed as received so far.
2. latest version of eway bill implemented.


25-10-2018
----------
1. Error removed as received so far.
2. Comparision of gstr2a from purchase bills.
      a. Download  gstr2a from parties login and save it as csv file, and compare it from gst-report 
         in purchase sheet <*> is prefixed for purchase bills found in gstr2a and <**> if gst differs.
         suppliers gstin must be  correctly entered in saral. a sheet of not matched gstr2a bills also 
         prepared.  (F7=Filter also included in purchase sheet for verified/non verified invoices.)

      b. You may also enter verify flag mannually  on purchase sheet  by  f1 in purchase mgmt.
3.  For Tally Master transfer, you may define/link tally groups for all accounts before creating tally-xml.

4. Corrections in eway bill accoarding version 1.0.0918




2-9-18
-------
1. Error removed as received so far.
2. How to reflect CreditNotes of manage-stock in CDNR (GSTR1) if  adjusted in 
   sale bills.
   a. GoTo Utils-->FirmsMgmt-->Advance-Parameter-->CR Note Amt-->No-->Take-Separate.
   b. Adjust creditnotes in bills.
   c. Press  <%> on salebill table to enter old bill reference and to define 
      wether it is to be taken in cdnr or b2b (For registered parties only) 





17-7-2018
----------
1. Error removed as received so far.
2. Ledger import from excel sheet. (May be used to import
     bank ledgers for personal accounts or if required.)
  
   (You need to enter systemcode of counter account in a separate column
     of bank ledger of excel format.)




13-7-2018
----------
Ammendments in EWAY-BILL generation( Ver 1.0.0618)


How to import Accounts and items in saral by xlsx files

1. Open account xlsx file  
2 . Make separate xlsx files for Company,Distributor,Customers, and other accounts schedules as shown in
    Utils-DataInOut-->Create master data from external format.
3 . If company not found in accounts , then create separate company xlsx file from item master's
    company column by remove duplicate rows function of xlsx.(ExcelMainMenu-->Data)
     Now you have five xlsx files for company,customer,supplier,and items and batches.
    if you have one file for item names and batch stock. make it to items and batches separately. and 
    remove duplicate rows in item file by item name.

(Now you may have company.xlsx,supplier.xlsx,customer.xlsx,items.xlsx,batch.xlsx separately)

(It is preferable to open other accounts mannually in saral)
4 . Open expiry date column of batch.xlsx and change its format to dd-mm-yyyy and resave.

Find out unique key column no. for each xlsx file and write down.if not found unique column then
insert a new column and fill it uniqe nos.
 

5. Save these in different csv files  (CSV (Msdos) by save as option of execl.

6  again open  xlsx files say customer.slsx, insert blank row in the top.
7. enter column nos. in this xlsx file eg. for column (A) enter 1 ,for column(B) enter 2
 

8. Repeat above steps for all files.

9. Create a new firm (accoarding to firm type)
10. Go to Utils-DataInOut-->Create master data from external format--> company

11.  Create a new external source (1-9) type (CSV) then select field-mapping.
    MainFile-->Company.csv (with path)
12.  Enter Fieldmapping for suppliers,customers,items and batches. Key column must be defined
     for items and batches.
    For expiry date type field mapping enter it as  (ColumnNo!D2) eg   14!D2   where 14 is column no of 
     expiry field and D2 is date type dd-mm-yyyy (other date fields are found by pressing <F2>
              on field mapping screen.
13.  Select sales and purchase heads of misc items from multiple change field menu of items advance-mgmt

14.  verify test data.




26-5-2018
----------
steps to define eway bills entry.
    1. outward-->bills-mgmt-->date
      on the list of  sales bills  
      press # to  enter eway bills information .
      you may select  more sales bills for the single eway bill.
      then create eway bill from 
      1Report-->GST Report-->Eway bill
    
After generation of ewaybill on gstin portal , you may enter
its no. by $ on sale bill list and in other details in purchase.




23-5-2018
----------
1. Error removed as recd. so far.
2. New version of EWAY-bill format implemented this may be
   converted to eway-bill.
3. E-Way-Bill JSON convertor is available in SaralGSTReportConvertor setup.

4-4-2018 (For medical retail only)
---------
1. Define TB drug in item mgmt.
2. Define other details in TB patients bills
3. An excel report is added in 1Report-->RegisterSales-->ItemWise
   output no. 008 (3)


2-4-2018
---------
1. In purchase to add itemwise/bill wise extra amount to 
calc net price of item but not the part of invoice.

1-4-2018
---------
1. Upload epl as removing errors recd. so far.
2. An additional column of applicable  tax % in gstr1 
   reports has been added. 


16-2-18
--------
1. Upload epl as removing errors recd. so far.
2. A new setup to convert GSTR1 CSV files in to single
   excel offline template and JSON format for ready to upload.



7-2-18
-------
1. In Dealers-Mgmt , some more fields are added.
    LedgerHead: All accounting transanctions are maintained
                in this head , it may be used if place of supply
                is different from debiting/crediting dealer. 
    City: Used in Eway bill
    PIN : Used in EWAY bill.
2. # key is available on bill table  to define E-Way bill 
   entries.

3. Bulk Eway bill csv added in GST-Report.

4. <F4> and then <F4> key is available on bill table to
    check / adjust balance of bill due to payment vouchers
    and debit/credit notes created in GST Regime.

5. LedgerHead GSTIN and address variables in bill format 001

6. GSTR1 corrections as received so far.

7. Effect of LedgerHead field into quickledger,general kedger
    daybook,unpaid bills,outstaing report,Statement of account
   trial balance and other accounting stmts.

   










28-12-17
---------
A note on reverse gst charges.

 Purchases from unregistered dealers may attract GST . 
  Purchases may be services(expenses) or goods. While entering purchases in inward option you should make reverse     charges option-Yes.
  A credit entry of  Reverse Charge Payable will be added automatically in bottom charges(F7) of purchase bill.
and this will be reflected in gstr1(b2b) with self gstin.




15-12-17
--------
Selective option in GST reports.





12-12-17
--------
How to enter expenses , which attracts GST?

  Ans: Expenses subject to GST are treated as purchase of services (P & L) , and these 
       will be entered in Inward-Purchase section.

       Steps:
         1. Open new expense account eg. named Audit Fees in group "G" (Goods and Services)           ,HeadType->GST,AcType-->IndirectExp/Inc  (Accounts->Accounts Mgmt)and select GST heads                  associated to this account  .

         2. Open a new item named Audit Fees in (Items->Items Mgmt),ItemType->P & L Items
            with associated GST ac as pre-opened. Other item entries may left N.A.

         3. Enter invoice of services in Inward->DocType-->Purchase, taking item audit fees.
            Only amount need to be entered for this type of items.

         4. Always use latest version of SARAL software available on www.saralerp.com in
            download section. 




26-11-17
---------
*Tax paid rate in opng stock of items
*64 bit backup option



24-11-17
---------
* No need to remove all files of nodes in case of LAN
* Previous output formats activation will not change.
* Amendments as received so far.



22-11-17
--------
*EPLSetup is active for auto updation of epl.




16-11-17
--------
*Some updations to speedup trade discount entries.


14-11-17
--------
*Import error (sales/purchase) rectified
*GSTR1 error rectified.

13-11-17
-------
*Create/modify series error removed
* Backup for VDOS interface(64 bit) using RAR type files.
* Correction in load backup.

12-11-17
---------
*Removed errors as intimated so far.
*Import of single/multiple sale bills from csv format
  created by third party POS software.





4-11-17
--------
* Tab Activated for GST Paid rate on batch table <F3=Modification).


* trade analysis me sale+tax amt rate column corrected.

* Sale return in Mobile/Sim firm.

*  Sale register foramt-2 (Default) format rectified for round off amount

*  New filteration(F7) for dealer type in sales.



Dated: 2-11-17
--------------

1. Not showing second item batch in Retail firm
   corrected.



Dated: 31-10-17

1. HSN code wise stock also available in 1-report-closing stock-new method
   option.



Dated 31-10-17
1. Addition of UQC in Item master
2. Provision for multiple taxrate for single HSN 
   code in HSN summary in GST reports



Dated 30/10/2017
1. Error removed from output 008  item sale sheet 
   for mobile firm(fcode-MOB) with sim/imei no. 



Dated 29/10/2017
1. Updating taxable amount in gstr2.
2. Fixation of discounts while making sale bills.


Dated 28/10/2017
1. Autopick of IGST purchase head from outside purchase if defined in item master.



Dated  28/10/2017

1. Correction in invoice amount of GSTR2.
2. Batch addition of negative qty in batch table . 
3. Errors removed as received so far.




Dated:26/10/2017
--------------

Important
----------

1. For bills/Purchase without items in retail , specify  gst heads of item 
     [00000]--[*****All Items****]

2.  Only amount to be entered in sales/purchase for item types 2,3,4 (Type description as defined below)

3. For Debit/Credit Notes in sales/purchase reference bill no/date to be entered.if date 
   if before six months then return a/c with nil gst picked.

4. If sale return is from taxable person (irrespective of saleable or non saleble goods)
   buyer will give a taxinvoice and upload this invoice in to his GSTR1 (CDNR) section.
   you have to enter this invoice into out
ward->CreditNote-option.ITC will be allowed to you.

5. If sale return is from un-registered/composition person, this will be entered in 
   Outward-CreditNote- taking stocking option Yes or No as the goods return is saleable 
   or not saleable. and return/sale head will be picked accoarding ref. bill date wether
   it is six month before or after. this credit note's net amount effect will be 
   captured into B2CS.

6. If Purchase return to taxable supplier (or inter-sate unregistered more than 2.5lacs). 
   you have to create a tax invoice in outward-->debitnote. taking stocking option Yes or 
   No as the purchase return is saleable or scrap. it will be uploaded in GSTR1 (CDNR) 
   section or CDNUR if intersate unregistered purchase more than 2.5 lacs.

5. If purchase return to un-registered/composition person, this will be entered in 
   Inward-DebitNote- taking stocking option Yes or No as the purchase return is saleable 
   or scrap. and return/purchase head picked accoarding ref. bill date wether
   it is six month before or after. If it is before six months GST will not be reversed.

6. Formats for debitnote and credit note is available in outward option.

7. Item Type (2,3,4) do not attract stock handling. (Type description as defined below)

8. Goods and service tax schedule G Type (0124)  includes in sales/purchase summary
   and trading a/c

9. Goods and service tax schedule G Type (4) includes in P. & L.  a/c

10. One more field ITC available or not is added in itmes management.

11. TRAN-1 format is available in Company stmt-->Stock stmt(New)-->format-tran1->batchwise


   Type of dealers (EPL)
       0. Registerd-IntraState
       1. Registerd-InterState  
       2. Unregistered-IntraState
       3. Composition-IntraState 
       4. UID Dealer-IntraState
       5. UnRegisterd-InterState  
       6. OverSeas
       7. Sez-Dlr-IntraState
       8. ISD-Dlr-IntraState
       9. E-Comm-operator-IntraState  
       A. Composition-InterState 
       B. E-Comm-Intersate
       C. Sez-Dlr-InterState
       D. Isd-Dlr-InterState
       E. UID Dealer-InterState

  Type of Documents of sales
       0. Sales
       1. Credit Note  CR
       2. Refund       RE 
       3. Amend        AM
       4. Debit Note   DB    

  Type of Documents of  Purchase
       0. Purchase
       1. Debit Note   DB
       2. Advance      AD
       3. Amend        AM
       4. TDS/TCD      TD    

  Type of items
       0. TradeItems
       1. Fixed Assets
       2. P. & L. Items.
       3. Trade Exp.
       4. Adv/Ref/Othr
       
   
       
        (ITC available or Not)

   Type of Accounts(G-Group)
        0.Common Goods A/c
        1.Sales A/c      
        2.Purchase A/c
        3.Indirect Exp
        4.Direct Exp
        5.Fixed Assets
        6.Advances  
 


mgsthead:=iif(mgsthead1 $ [0],[4],iif(mgsthead1=[1],[7],iif(mgsthead1=[2],[8],[9])))

esc:=.f.;lp:=.f.;sek:=.f.;tm1:=4;zr:=17;zc:=45;m1:=[Zero-Rated];m2:=[Nil-Rated];m3:=[Exempted];m4:=[Non-GST]
wwarn:=[Pickup method to define tax caculation select= &e ]
  do spc with m1,m2,m3,m4,m5,zr,zc,tm1,esc,mgsthead1,wwarn,10


GST-Payment-Voucher-EntryType
IGST   0
CGST   1
SGST   2
Cess    3
Interest 4
LateFee 5
Panelty 6
Others 7
None  8









date:05/07/2017
-----

  1. How to shift your business in SARAL  GST system.

     What do to:
        1. Assign HSNCode  to each products.
        2. Assign GSTIN to each GST registered dealers.
        2. Assign most applicable sales/purchase a/c to each products.
        3. Change Saling prices as per requirements.
  
       (Above tasks may be done on one by one basis 
          or by bulk  replacements options)

        4. Set GST bill format. 
        5. Start billing.

     How to do:
        1. Copy/Paste your VAT software folder at another location.
           and rename it. eg if your vat software folder is d:\soft
           first copy/paste it and rename to  d:\osoft. your current 
           software folder name may be find from :
           saral icon-->properties-->target folder 
          
         
        2. Copy/Paste epl00.ipz to current software folder. It may be
           downloaded from saralgst.epl@gmail.com (Password: pass@12345)
           
      
        3. Remove old epl00.zip  from current software folder if exists.
      
        4. Rename  epl00.ipz  to  epl00.zip in to current software folder
           and extract it by winrar in current software folder.

        4a. Check date of smain.exe in current software folder it should
            of current sate.  

        5. Modify status of  current business unit : 
                  GST-System -Yes 
                  HSN-System -Yes

          it is done by modifying business unit 
           (in UTILS---->Firm-Mgmt--->Define business unit option)
       

        6. Restructure (by option C) and Reindex current firm.
 
        7. Required (GST) SALES/PURCHASE/TAX/STOCK have been auto
           populated in to your current firm by restructure.


          Now your firm is ready for GST working. 
          -------------------------------------- 

        7. Bulk update of HSNCode from an excel(CSV) file.
     
        Create a items list from repo no. 11 (format-4)
         (ItemsMgmt-->ViewPrint--->List/PriceList-->Select Format-4)
         (In VATFolder you have to enter old soft folder. eg. 
              d:\osoft\adata    (Where A is your current financial year unit)


        (a) Open above CSV file in Excel and Fill the HSNCode and GST Rate 
            columns from the informations you received from your 
            TAX-Consultants and save as csv.
      
        (b) Sync this csv file into 
            Items-->Advances options-->Update Price/HSNCode from CSV/DBF
            (First column no. should be 1,HSNCODE column no.=9,and 
             GSTColumn no.=10

        (c) You have to define the column nos. of above corrected excel(csv) 
            file into input screen.  
            and confirm-Y
                     

                       or  

         you may modify  product's HSNCODE,SALESHEADS,PURCHASE HEADS
         one by one as usual in items Mgmt.
       
   
    (If GST Sales/Purchase heads not sync by HSN-CSV-file then do step-8  ) 
         otherwise bypass)
         8.  Bulk update of Sales/Purchase accounts.
           (a) Modify an item to update GST sales/purchase accounts taking as
              baseitem.
           (b) Go to Items-->Advance options-->Multiple field change
           (c) Defile base item ,which you have already updated.
           (d) Enter Y in entry no 4,5,20,34,35,39.
           (e) Filter items for which GST heads are same as base item.
           (f) Process.
  
    9.  Bulk update of saling/price.         
         (a) Go to Items-->Advance options-->% Change of saling price.
         (b) Enter -300 and and old VAT Folder of software ,which have you
             previously cpoied.
         (c) An excel file is created named PRICELOG.CSV into current
             software folder for verification and checking.

    10. Now your Software is ready for GST. An appropriate print format
        must be active in others-->OutputFormat-->format 001

       (For any querry call to 9414184250(H.O.) 
           or your local service provider.
           or mail to (hcgupta@saralerp.com)  
              
            


         
   