We’re currently updating our website to a new platform. We’re still operating as usual, but some pages may be under construction. Thank you for your patience.
Jiwa Training Centre

Inventory Classifications


Inventory classifications are used to group inventory items in Jiwa and apply key default settings.

This article explains how to create inventory classifications and how they are used when setting up inventory items. In Jiwa, inventory classifications are used to assign default General Ledger control accounts, default GST codes, and a default product price group.

Inventory classifications are also used for reporting, searching, and analysis. Many standard Jiwa inventory reports allow data to be filtered or grouped by inventory classification, so it is important to consider reporting requirements when creating or maintaining classifications.


Creating Inventory Classifications

From the menu select Inventory | Configuration | Classifications

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-Admin-Inventory-Classifications/2016-10-24_13-36-52.jpg

From the menu ribbon select New

Alternatively, you can base your new classification on an existing one, load the required classification and select Copy from the menu ribbon.

When copying an existing classification all ledger account settings are also copied.   In the header section enter in the classification

  • Description,

  • Default product pricing group, and

  • Tax rates

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-Admin-Inventory-Classifications/2016-10-24_13-43-31.jpg


Field

Description

Description

Classification description

Product Pricing Group

This is the default product pricing group that is assigned to an inventory item on the Prices tab in inventory maintenance when the item is linked to this classification.

The product price group can be changed on individual items if required.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-Admin-Inventory-Classifications/2016-10-24_13-49-23.jpg

Note: Changing the product pricing group on a classification will not update existing inventory records.

Web Enabled

This flag is used to indicate that inventory items in this classifications are visible through a web based applicable.

This is the default setting for items in this classification but can be changed on individual items if required.  

Note: Changing the web enabled flag on a classification will not update existing inventory records.

Default

This flag indicates if the classification is the default classification.

Only 1 classification can be set as the default and is the classification that is automatically assigned to new items created through inventory maintenance.

Tax Rates

These are the default tax rates for items linked to this classifications but can be changed on individual items if required.  

Note: Changing the tax rates on a classification will not update existing inventory records.

 

Ledgers Tab

These are the default General Ledger control accounts for the classifications which are then applied to each inventory item linked to the classification.

These ledger accounts can be changed on an individual item if required in inventory maintenance under the Other | Ledgers tab.

The purpose of each account is explained in the table below, however if you are not sure on which accounts to set please contact your Accountant.

Note: Changing ledger accounts against an inventory classification will not update existing inventory records.  

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-Admin-Inventory-Classifications/2016-10-24_13-58-54.jpg

Control Account

Description

Inventory Value

Inventory Asset Value

For physical items this is the account that represents your stock on hand value in the Balance Sheet

Cost of Sales

Cost of Goods Sold

This is the cost of sales expense account that invoices and credit notes post to.

From Jiwa version 7.0.175 this account is used by non-physical items prior to this version the Inventory Value control account was used.

Expected Asset

Inventory Value on Purchase Orders

This is the Balance Sheet asset account that is posted to when the purchase order status is set to SENT. It represents the value of stock on that purchase orders.

This entry is reversed when stock is receipted in via GRN and shipment book-ins.  These entries are also reversed out if the purchase order is cancelled.

If the potential asset and liability is not to be taken up in the Balance Sheet then the Expected Asset and Liability control accounts can be set to the same account.

Expected Liability

Purchase Order Commitment

This is the Balance Sheet liability account that is posted to when the purchase order status is set to SENT, this is the opposite entry to the Expected Asset account entry, and it represents the purchase order liability.

This entry is reversed when stock is receipted in via GRN and shipment book-ins. These entries are also reversed out if the purchase order is cancelled.

If the potential asset and liability is not to be taken up in the Balance Sheet then the Expected Asset and Liability control accounts can be set to the same account.

Delivered Asset

Inventory Value Received but Not Invoiced

This is the Balance Sheet asset account that is posted to from GRN (excl. GST) and shipment book-ins when activated.

This entry is reversed when the purchase invoice and shipment invoices are activated.

If you do not require a separate account for the value of your inventory received but not invoiced then this control account can be set to your Inventory Value account.

Delivered Liability

Creditor Stock Purchase Accrual

This is the Balance Sheet liability account posted to from GRN (excl. GST) and shipment book-ins when activated and is the opposite entry to the Delivered Asset account posting.

This account represents the creditor stock value for stock that has been received but the creditors invoice is yet to be raised/activated.  In other words it is the accrual account for the creditors invoice.

When the creditors invoice is activated through purchase invoices and shipment invoices the liability is then transferred to Trade Creditors and if applicable GST is taken up.

Assigned Value

Inventory Delivered to Customers but not Invoiced

This is the Balance Sheet asset account that is posted to when Bill Complete sales orders are processed and stock has been delivered to the customer but not yet invoiced.

The entries are reversed when the sales order is invoiced.

If you do not use Bill Complete sales orders this account should still be set as you will not be able to save your classification if the account is left blank.

Cost/Goods Variance

Price Adjustments on Stock Sold

This is the expense account that is posted to when there are price changes in purchase invoices and shipment invoices and the stock has either been sold or adjusted out and no longer exists.

Sales

Sales This is the income account posted to when the item is sold.

Inventory WIP

Manufacturing Work in Progress

This is the Balance Sheet WIP account that is posted to by processed work orders where stock is allocated to work in progress.

If you do not use the manufacturing module this account should still be set as you will not be able to save your classification if the account is left blank.

Ledger Purchases

Supplier Inventory Purchases

This is the expense account used when the system setting UseCostOfGoodsLedger is disabled and the UseInventoryPurchasesLedger is enabled.

It is recommended that this account is set to the Cost of Sales account.

This is a rarely used option which should be discussed with your Jiwa Consultant before implementation.

Ship on Completion

Inventory Allocated to Ship on Complete Sales Orders

This is the Balance Sheet asset account  that is posted to when stock is allocated to a Ship Complete sales order which has back orders.  Processing the order transfers the value of the allocated stock to this account.

The entries are reversed from this account when the sales order is invoiced.

If you do not use Ship on Complete sales orders this account should still be set as you will not be able to save your classification if the account is left blank.

Write On

Inventory Adjustments In

This is the expense account that is posted to by stock transfers and stock takes where stock is adjusted in increasing the stock on hand value

Write Off

Inventory Adjustments Out

This is the expense account that is posted to by stock transfers and stock takes where stock is adjusted out decreasing the stock on hand value

Cost Price Adj

Inventory Cost Price Adjustments

This is the expense account that is posted to by the Cost Price Update form where stock is revalued.