How to import sales bill upload in retaileasyoncloud?

How to import sales bill upload in retaileasyoncloud?

Bill Upload in Sales Bill Screen

This feature will help to bulk upload items of a bill either by mentioning the manually created serial number or ean code or batchwise barcode or piecewise barcode. Also there is option to upload items in bulk based on item code or item alias code. This will eliminate the need to scan items one by one and finish scanning all items at one shot. 


The process is as follows:-
1. Go to Sales Bill screen and click on Ctrl+Shift+F8 function key 'Sales Bill Upload'. 
Note:- Customer is mandatory for this feature. 

1HP

2. New modal opens up and in the drop down you will have 2 options - "Serial No Wise" and "Item Code Wise" upload. 



Fields Description:-

Field NameField Description
SERIAL NO / EAN CODE / BATCHWISE BARCODE / PIECEWISE BARCODEMandatory only for SerialNo wise uplod. We can mention either manually generate /auto serial, Eancode, batchwise barcode or piecewise barcode generated at the time of inward.
QTYQuantity
BATCH NOBatch number given at the time of inward. Works based on configuration in Item Master.
EXPIRY DATEExpiry date of the item should be mentioned only in DD-MM-YYYY format. Works based on configuration in Item Master.
RATEselling rate of item.
ITEM DISCOUNT %Mentioned only item discount % and not amount
TEM CODE / ALIAS
Works based on "Enable alias code search for item" configuration. If enabled, then will load based on alias code and if disabled, then will load based on item code.
UOMWill take value from sheet and if not mentioned, will take base UOM

Item Serial/Eancode/Batchwise barcode/piecewise barcode upload

1. Choose 'Serial No wise' option from the dropdown and the information about fields will be explained under note. 



2. Click on sample template link to download the template with headers. 



3. Fill the details required in the sheet. 



4. In the 'Choose a file or drag it here' section, click and upload the file. 



5. If the upload is success then the items will start scanning and added in the grid. 




6. Click 'Save' and proceed to save the bill. 


Item Code / Alias Code upload

1. Choose 'Item Code' option from the dropdown and the information about fields will be explained under note. 


2. Click on sample template link to download the template with headers. 

3. Fill the details required in the sheet. 


4. In the 'Choose a file or drag it here' section, click and upload the file. 


5. If the upload is success then the items will start scanning and added in the grid. 


6. Click 'Save' and proceed to save the bill. 

Failure Case:-
Incase of failure then the error will be displayed in the modal screen and provision to reupload is given using which you can upload the correct details. 

    • Related Articles

    • How to Import Sales Quotation in RetailEasy On Cloud

      How to add multiple items for a particular customer in a Sales Quotation? In the Sales Quotation screen, you can use the Import SQ option to add multiple items for a customer. Steps: Select the Customer and Press Shift + F2 Import SQ option to open ...
    • Function key in sales bill

      How to Print Sales Bill in Retaileasyoncloud? To Reprint the Bill from Sales bill screen itself 1.Go to SALES ->SALES BILL -> F7(VIEW) and select the bill, it will load in the sales screen. 2.Click on F8(PRINT) and click on ‘OK’ to print the bill. ...
    • How to do Delivery Note Return upload migration in RetailEasy On Cloud

      DeliveryNote Return Upload Migration Purpose : The Delivery Note Return is a form used for stating the detailed information about the goods to be returned to the seller after purchase. With the help of the Master Migration method, we can update the ...
    • How to View sales bill in RetailEasy On Cloud

      Purpose:Viewing the sales bill helps to view the bill details from the screen of all the details. We can also take a print out from the view sales bill mode. Steps to View a Sales Bill 1.Navigate from "Dashboard" -> Sales > Sales Bills, 2.Click on ...
    • How to Reprint a Sales Bill in RetailEasy On Cloud

      Reprint a Sales Bill To reprint the details of a Cancelled or Delivered Sales Bills After clicking Sales > Sales Bills, Press F7 or click View. Bill Details pop-up appears. The Type indicates payment type i.e CA ~ Cash, CC ~ Credit Card, CH ~ Cheque, ...