Documentation

LSIM Billit Inventory Management

Please read through to understand how to provision, install and use the LSIM Billit application

If you have any questions that are beyond the scope of this document, Please feel free to email us at support@legacy.net.in.

Provisioning

LSIM is a cloud based application, which is primarily distributed using the Saas (Software as a Service) model. Follow the steps below to setup your LSIM application:

1. To have a free Demo environment provisoned for you, please go to https://lsim.app/demo.html and fill up the details. You will receive an email on the email ID provided once the environment is ready for you.
2. For a new production instance provisioning, please Contact Us. You can also just send us a message through Whatsapp or Twitter as well
3. We will assist you to have the system installed and accessible to you based on the method of installation you choose
4. If you opt for the Cloud based installation, here is what you will get:
   • You will have a dedicated installation of LSIM in an enterprise server, with dedicated database for your business
   • You will be able to access the LSIM application using the URL and access credentials shared with you.
   • You can also install the application on Windows, Linux, MacOS or Android as a Progressive Web App
   • If opted, you will also be able to accesss the application using the Billit iOS/Android application downloadable from the respective App Stores
   • The server capacity and clustering, backups etc can be customized according to the your needs
   • By default, the database backup will be taken once every day, and the last 7 days backups will be available
   • The LSIM software will be automatically updated to the the latest stable version. This will happen in the background, and you will be notified in advance for all updates other than urgent security bugfixes . You can opt out of minor updates, but major updates will be pushed every three months
5. If you opt for the on-premises installation, here is what you will get:
   • A LSIM instance will be installed on your machine (Windows, Linux or MacOS)
   • The installed software version will be the latest stable version available at the time. This will NOT be updated automatically to the next versions
   • The application and the database will reside in your own system, and you will be responsible for the backup of the database
   • The AMC purchase for on-prem install will include all stable software updates, but these updates will need to be installed manually
6. Other than these two type of installation, you can also choose to install LSIM in your own servers/Cloud Account. Please contact us for more details

Install Options

There are various configurations you can choose from to customize your LSIM installation. When you ask for an installation or demo, please specify the below configuration options so that the installation will be optimized for your specific usage

• company_name: The name of your company to be displayed on the application and PDF pages
• pdf_logo: The company logo to be displayed on the login page and PDF pages
• tax_percentage: The GST/Tax percentage to be configured systemwide
• address: The company address to be displayed on PDF pages
• contact_phone: The contact number to be displayed on PDF pages
• contact_web: The email/website address to be displayed on PDF pages
• tax_number: The Tax ID number to be displayed on PDF pages. If tax_percentage is set to 0. this setting is ignored
• currency: The default currency code (eg: INR/USD/AED) for your business
• lsim_env_medical: Use features specific to medical industry like Controlled Drugs, Doctor management, etc
• use_salesman_code: Enable a second layer of authentication to generate invoices
• employee_edit_product / employee_edit_po / employee_edit_expense: Manage privilages for non-admin users
• ui_auto_bg_color: If enabled, the background color will be generated using the other color settings (using the settings screen). Otherwise, you will be able to select from a list of background images from settings page

Apart from these settings, there are various settings you should decide based on the size of your business. The below settings will affect your subscription. In case of an on-premises install, the max settings can be set to a much bigger number if needed

• multi_branch: Set this to yes if you have multiple branches or offices and you want to manage all of them in one LSIM install
• max_products: The maximum number of products (including inactive/deleted) which can be created in the application
• max_users: The maximum number of user accounts
• max_accounts: The maximum number of Accounts.
  Note In an multi-branch environment, the max_branch value should be including the one accout created by default for each branch
• max_employees: The maximum number of employees which can be added to the system
• max_branches: The maximum number of branches
• use_workorders: If set to true, Work Order feature will be enabled
• use_barcode: If set to true, Barcodes will be enabled, and the below settings specific to barcodes will take effect
• barcode_prefix: Constant PREFIX for all barcodes
• barcode_seq_start: SEQ value for the first product
• show_price_on_barcode: Price on barcode print
• show_companyname_on_barcode: Company Name on barcode print
If barcode feature is enabled, product codes will be autogenerated, and is recommended to keep it that way unless you want to add a third party product code or barcode.
• patient_records: Enable keeping medical records of your users/Customers
• rc_invoices: Enable Rate-contract Invoicing feature
• wholesale_price: Enable wholesale and retail billing in a single system
• plu_integrated: Enable Programmable Weight Scale Integration
• product_packs: Enable Multiple sized packs for single product
• fleet_management: Enable Fleet Management feature

