Please enable JavaScript to view this site.

RanceLab Software User Help

Navigation: Sales Management > Transactions

Sale Invoice (Scan POS)

Scroll Prev Top Next More

Main Menu > Sales Management > Transaction > Sales Invoice (POS)

On sale of Items, the seller submits an Invoice for the Items sold.

Sale Invoice affects both Inventory and Accounts. The stock of Items received get decreased. The Customer account is debited by net amount of the Sale Invoice. Sale Account is credited by value of Items sold (net of Discount). Respective ledgers of other accounts (like Taxes) are credited accordingly.

Credit sale line item will be displayed only if the customer selected is marked as debtor in your accounts.

During a basic transaction, product codes are entered or scanned into the transaction and the screen instantly displays the quantity, price, and product description.

When completed, the transaction is totaled, sales tax is applied, change is computed, the cash drawer is opened, a receipt is printed, and inventory and sales records are updated. Many options are available to the cashier during a transaction makingRanceLab a complete and powerful point-of-sale system.

Require Business type field in Sale Display Report

In Sale and Sale Return, Under Display report(Alt+D) , Added a field  "Business Type" in the column chooser

 

Require E-Waybill data in excel or JSON format to upload in GSTN Portal

Scenario:

In RanceLab, As per Requirement, here E-wayBill data in excel or JSON format to upload in GSTN  portal..

Solution:

In Sale Invoice(S-T-S) and Sale Return( S-T-R) Two buttons are added in Display.

E-Way Bill Entry (Alt+W)

E-WayBill Rpt (Ctrl + W)

 

On clicking on the E-Way Bill Entry (Alt+W) button, an input box will open with following.        

Supply Type - Outward / Inward

Sub Type - Supply / sales Return / Line sale / Others

Doc Type - Tax Invoice / Bill of Supply / Bill of Entry / Delivery Challan / Other

Trans Mode - Road / Rail / Air / Ship

Distance (Km)

Trans Name

Trans ID

Trans DocNo        **If transport mode is Air/Rail/Ship than Trans Doc No and date is mandatory.

Trans Date

Trans Type

Vehicle No

Vehicle Type - Regular / ODC

Eway Bill No

Eway Bill Date

 

 

Using button E-WayBill Rpt (Ctrl + W), it will ask to generate Eway Bill Report in Excel or JSON format and report generated will be saved in RanceLabshare folder.

 

In, Sale Register (SRS), Sale Return Report (SRR), added two fields in the column chooser.

Eway Bill No

Eway Bill date

 

Require a generation of E-WayBill using IRN no.

The requirement is Generation of E-WayBill using IRN from E-Invoice API.

 

To achieve Added a button in Sale and Sale Return Display:

IRN - E-Waybill (Ctrl + I)

It will upload Eway bill based on IRN No of the selected invoice and save the Eway Bill no and Date in Fusion.

 

Require E-Invoice as per GST new rule

Scenario:

The government has been introducing the E-Invoice system, which will be effective from 01-04-2020.In this system generation of e-invoice will be the taxpayer’s responsibility who will be required to report the same to Invoice Registration Portal (IRP) of GST, which will generate a unique invoice Reference Number (IRN)and digitally sign the e-invoice and also generate a QR code.

Now, As per GST, new rules need a facility to generate E-Invoice for B2B bills.

Solution:

You can upload E-invoice directly on GST portal by API integration or manually upload the file in JSON format.

 

E-Invoice JSON will be generated for B2B bills only, and it will be saved in the RanceLab share folder. In GST Return (F-G-G),

Added a button "Gen E-Invoice".

It will generate a JSON file for all B2B invoices in the selected date range in the RanceLab Share folder.

Generated files will be uploaded to the GSTIN portal manually.

 

 

In the Sale and Sale return display, two buttons are added here.

Generate E-Inv (Ctrl + G): It will generate the E-Invoice file of the selected Bills.

Update IRN (ALT+I): Using this button you can insert IRN no here

 

API Integration:

As per the GSTN rule, the access to API has been provided only to taxpayers having turnover of more than 500 crores and GSPs.

 

In GST Return (FGG) - “GSTIN Export settings JSON” add  Json as per the sample JSON below.

 

{"JioASPClientID":"ECHRZ9EZHW4SAYH5PH", "JioASPClientSecretKey":"xxxxx-0000-0000-0000-xxxxxxxx", "JioXAPIKey":"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", "JioURL":"https://api-sit.jio.com/asp/core/gstr1/v3/Supplies","AmountLimit":"250000","UploadEInvoiceDuringMemoCreation":"0","EInvClientID":"ABCDEFGHIJ", "EInvClientSecret":"BwWiIT5o1aAM79sSeEyk","EInvUserName":"XXXX-ABC", "EInvPassword":"XXXX@34ds#$%","EInvURL":"https://einv-apisandbox.nic.in","EInvAPIToken":"XXX/auth", "EInvAPIGenerateInv":"/xxxxx/v1.03/Invoice", "EInvPrivateKeyPath":"C:\\GSTDetail\\einv-sandbox.pem", "APIGetEWayBillFromIRN":"/eiewb/v1.03/ewaybill","APIGetGSTINDetail":"/eivital/v1.03/Master/gstin","APICancelIRN":"/eicore/v1.03/Invoice/Cancel"}

 

