Materials Management

Available Checks:

 

Area Item Master

Test Area/Test Name Brief Description
Items

item registration

It is checked here, if all variant items are also registered in the REP of the items "CX_ITEM).

Hier wird überprüft ob alle Variantenteile, von der REP der Variantenteile (CX_ITEM_PATTERN) ausgehend, auch in der REP der Teile (CX_ITEM) registriert sind.

If this is not the case, the according variant item will be registered automatically in the item REP and displayed in the item master list.

no provision type

All items without a provision type indication in the warehouse account are searched.

Attention! When opening the warehouse account for all search results, the provision type "Disposition" will be displayed, even if there is no entry, yet. Clicking "Save" makes the provision type get entered in the warehouse account, too.

Possible provision types are:
disposition, warehouse management, area for small parts storage, JIT, rest quantity and in provision

no logistics marking

Searches for items without logistics marking. It needs to be set for the displayed items, whether they are sales- or product items.

invalid main stock space

Searches for items, that have an invalid main stock space in their warehouse account.
Warehouse Account

main stock space

Here, it is checked for all items with a warehouse account, whether the main stock space account that has eventually been defined here, is also available in the normal sub-list of the assigned stock space accounts. If this is not the case, the according item will be displayed in the item master list. 

stock space

Not yet supported in the current version!

negative asset

Searches for items with a negative stock asset.

stock space without intventory since date (with and without validity)

Searches for stock space with no inventory since the indicated date.

invalid stock space with asset (positive or negative)

Searches for invalid stock space with asset (positive or negative). 
Disposition Account

balance differences

Assemble:
Searches for balance differences in all disposition accounts. For this, all disposition account data will be sorted by transaction type, the quantity will be separated, added up and compared to the sum quantity in the disposition account. In case these numbers are not the same, it is a balance difference. These items are displayed in this run in the item master list.

Correct:
In case these items have already been calculated and displayed in the item master list, it is possible to recalculate the disposition account for each item master list with this menu item and to write them into the disposition account (correct them).

cancelled or stopped entries

It gets checked in all disposition accounts via item master, whether there are any entries that are either getting cancelled or stopped, but which are at the same time still booked in the disposition account. This check is currently only executed for sales order-, purchase order- and purchase order requisition sub-items. The items are displayed in the item master list. 

no open quantity 

It gets checked in all disposition accounts via item master, whether there are any entries without any more open quantitys, but which are still in the disposition account. Parts with faulty disposition accounts are displayed in the item master list. 

deleted entries 

Assemble:
Checks for all disposition accounts via item master, whether there are any entries that are technically deleted but still booked in the disposition account. Items with faulty disposition accounts are displayed in the item master list. 

Remove:
If these items have already been calculated and displayed in the item master list, the disposition account can be corrected for each item in the item master list with this menu entry - deleted entries will be removed. 

units

Conversion Tables:
Here it is checked for all items, whether an eventually existing unit table is consistent. If this is not the case, the according item will be displayed in the item master list.

Booked quantities:
Here,  it is checked for all items, whether the entry quantity units are compatible in the warehouse- as well as in the disposition account, in reference to the according unit table of the according item. If this is not the case, the according item will be displayed in the item master list.  

complete production order sub-items

It is searched for production orders with a step 0 that provides production order items and which is no longer in the disposition account but still has sub-items. These sub-items must not be provided yet and are therefore still registered in the disposition account. They increase the production quantity in the disposition account, which is incorrect.  
A result window opens and displays the according step > 0 production order items. A double-click leads to the production order.

items with different orders

All orders will be searched which indicate another item

Es werden alle Bestellungen gesucht, die ein anderes Teil haben als in ihrem Vorgänger, entweder Kundenauftrag oder Teileanforderung, angegeben. This analysed constellation is only allowed, if the order type is not switched to "no indications" (more information).

inconsistent transaction history

Not yet supported in the current version!
It is checked in all disposition accounts via item master, if am entry successor  Es wird über den Teilestamm in allen Dispokonten geprüft, ob der Nachfolger eines Eintrages in einem bestimmten Dispokonto auch, wenn überhaupt, in dem gleichen Dispokonto eingebucht ist. Ein Nachfolger ohne Einbuchung in ein Dispokonto gilt in diesem Lauf nicht als fehlerhaft. Diese Situation kann nämlich zum Beispiel auftreten wenn ein Folgebeleg schon angelegt aber noch nicht gebucht ist.
Item Casts