Additonal features and options will be added to LSIM Billit as we keep on releasing newer versions of our product.
Please contact us for an updated list of various options available for the user

Initial Configuration

Once a new environment is provisioned for you, you will receive a welcome email from Legacy Systems (support@legacy.net.in) with the below information

Application URL: https://<Your_Domain>.lsim.app
Activation Code: <Activation_Code>
Activation email: <Activation_Email>
Username: <username>
Password: <lsim_admin_pwd>

LSIM Activation Process

• Click on the application URL. You will be presented with the Terms and Conditions and Activation Form
• Agree to the Terms and Conditions
• Enter your name / Company Name
• Enter Activation email and activation code
• Click on the Activate Product button, and you will be redirected to the login page
• Use the username and password received to login

Things to do before starting to use the application

• For Multi-Branch Environments only: Create branches

  A branch with name default_branch will be created as part of provisioning. You should create your own branches

  • Goto Administration > Branches > New Branch
  • Fill out the details
  • Select if this is a master branch or not
    NoteUsers who are assigned to Master Branches can view data from all the branches, as well as change branches for some entities such as Estimate, WO, PO etc

• Create your own user/s:

  The user lsim_admin is an internal user created as part of provisioning. You should create your own user

  • Goto Administration > Users > New User
    
    • Select app_admin as your user type to access all the features.
    • Select a master branch as this user's branch if this user need to have access to all branch data
  • Logout and login as the newly created user

  Make sure to select the correct Role for each user. "App Admin" user will have access to ALL part of the application

• Create product Categories:

  There need to be at least one product type/category to add products

  • Goto Administration > Product Category > New Category
    
    • Select a unit and tax percentage applicable for each category

• Create Expense Types:

  In order to record business expenses, you will need to add Assets to the system, upon which expenses are added later
  Before that, make sure you add the application expense categories for each kind of assets.

  • Goto Administration > Expense Types. Add expense type for each type of assets by click on Add new Expense Type

  You might need to add the same Type for different Asset Types. This is OK and the reports will consolidate similar expense types
  For eg: You might need to add Expense Type "Rent" to both "Real Estate" and "Vehicles", if applicable

• Install LSIM as a Progressive Web App (PWA) - Optional:

  Installing LSIM as a PWA will enable you to treat this as a native app (create shortcuts, dock or taskbar icons etc) and you can enable desktop/mobile notifications as well

  • To install LSIM as PWA, open the URL in Google Chrome or Microsoft Edge Browser
  • You will see a "App Available" prompt on the right hand side of the address bar. Click on it to install PWA
  • If the label is not visible, click on the PWA install icon on the right side of the address bar, next to bookmark icon
  • One PWA is installed, Login and Goto Administration > Settings and Click on Enable Push Messaging to enable Desktop notifications

LSIM Customization

We have included a number of settings which can be changed from the UI. All these settings are systemwide and will take effect immediately after change
Goto Administration > Settings

• report_duration_days: This setting decides how far back the data will be desplayed on each page (the value for start date will be report_duration_days older than today)
• items_per_page: This setting is used by the paginator to display data in pages. This value determines the number of records displayed in a single page
• product_expiry_warning_days: For products with expiry dates, you will see a notification on the Products page if any Stock batches has expiry date which is within this many days from today. In Stock Batches screen, these batches will also be highlighted in Orange color.
• product_expiry_critical_days: If the expiry date of any Batch falls within this many days from today, that batch will be treated as expired, and will NOT be considered for invoicing (Stock will not be used). You will see an Alert notification for these batches in the Products page, and this batch will be highlighted in Red in the Stock Batches page.
• A list of Boolean Settings will be available for the user to enable/disable based on requirement. Please make sure to go through each of them and set it according to your needs
• Application Theme Settings: Various UI elements can be customized.
  • UI Accent Color
  • Primary Button Color
  • Details Button Color
  • Secondary Button Color
  • Warning Button Color
• Font Settings: You can customize fonts for Heading, Body and Table content individually
• PDF Settings: This section has the below settings for your PDF files
  
  • PDF Print Type: This setting will dictate whether the Estimate, Invoice, Work Order and Purchase Order PDF are printed in A4, A5 or thermal printer size. All other PDF's are always printed in A4 size.
  • PDF Header Accent Color: The background color for PDF header
  • PDF Table Accent Color: The backgound color for PDF table headers

  "Balance Report" will always be printed in A5 PDF

