MODULE : STOCK

Maintain Stock Group

sqlacc.st_.group_.02

Creates a list of stock group to help organize your stock items. It also gives you a convenient option where you can preset your sales and purchase posting account.

Maintain Stock Item

sqlacc.st_.item_.02

Creates stock item with information such as multiple warehouse and UOM, different customer & supplier price, price tag, alternative stock code, bar code and costing. You can also switch between standard, FIFO and weighted average costing.

Maintain Stock Category

sqlacc.st_.category.01

Creates stock category for your stock items. For instance, a stock category template named handphone will consists of a list of brands such as SAMSUNG, NOKIA, MOTOROLA and etc.

Maintain Stock Category Template

sqlacc.st_.cattpl.02

Group related stock categories under one common template.

Maintain Stock Price Tag

sqlacc.st_.pricetag.02

This helps you define different pricing level for each Price Tag.

Maintain Item Template

sqlacc.st_.itmtpl.02

This enables you to group related stock items under once common template. It serves as a shortcut to allows you to append items quickly.

Maintain Location

sqlacc.st_.location.02

Creates a list of stock location (warehouses) and it’s details.

Stock Received

sqlacc.st_.rc_.02

Easily maintain stock received for company’s internal use.

Stock Issue

sqlacc.st_.is_.02

Similar to Stock Received, the Stock Issue allows you to dispatch item for company’s internal use.

Stock Transfer

sqlacc.st_.xf_.02

Transfer a particular stock item from one location (warehouse) to another location (warehouse).

Stock Adjustment

sqlacc.st_.aj_.02

Adjust the stock level by your locations.

Bill of Material Item Assembly

sqlacc.st_.bom_.02

Stock Item Assembly, Stock Item Disassembly and various type of reports such as BOM Listing, BOM Material Usage, BOM Planner and BOM wastage report are all part of Bill of Material component intended for manufacturing company.

Bill of Material Item Disassembly

sqlacc.st_.bom_.04

Bill of Material Document Listing

sqlacc.st_.bom_.05

Bill of Material Usage

sqlacc.st_.bom_.06

Bill of Material Planner

sqlacc.st_.bom_.07

Bill of Material Wastage Report

sqlacc.st_.bom_.08

1 Maintain Stock Group – This feature allows you to easily to maintain the stock group information for you business.
 2 Maintain Stock Item – You can maintain the stock items information for your company via this feature. Beside, this feature able to support multi-warehouse, multi-UOM, different customer price, different supplier price, price tag, alternative stock item, bar code and costing. Beside able to switch costing, SQL Accounting has support for standard, FIFO and weighted average of costing.
 3 Maintain Stock Category – This is the feature which allows you to maintain the stock category information for particular stock item. For instance, a stock category template name hand phone will consists of a list of hand phone category such as SAMSUNG, NOKIA, MOTOROLA and etc.
 4 Maintain Stock Category Template – It is a feature to help you to group the related stock category under one common template.
 5 Maintain Stock Price Tag – SQL Accounting enable you to maintain the stock price tag for your business via this feature.
6 Maintain Item Template – With this feature, SQL Accounting enables you to group the related stock items under once common template. It is a shortcut to allows you to append all the relate items at once under a common template. For instance, a item template name prepaid card consists of a list of prepaid cards (e.g. Maxis Prepaid RM100, Maxis Prepaid RM60, Celcom Prepaid RM100, Celcom Prepaid RM50, etc) information.
 7 Maintain Location – SQL Accounting has support this feature to allow you to maintain the stock location (warehouses) details of your company.
 8 Stock Received – We enable you to easily to maintain the stock received for your company internal use purpose. For instance, the director places back the stock items after he has no longer used.
9 Stock Issue – This feature enable you to maintain the stock issue for your company internal use. For instance, the director may take particular stock items for own used purpose.
 10 Stock Transfer – Here, SQL Accounting has support this feature where it enables you to transfer a particular stock items from one location (warehouse) to another location (warehouse) of your company.
 11 Stock Adjustment – SQL Accounting include this feature to enables you to maintain/ adjust the stock level in different branches within your company.
12 Bill of Material – This feature has include stock item assemble, stock item disassemble, and various type of reports such as BOM listing, BOM material usage, BOM planner and BOM wastage report.
Reports – SQL Accounting has support a wide range of reports include stock document listing, stock reorder advice, stock physical worksheet, stock card, stock month end balances, stock aging and stock analysis by document.
Unique – Compare to others accounting software, SQL Accounting include real time post, costing calculation is date sensitive – you can back date transaction, costing calculation inter warehouse transfer, extremely accurate in costing calculation, and multi-generate inter warehouse transfer in costing calculation.

.