Loading time...

Ctrl + /

Search Results

Showing matches across all categories.

Navigation Paths

Hierarchical flow diagrams for ERP processes.

Hierarchical Path

Gate Entry | Day to Day Transactions | 3P

Gate Entry process - (3P)

Hierarchical Path

Issue Item

Hierarchical Path

Consumption | Issue Production | DCR | 43

Hierarchical Path

Log Sheet | Entry | PT

LSSERIES - (PT)

Hierarchical Path

Purchase Order - (PO) | 37

POSERIES | SOSERIES | TRDPO | CCTPO |

Hierarchical Path

Purchase Requisition - (PR) | Indent | 3E

PRSERIES

Hierarchical Path

Goods Receipt Note - (GRN) | 30

GRNSERIES | GRISERIES | GRRSERIES | RCMRG | UNRCM

Hierarchical Path

Purchase Bill Passing/Booking (Accounts Dept.)

PBAST | PBP SERIES

Hierarchical Path

JV | Valuation

Valuation Process

Hierarchical Path

Delivery Challan - (DC)

T0001 | DC

Hierarchical Path

Delete Debit Note/ Credit Note

PDN01 | PDNKA

Hierarchical Path

Expense Entry

EXBO1 | EXBO2 | EXCAP

Hierarchical Path

PO Amendment

Hierarchical Path

Approval Flow

Check users who have approval rights based on document series

Hierarchical Path

Change User Password

Lock and Unlock User Accounts | Create New User | Add User

Hierarchical Path

Bin Create

Bin Create (Location to store Assets and Items)

Hierarchical Path

Add Bin | Tag Bin code to site

Bin for Asset Code

Hierarchical Path

Item Master | Item Tag | Tag Item to Site

Tag Code to the Site location

Hierarchical Path

Add Employee in Dropdown lists

Add employee to dropdown lists in PR/PO

Hierarchical Path

Stock Report Process

Generate stock reports for inventory analysis

Hierarchical Path

Bin Wise Stock Report

Generate stock reports for inventory analysis

Hierarchical Path

Consumption Statement Report

Generate consumption reports for inventory analysis

Hierarchical Path

Structure

Structure for ERP

Hierarchical Path

Check Pending Approvals

Check pending approvals for various transactions

Hierarchical Path

Short Open - (PR/PO)

Re Open. Short open requests for various transactions

Hierarchical Path

Short Close - (PR/PO)

After short close PR appears in Indent status - close section

Hierarchical Path

Item Tag/Excel sheet Tag

Tag items in the system or import tags via Excel sheet

Hierarchical Path

Add Town Code

Add town codes to items in the system

Hierarchical Path

Add HSN/GST

Add HSN and GST information to items in the system

Troubleshooting & Errors

Resolution workflows and database fixes for common ERP system errors.

UI Fix

GST Not Found / Invalid GST Code

Resolves GST-related issues when processing transactions by verifying location configurations.

Database Fix

Reference price lesser or greater than 25%

Update

If the document is saved then modification in ERP is not allowed. You must update in SQL maitemh table.

VIESL_LIVE

-- 1. Verify the item first
SELECT * FROM maitemh 
WHERE im_code = '[INSERT_ITEM_CODE_HERE]';

-- 2. Apply the fix (Sets reference price to 1)
UPDATE maitemh 
SET im_refpric = 1 
WHERE im_code = '[INSERT_ITEM_CODE_HERE]';

System Screenshots

Visual references, error captures, and configuration snapshots.

Overview

BIN stock checking

Screenshot showing how to check does that perticular BIN is availableb or not.

Error

GST Fetch Error

This error triggers when the Party Master does not have a GST code mapped to the selected location.

SQL Query Library

Essential CRUD operations, data extraction, and database modifications.

DML - Read

Check Audit Trail Details

Safe

Use this query to track user actions (ADD) within a specific date range.

VIESL_LIVE

SELECT 
    SYS_INFO, * FROM auditrl 
WHERE DATE_STMP BETWEEN '2026-01-20' AND '2026-01-26' 
AND ACTION = 'ADD';

DML - Read

Get Latest Inventory Receipts

Safe

Use this query to fetch the data in tables.

VIESL_LIVE

SELECT 
    POST_FLAG, *
FROM TRINVS
WHERE DOC_NO = '9999999999'
ORDER BY ID_KEY

DML - Update

Correct Stock Quantity

Caution

Manually overrides the stock level. Always ensure WHERE clause is active.

VIESL_LIVE

BEGIN TRAN;

UPDATE TRINVS
SET COLUMN_NAME = VALUE,
WHERE ID_KEY = '9999999999'

COMMIT TRAN;

DML - Delete

Remove Stalled Gate Entry

Risk

Deletes an abandoned gate entry. Fails if foreign keys exist in POs.

VIESL_LIVE

DELETE FROM TRINVS
WHERE DOC_NO = '9999999999'
AND ID_KEY = '9999999999'

Database Tables

Core ERP table structures and definitions.

Live: VIESL_LIVE Test: TESTDATA

Schema Category

Indent / PR & Workflows

Core tables managing purchase requisitions, transactions, and system audit trails.

trinvs

All the transactions in ERP are stored here for audit and reporting purposes.

spordsch

It stores PR/PO's.

wflowtrn

It stores the workflow of every single transaction.