• Display Style: This setting determines whether the contents are displayed as a table or cards. For mobile, the display style will always be Cards
• Navbar Icons: Icon style on the navigation bar can be customized
• Button Style: Button shape can be customized to have rounded or squared edges
• System Notifications: You can enable or disable desktop/mobile app notifications for various actions
  You will also have an option to receive a daily summary of your Balance Report at a set time
• Depending on your application version, some additional settings may also be available in your settings page

Logo Settings

Your company logo can be displayed on the Login screen, Navigation bar and all PDF documents generated

Depending on your subscription, you will be able to customize logo from the "Custom Media" section of the settings page

Application UI Layout

LSIM app layout contains a top Header (Navigation Bar) and a content area

Header

The header will have the company name, LSIM Menu buttons, and Quick access Area

The quick access area contains the global Product Search, Notifications, Admin, Dashboard, Accounts, Settings, About and the User Profile

LSIM Menu

LSIM Menu is the central point of Navigation. On mobile, you will have a burger menu on top, wheras on Dekstops, the Menu will be right next to the Company name

Clicking on any of the Menu item will change the Menu name to that particular Page Name

You also have a "Create" Menu right next to the main Menu, and also for Admin Users, Reports Menu will be available

Depending on the configuration, users will have access to two shortcut buttons: "Cash Sale" and "EOD Report"

Content Area

The main content specific to the current page will be displayed here. The content will be displayed as Table or Cards, depending on the value of setting Display Style

Depending on the page you are in, the content area may contain the below regions

• The Page title
• Filters
• Shortcuts
• Main content table or cards

Additional Content

Usage

This section provides information regarding the usage of LSIM

General Workflow

LSIM application consists of the below entities:

• Branch
• Product Category
• Asset
• User
• Employee
• Vendor
• Customer
• Product
• Estimate
• Invoice
• Adhoc Invoice
• RC Invoice
• Work Order
• Purchase Order
• Expense
• Account
• Transaction
• Fleet Unit

Most of the entities support the Create, Edit, Delete operations, except:

• Product Types, Vendors, Expenses and Account Transactions - cannot be deleted from the UI

If any of these entities need to be deleted, please contact support, and they will help you with this

To Create a new entity, go to the entity page and click on the Create button on the top right

To Edit an entity, click on the edit button against the specific entity
NoteFor some entities like Estimate or Purchase Order, Clicking on the entity button will lead you to the edit page

To Delete an entity, open the entity page and click on Delete

You can also mark and entity Active or Inactive using the respective button in the entity table, if available

Users and Roles

When you create a new user, or edit a user, you can change the user Role and user Branch

User Roles

Depending on the system configuration, various roles can be assigned to a User.
Some of the User Roles available are:

• Basic Roles
  
  • App Admin: The "ROOT" User. This role has access to all application functions, including User Management
  • Employee: This user will have all the access required to record a sale
• Advanced Roles
  
  • Accountant: Access to accounting functions and related reports. This use can also view and manage company accounts statements
  • Purchase Manager: Access to add/update product price, product info and stock, vendors, add stock purchase info, Set product offers etc.
  • Sales Manager: Access to manage salesman users (Employee Role), Control invoicing and Estimate locks, Monitor EOD report etc.
  • Delivery Person: This user usually has the minimum access and is restricted to collect payments and returns, add expense etc.
• Special Roles : Depending on enable modules, you will have access to various additional roles with specific privileges
  Please contact us for more information

Only App Admin user will have access to add/modify User accounts and roles

User Branch

You can also select the Branch for the user.
If the branch assigned to a User is a Master Branch, the User can access entity data from all Branches.
Master Branch Users can also transfer Product Stock across different Branches.
If the branch assigned to a User is not a Master Branch, the User can only view and modify entity data from that particular Branch. They can, however view the Stock of Products from all branches

Products and Stock

For each product, you can specify a unique code, name and description
For systems using barcode scanner, the barcode string should be set as the product code.
You can also specify the retail price, wholesale price (if enabled), minimum price, and various other options for a product