In Sales Touch POS and Sale Return, saving E Invoice will be directly uploaded to GST portal, and it will receive IRN No, and QRcode of Invoice and it will be saved in Fusion. This IRN No and QRcode are available in Windows print design and can be printed in Invoices.

 

In the Sale and Sale return display, added buttons are added .

Upload E-Inv (Ctrl + U): It will upload the selected E-Invoice to the Portal directly.

Cancel IRN (Alt + J): It will cancel the selected invoice from GST portal.

 

Implementation Note For Cancel IRN

Cancel IRN button will send a cancel request to E-invoice portal.

After cancelling IRN, Fusion updated Cancel’s status for invoice in any UDF(1-10) field.

Create an Item in (MIP), for example, "Cancel Invoice" as service type

Remove all item from the cancelled invoice and add this item "Cancelled Invoice" with 0 value.

 

Require salesperson name in product Info preview

In Sale Scan POS (STS) - In Product Info (F8)

Added two fields in product info preview design 'SalesPerson name' And 'SalesPersonInitial'.

 

 

Template Function to select a bunch of items in one go to speed up the entry of inventory vouchers.

Scenario:

1.During entry in stock transfer indent or physical stock voucher, we need to select many items manually every day, that might be time consuming and erroneous.

2.While selling gift baskets in a bakery with the different items in it with different tax. With template function, you can now select those items in one go.

3.Physical stock entry usually has a fixed number of items. The operator is required to just fill in the qty. You may use the template function to speed up the process.

 

Solution:

The template system is used to create a bunch of items to be used during the entry of inventory vouchers.

 

Template System:

To Create a Template:  Open any supported module. Select required items and then Save Template (Alt + J)

To Modify a Template: Load Template > Modify > Again Save Template with the same name.

To Use an Existing Template:  Load Template (Alt+K): It will show the list of available templates > select the required > it will populate the items.

The load function can be used in running invoice also.

To Delete a Template:  Del Template (Alt+X): It will show the list of templates > select template > It will ask "Do you want to delete?”

To Print a Template:  Prn Template (Alt+Y):  It will show the list of templates > select template > It will print that particular template. You may use this print to stick on the box as a packing list.

 

Supported Modules: The Template Function is available in the following modules:

1. Physical Stock

2. Stock Transfer Indent

3. Sale Order / Sale Invoice (STT and STS) / Sale Challan

 

Notes:

Touch POS: If the item in the template is not on the menu, it will not load because we must have a KOT printer defined in order to make an STT sale.

Item Active or Inactive: There is no check for the active/inactive item while loading the template.

You may also define the qty for each item while creating a template.

If we save any touch POS template without qty then it will load the template with minimum 1 qty.

The template data travels and works in a multi-location environment just like masters.

 

 

Qty Multiplication based on Sweets Box Billing in Scan and Touch POS.

Scenario

In a sweet shop, the customer asks for a customised gift pack of sweets. The choice is variable. The customer first decides on the items and qty to be packed in a box. After the contents of a box are decided, they order the number of this customised box. Now the operator needs to multiply the qty of each item based on the required box. It is time-consuming and also leads to errors. For that, a simpler method is required.

 

Solution:

A button is added: "Multiply Qty".

It will ask for QTY to multiply.

Once the qty is entered, it will multiply the quantity of every item present in the bill.

We will check the "Add Quantity" designation for this functionality.

It will not run in the case of the Prepaid System.

We cannot check the Special Modifier in this case.

Shortcut Key in Touch POS = B

Shortcut key in Scan POS/ Sale Return / Sale Order/ Sale Challan / Sale Order = Ctrl + A

 

How to Implement GST in Sale Invoice (Scan POS)?

Steps:

Go to Tax Master (M A T) > Here Create the taxes as per shown in the above pictures.

Attach CGST+SGST Tax with the Product Master/Sub Group/ Price List.

In Global Option (T A G)

Here Set Place of Supply for GST = Yes > Save

There are two important components which determine the how the GST to be charged on a supply

Location of the Supplier – It is the registered place of business of the supplier i.e. in case of Purchase supplier state code and in case of Sale Company (Location) state code

Place of Supply – It is the registered place of business of the recipient

 

Example 1:

Kolkata Mart Pvt.Ltd’s registered place of business is in Kolkata, West Bengal. It supplies goods to ‘Gupta Confectionery’, whose registered place of business is in Kolkata, West Bengal.

Here, the location of Kolkata Mart Pvt.Ltd’ is in West Bengal and the place of supply is also in West Bengal. Hence, this is an intra-state supply, i.e. supply within the state. In an intra-state supply, the taxes to be charged are CGST and SGST.

 

Example 2:

Kolkata Mart Pvt.Ltd’s registered place of business is in Kolkata, West Bengal. It supplies goods to ‘Singh Retailers’, whose registered place of business is in Mumbai, Maharashtra.

In this example, the location of Kolkata Mart Pvt.Ltd is in Kolkata and the place of supply is in Mumbai. This is an interstate supply, i.e. supply outside the state. In an interstate supply, the tax to be charged is IGST.

It will automatically pick IGST Tax as per the Mapping done in TAX MASTER, shown in the above pictures.