What is Availability Check and How to Configure it?
When we create a sales order, there are several basic functions which are executed automatically for the dynamic order management . among these basic functions, availability check and transfer of requirements are crucial.
the system first prepares schedule line containing the information on the desired delivery date and quantities, this information is passed to MRP and an availability check and transfer of requirements are executed
First, the system carries out backward scheduling and establishes the material availability date = desired delivery date-transit time-loading time-picking & packing time and on this date an availability check is carried out using ATP logic which means available to promise quantity =total warehouse stock+incoing orders-outgoing along with the availability check the requirements also are transferred to MRP.
The configuration involves following:
-
Switching on at schedule line category the availability check and TOR
-
Configure the availability check using ATP and using the checking group and Checking rule
What is the difference between ATP check and availability check how these reflect in sales order(which check system considers) what are the IMG settings for the same:
ATP Check is checking of availability quantities i.e ATP = Total Warehouse Stock + Planned receipts(Incoming Stock) - Planned Issues (Out going stock)
Availability Check is an integral part of business process it determines the if the desire deliverable quantity can be met on requested delivery date or not.Then it passes to Material Requirement Planning. Or we can also say.
Availability check is nothing but checking of availability of stock which is placed in the order, sys carries out this check through an available to promise (ATP) logic =whare house stock +planned recepts (incoming stock)-planned issues (out going stock)
What we normally check for in the Database Testing?
Database testing involves some in-depth knowledge of the given application and requires more defined plan of approach to test the data. Key issues include:
1) data Integrity
2) data validity
3) data manipulation and updates.