When you add a new Product, you will have to specify if the Product has serial numbers.
For a Product with Serial Numbers, we can only add Stock as an Integer with all the serial numbers also provided during stock update.
By default, when a Product with Serial Numbers is added to a Estimate, and an invoice is created from that Estimate, the system will pick up the serial numbers from stock automatically.
If the product is added to the Estimate by scanning/searching the serial number itself, the subsequent invoice creation will use the same serial number, unless the specific S/N is not sold already or added/scanned to another Estimate.
If you want to manually select a specific serial number, you can edit serial numbers after the invoice is created from the Invoice page.
You will also need to provide all serial numbers to be added to Stock for the product when a Purchase Order for that product is Marked Delivered.
If there is no need to manage serial numbers in stock, please create products without serial numbers. You will still be able to create/add serial numbers after the Invoice is created. The Products page have options to Edit, View and Change Status for each Product.
When a Product is marked Inactive, the product will be moved to Inactive Products page, which is accessible through Menu > Administration > Inactive Products
The Product View page also has an option to Delete the product, which will reset the product stock to 0, along with moving it to Inactive Products page.
To permanently delete a product, you will have to first delete/mark it Inactive, and then go to the Administration > Inactive Products page and click on Delete Permanently

If deleted permanently, all associated PO, Estimates, Invoices will be updated with Product name "Deleted Product". Please use this option with caution

Add Stock to a Product

When you click the Delivery button on any Purchase Order, the product quantity in that PO will be added to stock for all Products in that PO
If the PO have products with Serial Numbers enabled, you will have to enter all serial numbers to mark the PO delivered and update the Stock
If the PO have products with Expiry Dates enabled, you will have to enter the Batch ID and expiry date when marking Delivered. You will also have the option to change Prices for that particular batch.

Product Price update on PO Delivery

Even for products without separate batches, we have an option to update the product's main Price details with that specified in the current PO on marking the PO Delivered.
For that, select the option: "Update In-Stock price of Products" on the Delivery Confirm pop-up

Add Stock to a Product Manually

Goto the product page and click on Add Stock.
Enter the Stock to be added and click Submit
If the User's Branch is a master branch, there will be also an option to select the branch to which this stock is to be added.
If the Product has serial numbers, you will have to fill the serial numbers for all the new stock being added.
If the Product has expiry dates, you will have to provide a batch ID and expiry date as well. If the batch ID you entered already exists for the product and branch, the expiry date will be populated and you can change the expiry date if needed.
Note If you change the existing expiry date, it will be effective for the entire batch including older stocks.

If you want the prices of stock being added to be added to the Account as well (as an out-going transaction), instead of manually adding Stock, use Purchase Orders

Transfer Stock of a Product

For a multi-branch environment, you can transfer product stock across branches.
To do so, click on the Stock display button from Products table for the specific product. A pop-up window will show Stock of that product in all branches.
If the User's branch is a Master Branch, a Transfer Stock button will be available.
Clicking on the "Transfer Stock" button will show a form in which you can select the Source Branch, Target Branch, and Stock amount to be transferred.
Click on Confirm Transfer button will transfer the stock from Source Branch to Target Branch.
If the product has serial numbers, instead to Stock Amount, all the serial numbers currently in stock at the Source Branch will be displayed, and you can select the serial numbers to be transferred to Target Branch.
If the product has expiry date, you cannot transfer stocks across branches. In that case, goto the Stock Batches screen for that product and manage (delete/add) Stock Batches and Serial Numbers manually.

Products with Expiry date

When adding a new product, you can select the checkbox "This product has Expiry Date" to manage all stocks of the product keeping the expiry date in consideration
You cannot edit an existing product without expiry dates and add expiry date to it. This has to be set during the creation of the product.
The Stock for a product which has expiry date is managed as Stock Batches, with each Batch corresponds to a particular expiry date. You will be required to provide Batch ID and Expiry date whenever you add Stock to a product with Expiry date.
When a new stock is added with an existing Batch ID, the expiry date will be auto-populated with the value already saved. You will also be able to change the expiry date, in which case the expiry date of the entire batch will be updated with the new Expiry date value.

Invoicing of products with Expiry date

If there are multiple Batches in the branch, Stocks will be taken from the Batch with the earliest expiry date for invoicing. If the Stock in that Batch is not enough, the next batch with earliest expiry date will be considered for the rest of the stock, after using the stock from the first batch.
There are two settings which decides the behaviour of invoicing and notifications regarding Expiry date:
product_expiry_warning_days : If the expiry date of any Batch is within this number of days from today, a warning notification will be shown at the Products page. The Batch will also highlighted in Orange in the Stock Batches Page.
product_expiry_critical_days : If the expiry date of any Batch is within this number of days from today, the batch will be considered expired, and will not be considered for Invoicing. You will get a "out of Stock" error even if you have stock in this Batch, and no stock in other Batches.
The Batch will be highlighted in Red in the Stock Batches page

