ACL ESSENTIALS - acl.software

1 STOCK & inventory MANAGEMENTACL ESSENTIALSGet insight into your ERP process health, compliance & financial exposurePageAnalyticNameInventory listingIN Analytic 01 Negative inventory quantitiesIN Analytic02 inventory with a zero cost priceIN Analytic03 inventory with a zero sales priceIN Analytic04 inventory received and issued by the same userIN Analytic05 Net realizable valueIN Analytic06 Analysis of inventory sales by quantityIN Analytic07 Analysis of inventory sales by amountIN Analytic08 General journal adjustments to inventory accountsIN Analytic09 Analysis inventory ordering and usageIN Analytic10 ACL ESSENTIALS SEGREGATION OF DUTIESV ersion 2018/02 Extracts a current inventory listingACCOUNTS PAYABLEPAGE 3 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | IN_ANALYTIC_01_INCS101 ContextThe inventory listing itemises all inventory on hand, including description.

2 Quantity and Results Field NamesCompany CodeCompany NamePlant CodeMaterial NumberMaterial DescriptionReport CurrencyOutput Visualization ExamplesPAGE 4 Material QuantityMaterial Converted Unit of MeasureReport Cost PriceTotal Value of Material Material Standard PriceMaterial Valuation ClassMaterial Fiscal YearInventory stock countCurrent inventory by valuePlant NameIdentifies all inventory with negative quantitiesPAGE 5 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | IN_ANALYTIC_02_INCS102 ContextInventory should not have a negative quantity, more sold than available. All identified instances should be Results FieldsOutput Visualization ExamplesPAGE 6 Company CodeCompany NamePlant CodeMaterial NumberMaterial Date CreatedReport CurrencyMaterial QuantityMaterial Unit of MeasureReport Cost PriceTotal Value of Material Material Standard PriceMaterial Valuation ClassMaterial Fiscal YearTotal negative quantities by plantNegative inventory quantitiesTotal quantity exceptions by material and unit of measureHeat map of total quantity by plant and materialIdentifies inventory with a zero cost pricePAGE 7 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | Results Field NamesOutput Visualization ExamplesContextInventory with a zero cost price could be as a result of incorrect capturing or obsolete inventory .

3 Obsolete inventory should be removed or errors 8 Company CodeCompany NamePlant CodeMaterial NumberMaterial DescriptionReport CurrencyMaterial QuantityMaterial Unit of MeasureReport Cost PriceTotal Value of Material Material Standard PriceMaterial Valuation ClassMaterial Fiscal YearHeat map of zero cost price by material and plant nameInventory with a zero cost priceTotal quantity of exceptions by material description and numberPlant NameIdentifies inventory with a zero sales pricePAGE 9 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | sales value is not expected to be zero. If this occurs it could be because of incorrect processing or a fictitious transaction that has been processed. All identified instances should be 10 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NamePlant CodeMaterial NumberMaterial DescriptionReport CurrencyMaterial QuantityMaterial Unit of MeasureReport Cost PriceTotal Value of Material Material Standard PriceMaterial Valuation ClassMaterial Fiscal YearInventory with a zero sales price, by countInventory by total valuated stockPlant NameIdentifies where inventory is received and issued by the same userPAGE 11 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | (received)andoutwards(salesorissued) should be segregation of duties in place between the person receiving and the person issuing inventory as this will ensure integrity of the inventory transaction.

4 PAGE 12 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NamePlant CodeMaterial NumberDocument User NameDocument TypeDocument NumberDocument User IDDocument Created DateReport Cost PriceReport CurrencyMaterial QuantityMaterial Unit of MeasureTotal Value of StockMaterial Valuation ClassMaterial Fiscal YearDocument DateDocument Material Line IDMaterial Standard PriceInventory received and issued by the same userTotal valuated inventory exceptions by material numberMaterial DescriptionIdentifies where the net realizable value or selling price of inventory is less than the cost pricePAGE 13 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | , inventory sales value is not expected to be less than the cost price. If this occurs it could be because of incorrect processing or fictitious transactions that have been processed.

5 All identified instances should be 14 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NamePlant CodeMaterial NumberReport Cost PriceReport CurrencyMaterial QuantityDocument Sales PriceMaterial Unit of MeasureMaterial Converted Unit of MeasureTotal Value of StockMaterial Standard PriceDocument Sales Net PriceSales DocumentSales Document ItemDate CreatedSales QuantitySales CreatorSales Creator NameMaterial Valuation ClassMaterial Fiscal YearDocument CurrencyTotal cost price of exceptions by material and plantHeat map of total sales price exceptions by creator and material classMaterial DescriptionReport of inventory sales by quantity to be able to assess trends of inventory turnoverPAGE 15 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | Results Field NamesOutput Visualization ExamplesContextThis information is helpful for planning purposes and provides useful management information that identifies unexpected movement in inventory .

6 Unexpected trends can also be 16 Company CodeCompany NameTotal Sales QuantityTotal Number of TransactionsSales Order Quantity Month 1 Sales Order Quantity Month 2 Sales Order Quantity Month 3 Statistics of inventory sales by quantityTotal sales quantity per materialTotal number of transactions by materialInventory sales by monthAnalysis of inventory salesMaterial DescriptionReport of inventory sales by amount to be able to assess trends of stock turnoverPAGE 17 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | ,monthbymonth, management information to identify unexpected turnover in inventory . This information is also helpful for planning purposes. Unexpected trends can be followed 18 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NamePlant CodeTotal Sales Net ValueDocument CurrencyTotal Sales QuantityDocument Sales Net Value Month 1 Document Sales Net Value Month 2 Document Sales Net Value Month 3 Document Sales Net Value Month 4 inventory sales by total net price, quantity and materialInventory cost by monthPlant NameListing of inventory adjustments posted by means of a journal to an inventory account or inventory adjustment accountPAGE 19 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | IN_ANALYTIC_09_INCS341 RiskIncorrectorfictitiousinventoryrelate dtransactionalprocessing, , use of journals should be minimised and any identified journals should be investigated.

7 This could be due to processing errors having to be corrected or fictitious transactions 20 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NamePlant CodeMaterial NumberDocument User NameDocument TypeDocument NumberDocument User IDDocument Created DateDocument Posting DateGL Account NumberReport AmountReport CurrencyDebitCreditJournal TextTotal amount rep currency by material and plantHeat map of total amount rep currency by GL account and materialPlant NameMaterial DescriptionReport of inventory quantities ordered and usedPAGE 21 ACL ESSENTIALS STOCK & inventory MANAGEMENTACL ESSENTIALS | STOCK & inventory management | information is used to track inventory movement, identify unexpected movement and can also be used as input for planning purposes. Unexpected movement should be 22 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NamePlant CodeMaterial NumberQuantityQuantity UnitStock Movement DateWarehouse CodeDocument TypeMonth YearStock MovementInventory order analysis by monthInventory sales by monthPlant NameMaterial Descriptio