SKU Code is the mandatory field in the SKU Master, there will two options in the SKU Code i.e., Manual entry and Auto generation, these settings will be at Configuration settings.
HSN Code is the mandatory field in the SKU Master. HSN stands for Harmonized System Nomenclature. The WCO (World Customs Organization) developed it as a multipurpose international product nomenclature with the vision of facilitating the classification of goods all over the World in a systematic manner, so, enter the same based on the type the product.
Short Description is the mandatory field in the SKU Master, this will reflect in the bill print. So, enter the products short description (name of the product).
Long Description is the mandatory field in the SKU Master, this will reflect in the other than the bill print, like search, reports etc., so, enter the products long description (name of the product).
Unit Description is not a mandatory field in the SKU Master, but optional. Select the suitable UOM from the list.
Department/Category is the mandatory field in the SKU Master, select the required Department/Category combination.
Vendor Description is not a mandatory field in the SKU Master, but optional. Select the required vendor of that product from the list.
Brand Description is not a mandatory field in the SKU Master, but optional. Select the required brand from the list. It is based on location wise.
SKU Code is not a mandatory field in the SKU Master, but optional. Select the required manufacturer from the list.
In the Pricing Details tab, there will be 11 different fields. Tax Percentage, ACP, Cess Percentage, Cost Price, MRP, Retail Sales Price, QOH, Threshold Percentage, EAN Code, Language Description & MBQ.
Tax percentage is a mandatory field in the SKU Master. Enter/Select the required tax percentage for that product from the list. It will be
ACP is a mandatory field in the SKU Master. ACP (Actual Cost Price), is the cost price of the product before imposing the tax. Enter the required ACP for the product.
Cess Percentage is not a mandatory field in the SKU Master, but optional. Enter the Cess percentage here in this field.
Cess is one of the Tax which users can add manually, it will add after the Tax applied to the ACP.
Cost Price is a mandatory field in the SKU Master. Cost price is the cost price of the product after imposing the tax. This will come automatically based on the selected Tax percentage and ACP, i.e., Cost Price = ACP + Tax Value of ACP.
MRP is a mandatory field in the SKU Master. MRP (Maximum Retail Price) is highest/maximum sale price of the product. Enter the required MRP in this field.
Retail Sale Price is a mandatory field in the SKU Master. This is the selling price of the product. Enter the required selling price in this field.
QOH is not a mandatory field in the SKU Master, but optional. QOH (Quantity on Hand) is the quantity of the product which is currently there in our location (Outlet/Store/Warehouse). Based on the PO and GRN the stock will be added.
Threshold Percentage is not a mandatory field in the SKU Master, but optional.
EAN Code is not a mandatory field in the SKU Master, but optional. Enter the required EAN from the list.
Language Description is not a mandatory field in the SKU Master, but optional. Enter (copy & paste) the SKU name in the local language, which will reflect in the billing application.
MBQ is not a mandatory field in the SKU Master, but optional. Enter the required MBQ for that product.
In the Other Details tab, there will be 9 different check boxes for different kind of requirements along with option to upload the images of the products.
Open Rate is not mandatory, in the SKU Master, but optional. If we check this check box, it will allow to change the sale price at billing for a bill, else not.
Enable Discount is not mandatory, in the SKU Master, but optional. If we check this check box, it will allow to give the discount in the billing, else not.
Allow Decimal is not mandatory, in the SKU Master, but optional. If we select this check box, it will allow to enter the decimal quantity for the respective product in the transactions, else not.
Bulk Parent is not mandatory, in the SKU Master, but optional. If we check this option, it will show this product in the Bulk Setup as a bulk code, else not.
KIT is not mandatory, in the SKU Master, but optional. If we check this option, it will be treated as a KIT product, else not. A KIT product cannot have BATCH, it cannot be BOM and it also cannot be PACK product. It will show in the KIT Module.
Non-Inventory is not mandatory, in the SKU Master, but optional. If we check this option, it will not allow the billing for the respective product if the stock is zero or less than zero, else not.
Inactive is not a mandatory field in the SKU Master, but optional. If we select this option, it will not allow the respective product in any of the transaction.
Billing will allow for all the inactive SKUs till stock becomes ‘0”.
Local Purchase is not a mandatory field in the SKU Master, but optional. If the user selects this option, it will be treated as local purchasable product, else not.
Consignment is not a mandatory field in the SKU Master, but optional. If we select this option, we must enter the respective percentage of that product in the ‘Consignment Percentage’ filed. Here the consignment product means, a vendor will keep the product(s) for which the GRN was not done and the QOH will always be zero, and Store person will sell those products and out of total sale amount of that product the defined percentage of amount will be given to the vendor.
Flow through is used for the Dairy Products this option is used for Auto PO process. It is not a mandatory field in the SKU Master, but optional.
The SKU for which the NRTV (Non-Returnable to Vendor) is enabled, for these Transfer out will not happen from the store to store or store to ware house.
The Quantity of SKU which PO is in Save Mode that will be considered as ON Order Quantity. Purchase Order quantity will consider as ON Order Quantity.
Enable Batch is not a mandatory field in the SKU Master, but optional. If we select this option, it will show two more options i.e., ‘Calculate Expiry Date’ and ‘Predefined Expiry Date’.
Calculate Expiry Date will have two more options, i.e., ‘Shelf Life’ and ‘Minimum Expiry Days for Receiving’.
Shelf life mean, it’s the number of days of the product which need to be there in the shelf in the store.
Minimum expiry days for receiving is the minimum number of days for receiving while doing the GRN/Receiving app.
For example, if a product’s minimum expiry days for receiving are 10days, current business date is 2nd Sep 2020, now the product expiry date is 10th Sep 2020, then in this case the GRN/Receiving will happened for this SKU as its minimum expiry days for receiving is 10days, i.e., it will only allow if the expiry date for that product is more than the 12th Sep 2020 i.e., 10+2 (current business date)=12th Sep 2020, so GRN/Receiving will allow this product if its expiry date is 13th Sep 2020 or more.
Predefined Expiry date will have one option i.e., ‘Minimum Expiry Days for Receiving’. In this the expiry date will be defined to the product at the time of creation only.
Example: Milk packets, Bread etc for this the expiry date will be given at the time of packing.
Pack is not a mandatory option in the SKU Master, but optional. If we select this check box, it will show two more options, i.e., ‘Parent’ and ‘Child’.
This option is for the FMCG (Fast Moving Consumer Goods) items. If we are creating pack item first, we need to create a child item of the respective parent item.
If we select this option also select the ‘Parent’ check box, then the product will be treated as a parent product, and it will show two more options after selecting the parent check box, i.e., Pack unit and child SKU.
Enter the pack unit (a number) that is how many pieces should be there in the pack of the parent, and then we need to select the respective child item from its respective filed.
All the Transactions will be happened to the Pack but the quantity will update to the child.
Billing will happen for both the Pack and child but the quantity will be deducted from the child as per the Pack Unit.
Example: Water Bottle in one case we have 12 bottles then the case is called PACK.
So, we can sell the Pack or single bottle.