You can also select the Stock batch of each product manually from an Estimate.
The system can also be configured to prompt the user to select the Stock Batch as soon as the product is added to the Estimate, by displaying the Batch selection pop-up.

You can only select one batch per product in a single Estimate

Customers

For customers, along with the contact number, address and other details, you will also be able to specify a Credit Period, which is the number of days to give credit to the customer.
Customers page will have options to Edit, View and Change Status for each Customer.
You can also store various Customer custom information and Documents, if enabled.

Customer Account

Similar to the Company Accounts, the system will maintain a separate account for each Customer.
This account can be used to keep track of the amount pending or excess for each Customer
If there is excess amount in a Customer Account, it will be used for settlement as soon as an Invoice is created for the Customer
There is another balance maintained with each Customer, which will keep track of Sales returns for the Customer.
This Return balance will NOT be used for automatic settlement, but can be used to manually settle individual Invoice.

We can configure the system to settle the sales return balance automatically or manually

Customer Blacklist

If enabled, Customers can be flagged as "Blacklisted" with a note, which will be visible on the Customer information page

Invoicing

Creating a new Invoice is a 2-Step process in LSIM. First, prepare a new Estimate and then generate Invoice from the Estimate.
To create a new Invoice:

• Goto Estimates > New Estimate. You can also use the Cash Sale Shortcut from Top bar if enabled, or New Estimate button from a Customer Page
• You will be asked to select a Customer. Customer can be selected from a drop-down list, or you can enter the customer's mobile number in the field above.
• If a Customer is not found with the entered mobile number, you will be redirected to the customer creation page, and after creating the customer account, click on New Estimate again to create Estimate
• If "Cash Sale" button is used to create a new Estimate, the Estimate will be assigned to "Cash Customer". You will be able to edit the customer and select a different one.
• You will be able to select the branch for the Estimate if your user account is assigned to a Master Branch
• In the New Estimate screen shown below, you can add or delete products to the Estimate



• Product can be added either from the drop-down/popup list or by searching in the field above by the Product Code
  Note If Auto Save Estimate is enabled in Settings, the estimate will be saves as soon as it is created
• For systems using barcode scanner, the cursor will focus automatically on the product search field, and upon scanning a barcode, a search for the product with the code will be done and if found, the product with quantity set to 1 will be added to the Estimate
• For PLU integrated systems, LSIM will detect PLU barcode automatically and add the appropriate quantity of the product to the Estimate. The PLU code initial sequence and delimiter should be already configured in LSIM
• If a Serial Number is scanned/searched and added to Estimate, the subsequent Invoice will select the serial number scanned, unless the serial number is already sold, or scanned again for another Estimate
• Added products will be displayed in the table below. All amounts will also be updated accordingly whenever you add or delete a product. You will not be able to edit the quantity in the New Estimate screen, but you can change the quantity from the Estimate edit screen after the Estimate is saved.
• Clicking on Save Estimate button will create the Estimate and show the edit Estimate page
• You can still make changes to the Estimate and generate PDF for the Estimate



• After adding products, you will be able modify the price and quantity for each products. Clicking on the update button corresponding to each row will save that particular row for the estimate and update the total Amounts
• The tax amount for each product will be calculated based on the tax percentage set for the particular product type and whether the product price includes tax amount (set in the product page)
• Once the Estimate is finalized, click on Create Invoice button to create Invoice.
• You can also copy the Estimate to a different customer from the Estimate View page
• If sufficient stock of all products are available, a new Invoice will be created, and you will be redirected to the Invoice View page, from where you will be able to make any payments, create PDF or delete the Invoice
• All serial numbers assigned to an Invoice will be displayed in the Invoice page, which can be changed if needed. The new serial number also should be available in stock for the specific branch to be able to update the Invoice
• Click on Payment button to add payment to the invoice. You can select the account to which the payment need to be added in the Add Payment screen.
• All the payments made for an Invoice can be viewed in the Invoice page, and you will be able to print the Payment Receipt for each payment

NoteIf the application is closed before creating a new Estimate, all data in the prepare page will be lost. However in the Edit Estimate screen, all changes you make (adding/editing products, discount etc) will be saved instantly.