workflow

It stores authorization workflows for various business processes.

auditrl

It shows who closed, authorised, or created documents.

poindt

It checks if a PO has been generated against the PR/indent.

Schema Category

Purchase Order/PO & Workflows

Core tables managing purchase requisitions, transactions, and system audit trails.

trinvs

All the transactions in ERP are stored here for audit and reporting purposes.

trinvsa

All the transactions in ERP are stored here for audit and reporting purposes.

sporddtl

All the transactions in ERP are stored here for audit and reporting purposes.

poindt

It checks if PO is generated against the PR.

wflowtrn

Document working flow.

wflowtrx

Document working flow.

auditr1

Document working flow.

gsttaxln

Document working flow.

f9brkpdt

Document working flow.

Schema Category

Goods Receipt Note/GRN & Workflows

Core tables managing purchase requisitions, transactions, and system audit trails.

projact

All GRN stored here.

astutltrn

All GRN stored here.

Schema Category

Gate Entry

Core tables managing purchase requisitions, transactions, and system audit trails.

trinvs

All documents are stored here.

schexec

Checks gate entry againts.

geitems

All line level items are stored here.

gsttaxln

All line level items are stored here.

Schema Category

Credit Purchase

Core tables managing purchase requisitions, transactions, and system audit trails.

trinvs

All documents are stored here.

trparty

Checks gate entry againts.

trvchr

All line level items are stored here.

gsttaxln

All line level items are stored here.

Schema Category

Issue Slip | Issue Production | 43

Find the issue slip related documents

trinvs

All the transactions in ERP are stored here for audit and reporting purposes.

imtrans

Always true (Don't modify anything in this table)

binimtran

It stores Bin codes

binmst

It store All bin's | check when bin mismatch

bintrna

check when bin mismatch

Schema Category

Performa Invoice

Core tables managing purchase requisitions, transactions, and system audit trails.

trinvs

All documents are stored here.

imtrans

Checks gate entry againts.

gsttaxln

All line level items are stored here.

Schema Category

Log sheet

Core tables managing purchase requisitions, transactions, and system audit trails.

projact

All documents are stored here.

astutltrn

Checks gate entry againts.

Schema Category

Business Location

Core tables managing business locations and party addresses.

partyloc

Stores party and business location details.

Schema Category

Password Remove

Core tables managing user credentials and definitions.

password

Stores encrypted user password data.

userdef

System user definitions and access setups.

Schema Category

Company Database

Global company database references.

pcsoft..company

Central table for multi-company database routing.

Schema Category

Sales Order

Doc Type: 49 | Core tables managing sales orders and tax lines.

trinvs

Primary transaction header table.

sporddtl

Sales order line item details.

gsttaxln

GST and taxation line details for the order.

Schema Category

PO Amendment

Core tables managing purchase order modifications.

trinvs

Primary transaction header table.

amdhdr

Amendment header details and history.

Schema Category

W to W Transfer

Doc Type: 42 | Core tables managing warehouse to warehouse stock transfers.

trinvs

Primary transaction header table.

imtrans

Inventory transfer movement logs.

binimtrn

Bin-level inventory transfer details.

Doc Type & Series

Complete directory of document types and their associated transaction series.

Journal / Tax

Other Resources

Miscellaneous notes, system portals, and configurations.

System Portals & Docs

Live System

.NET WEB ERP

Access the current, live Web-based ERP system for day-to-day operations and live data.

Legacy System

OLD ERP

Access the previous desktop/legacy ERP system for historical data and past audits.

Documentation

ERP GUIDE SOP

Official Standard Operating Procedures (SOP) and user manuals for all ERP modules.

Developer Configurations

Config Note

Environment Variables

Standard connection strings for local C# ASP.NET Core environments. Update your appsettings.json accordingly when switching between VIESL_LIVE and TESTDATA.

Document Library

PDF Document

SOP 01: Accounts and Finance

Standard operating procedure for managing inward and outward gate entries.

View Download

PDF Document

SOP 02: Export Sale

Guidelines for creating, amending, and approving Purchase Orders.

View Download

PDF Document

SOP 03: Fixed Assets Cycle

Instructions for handling Goods Receipt Notes and inventory inwarding.

View Download

PDF Document

SOP 04: GST

SOP for creating Delivery Challans for returnable and non-returnable items.

View Download

PDF Document

SOP 05: Master Creation

Procedure for issuing materials from stores to production/projects.

View Download

PDF Document

SOP 06: P&M

Steps for adjusting inventory stock levels and processing physical verifications.

View Download

PDF Document

SOP 07: PNM2

Documentation for maintaining daily transactional log sheets.

View Download

PDF Document

SOP 08: Purchase

Procedure for processing, validating, and passing purchase bills.

View Download

PDF Document

SOP 09: Purchase Trading

Guide for posting JVs, accounting entries, and valuations.

View Download

PDF Document

SOP 10: Sale Rental

SOP for user management, assigning module rights, and password resets.

View Download

PDF Document

SOP 11: SM

Guidelines for creating item tags, bins, and managing system master data.

View Download

PDF Document

SOP 12: SOP for ERP Login

Instructions for generating stock, consumption, and bin-wise inventory reports.

View Download

PDF Document

SOP 13: Store

Approval hierarchies, short closing POs, and pending approval tracking.

View Download