Can any one help me in knowing ,How the field ORder Balance is calculated in session Display Planned inventory movement by item (timrp1510m000)?in BaaN4CIV this field is in form1 of the above said session. can any one tell me the logic how the field order Balance is calculated....

Order balance is calculated by date and is updated when MRP in run.

Originally posted by Flip_J
Order balance is calculated by date and is updated when MRP in run.
that i also know but how can you give me some logic or example so that it will be easy to understand me.

Consider an item 'A' with inventory on hand-61.
Now any Purchase orders raised for this item 'A' will be considered.
If 2 Puchase orders with planned quanitity 880 and 840 are there resptly.
Your display session will have the first line with Order balance as 941 which is 880 +61.
The next line will have 941+ 840=1781.
These are for Purchase orders.
Then other lines with order balance include MPS raised Production order quantity,which will be reduced from previous total.
Say an MPS Production order with quantity 5 is there,
then the order balance in the next line displayed as 1781-5=1776.
With reference to addition or reduction in the Order balance quantity,note that it cumulates the quantity for a single date and adds/reduces the quantity accordingly.
Consider the previous qunatity obtained-1776.
If you have 3 MPS production orders for the same date 6/9/02 ,with quantity 40,4,3 respectively.
Now the order balance in thses 3 lines will be
1776-47(40+4+3)=1729
Hope this helps.:)