NoteIf the Invoice Amount is to be reflected in Accounts, you should add/update payments made for the Invoice by clicking on the Payment button in the Invoice Page

NoteIf enabled, Multiple Invoices can be created from the same Estimate. You will also be able to view the invoices created from a Estimate in the Estimate view page

NoteIf setting use_salesman_code is enabled, you will need to enter a valid salesman code and PIN (assigned to each application user using the User management page), and the invoice will be considered to be created by that Salesman irrespective of the logged in User

Estimate Lock/Unlock

Lock/Unlock of Estimate will help prevent unauthorized changes to an Estimate.
Once an Estimate is created, the sales_manager will be able to Lock the Estimate. Once locked, further changes to the Estimate will be prevented.
The Sales Manager, or the Salesman will be able to "Unlock" the Estimate. Once unlocked, the Salesman will only be able to add new products. The Sales Manager will be able to add new products as well as modify the existing ones
Creating Invoice will Lock the Estimate

Different Types of Invoices

If enabled in your environment, you will be able to create RC Invoices and Work Order based Invoices along with the regular Invoices
For these Invoices also, you will need to mark Payment to add the Invoice Amount to Accounts

RC Invoices

RC stands for Rate Contract
This types of Invoices are ideal if you are billing your clients for usage of Devices owned by you based on the usage amount of each device
To create RC Invoice, you will first have to create RC Devices. Goto Adminstration > RC Devices to create and manage RC Devices
In the RC Devices

Adhoc Invoices

This types of Invoices are ideal if you frequently create invoices with Products or Items which are not in the Inventory and are not needed to be added to the inventory
You can just select the Customer, add products, quantity, price and tax percentage on the fly and Save the Invoice.

Fleet Rent Invoices

If enabled, you can create invoices for Customers based on rental and other parameters of Fleet units (eg: Vehicles).
The process to create Invoice is different for Fleet Rent Invoices, where we first assign a Fleet unit to a Customer, set from and to dates, calculate KMs and other parameters like maintenance and other services, and create Invoice from the Fleet rent entry directly

If fleet_management module is enabled, users will have all the options to manage Fleet units, Maintenance Records, Insurance, Garages etc.

Sales Returns

Returns need to be initiated from the Invoice page
There are currently two flows to file a return:

• Return of products which does not have Serial Numbers in Stock
• Return of a product which has Serial Numbers in Stock

How to file return of a regular Product

1. Go to the Invoice Page and click on the "Returns" button

   

2. The popup will list all the existing Returns for this Invoice. Click on the "Create Return" button

   

3. You will see a return form. Select all products which are being returned, and enter a non-zero quantity. Click on the "Validate Return" button

   

4. You will be able to review the return. If there is any excess amount, you will also see an option to select what to do with the Excess Amount. Click "Confirm Return" button.

   

   • Immediate Payout: Select this option if you are paying back the Return Excess Amount to the Customer.
     You will also need to specify a Company Account from which the Payout need to be deducted and select a payout method.
   • Future Settlement: Select this option if the excess amount is Credited to the Customer for either automatic or manual settlement in the future.
     If manual settlement is configured, the account and method input is not used here.

How to file return of a Product with Serial Number

1. Go to the Invoice Page. In the Serial Numbers section, click on the "Return" button next to the S/N being returned

   

2. In the next popup, select the appropriate options, and Confirm the return

   

3. If the payment is already received for the product being returned, select the Accounts option and depending on the whether the amount is being returned immediately, select the next option below

Purchase Orders

Purchase Orders should be used to add stock to product and add the Purchase transactions to the Account at once

Once a product is added to a PO, you can edit the product to edit its Prices, which can then be updated to the Product in Inventory while the PO is being marked Delivered. We can configure to update the product prices from PO by default, or manually select this option for individual Purchase Orders

The process of creating a Purchase Order is similar to that of creating a Estimate. There are some differences in Purchase Order:

• You will need to select a Vendor instead of a Customer for PO
• You will be able to select the branch for the PO if your user account is assigned to a Master Branch
• Once a PO is created, you will be able to mark it as Paid and Delivered. You can also partially pay for a PO, in which case the status of the PO will remain "not-paid". The amount to pay, by default will always be the balance you need to pay for the PO.
• Once a PO is mark Delivered, you cannot make any more changes to the PO
• Once the PO is created, you cannot change the Branch for the PO
• You will be able to update the PO with the respective Invoice ID, if available
• If the PO contains products with Expiry dates, you will need to enter the batch ID and expiry date for each of those products once you mark it as Delivered