product item without/with several product items 

Searches via warehouse account for defined product items - and therefore via logistic code - which do not have any product item cast(s).

sales item without/with multiple order item casts

Searches via warehouse account for defined purchase parts - and therefore via logistic code - which have no order item cast(s).

 

no main supplier 

All purchase items  without main supplier are displayed. 

no default price

It is checked for all items, whether their order items or production casts have defined a default price. If this is not the case, the according parts will be displayed in the item master list.

price list does not match with the default quantity

It is checked for all order item casts, whether a price table has been generated or not, and whether it is possible to calculate a price in this table with the default quantity.
(Example: Price table entry
1. quantity >=100 pieces & quantity < 200 pieces = 10€/1piece
2. quantity >=200 pieces = 8€/1 piece
... and the default order quantity is 10 pieces)
only accessible via monitor:  CheckReceivedQuantities Cross-checks the quantity received.quantity in the warehouse account with all received quantities that have not been provided or stored, yet.

 

Area warehouse statistics:

Test Area/Test Name Brief Description

transactions without price

Searches for stock transactions without price to be listed in the result window.

negative final assets

Entries of inward goods movements and outgoing goods can cause negative final assets. Items with negative assets are listed in the result window.

final value in case of zero stock

A stock space has the quantity 0 (it is empty) but a due to flowing average prices and values, a stock value has developed anyways. These will be corrected automatically with the monthly balance. Before, they can be accessed for information purposes only.

zero stock reductions

Similar to the negative final assets, it can happen, that a stock removal gets booked before the according storage. This stock removal now takes a certain amount off the empty stock space. Since the stock removal needs to be evaluated with the current average price and maybe there has been no storage, yet, it is quite likely, that the stock removal will be evaluated with 0€. This causes a faulty final costing or a faulty monthly balance during warehouse evalutation.  

 

Area Provision (Provision State):

Test Area/Test Name Brief Description

Order Item

delivery status

You can check, if all warehouse bookings for partially or completely provided order items have been provided, by setting the according option and displaying all items by selecting the state "warehouse booking" and "order items" after

disposition status

You can check, if all warehouse bookings for already provided ordSie können überprüfen, ob alle Lagerreservierung für schon bereitgestellte Auftragspositionen bereitgestellt worden sind, in dem Sie die entsprechende Option setzen und sich danach, den Zustand "Lagerreservierung" und "Auftragspositionen" auswählend, alle Positionen anzeigen lassen.

While checking, you need to consider, that both settings need to be checked together, so positions are only being displayed if the delivery status is "delivery completed" as well as 

Sie müssen beim Überprüfen beachten, daß die beiden hier genannten Einstellungen zusammen überprüft werden, daß also Positionen nur angezeigt werden wenn z.B. sowohl der Lieferstatus "vollständig geliefert" als auch der Dispositionsstatus "bereitgestellt" ist, was eigentlich unmöglich ist!
For this reason, the best setting for the check-up is: delivery status = partially + completely delivered AND disposition status = all

Test Area/Test Name Brief Description

Production Transaction

production status

You can check, if all warehouse bookings have been provided for complete or provided production transactions (), by

Sie können überprüfen, ob alle Lagerreservierung für beendete oder bereitgestellte Fertigungsbelege sprich Fertigungsauftragspositionen bereitgestellt worden sind, in dem Sie die entsprechende Option setzen und sich danach, den Zustand "Lagerreservierung" und "Fertigungsbelege" auswählend, alle Positionen anzeigen lassen.

requisition activator

For certain checks in reference to production transactions, you can define via setting, whether to refer to only customer orders as requisition activators, stock orders, advance demands or a combination of these options. Default setting is all three being activated. It is still possible to evaluate only production transactions with a stock order as a requisition activator. 

item demand

For certain checks in reference to production trancactions you can define via setting, whether you want to refer only to production transactions (resolved BOM items) which have a 1:1 relation between the production transaction (resolved BOM item) and the item demand (and are therefore not "pooled") and/or whether you want production transactions with subsequent item demands, which consist of "pooled" resolved BOM items. 

The best setting for a check-up would be ended here as well as provided and either three requisition activators have been activated, or only the one  to be checked.

Test Area/Test Name Brief Description

General

provision type

Here you can indicate via setting, to display only warehouse bookings for items that are currently set to warehouse management as the provision type!