NoteWhen you mark a PO as Delivered, the stock will be updated for the products listed in the PO with the respective quantity, along with the Serial Numbers, if any. You do not need to manually add stock in this case.

NoteIf the PO Amount is to be reflected in Accounts, you should add/update payments made for the PO by clicking on the Payment button in the PO Page

Accounts and Expenses

Accounts

You can keep track of all your business expenses and keep a ledger for multiple accounts using Accounts and Expenses in LSIM.
By default, when a new instance is provisioned, there will be two accounts created - Primary Account and Cash Account.
Whenever a new Branch is created, a new Cash Account corresponding to that branch will also be created, but the Primary Account will remain common to all branches.
For all PO and Invoices, whenever a payment is added, a corresponding transaction will be added to the selected Account with the respective transaction type.
You can also manually add a new transaction to an account from the Transactions page for the Account. The usual Print to PDF and CSV Export buttons are also available in Transactions page, along with the Start date and End date selectors.
You can also Edit an Account to add more details like Bank Account Number, MICR code etc.

Expenses

In order to record business expenses, you will first need to add Assets, and Expense Types. Please see Initial Configuration for more details.
An expense should be added on an Asset, and you will be able to create PDF reports or CSV export from the Expenses page.
All expenses are added to Accounts by Default. There is not seperate Payment step for expenses, unlike Invoices and Puchase Order

NoteYou cannot delete or modify an Account transaction. Create adjustment transaction from Accounts Page if needed. You can, however, delete an expense transaction

Salary Expense

Add Employees in the Employee Management Page (Administration > Employees)
In the Employee page, you will be able to add a new Salary Transaction, which will also be added to Expenses and Accounts

NoteYou cannot delete or modify an Account transaction. Create adjustment transaction from Accounts Page id needed

Account Statemet / Trial Balance

For each Account, you will be able to generate an account statement by providing a start date and end date.
Goto Accounts > Select Account > Click on Statement

Administration

Administration page is where you will be able to make changes to the root components of your LSIM environment like changing common Terms/Conditions, modify Branches, Manage Employess, View Diagnostics etc. You will also be able to view your LSIM instance Activation Details from the Administration page

NoteDepending on the logged in User's role, the Administration page option might be different

Terms and Conditions

Goto Administration > Terms and Conditions page to add or delete terms and conditions which are to be printed on all Invoices or Estimates PDF

For each Terms entry, you will be able to select if that particular Terms is to be displayed on Estimate, Invoice or both

Terms/Remarks can also be added to individual sales Estimate, which will be printed on the corresponding Estimate or Invoice PDF along with the common Terms and Conditions.
To add Terms/Remarks to specific Estimate or Invoice, click on the "TnC" button in the Estimate page

NoteTnC on individual Estimate/Invoice cannot be modifed once the Invoice is created

Users, Vendors and Employees

You will need to add Vendors to create Purchase Orders. Users and Employees also can be managed from the respective views.
In the Employee View, you will be able to view all Salary transactions for that particular Employee
In the Vendors page, you will be able to view Purchase Orders for each vendors.

Product Category

Product Categories are how you specify the measuring unit, and also set tax percentage for each category or products
Create Product Type specifying the measuring unit(count, weight length etc.) and then create Product with the respective type, so that the proper unit will be displayed in Estimates, Invoice and PO

Assets and Expenes Types

By default, the below listed Asset Types will be created for you:

• Real Estate
• Vehicle
• Office Device
• IT Infrastructure
• Others

• Goto Administration > Expense Types
• Select the Asset Type from the drop-down to view and edit the Expense Types for that particular Asset Type. You can also add or delete Expense Types to a particular type of Asset.

Auditing

Auditing of specific events are enabled by default. These events include Delete event of Customer, Invoice, PO, User.
A audit record of all login events will also be saved with the username and IP of the client machine

Reports

LSIM has an extensive reporting framework which will enable you to have a multi dimensional view of your business

LSIM Dashboard

Gives you Daily, Monthly and Yearly Summary of your business. Each Dashboard card will also show you the historical performance in both tabular and graphical mode

LSIM Reports Menu

Click on the Reports on the Navigation bar, and depending on the user role, you will have access to all LSIM reports.

FAQ