My idea is to use Zoho Creator to build an inventory management system with tracking capabilities which mimic the current Excel/Paper use in my company. It has to have the current features:

1. Able to display daily inventory level with 

      - Base Inventory (Sum of each items until yesterday)

      - Outgoing (Today's outgoing)

      - Receving (Today's incoming)

      - Total (Base + Recv - Out) 

2. Able to track Lot No. of each inventory. 

      - In my test system, I am able to record items by lot number but when generate a report (via HTML Page), it shows 2 items with the same name. This is the code for the Page.

2. htmlpage INVEN_Page(Begin_Date, End_Date)
3. displayname = "INVEN Page"
4. content
5. <%{
6.     for each i in Receive_Sub
7.     {
8.         prod = Add_New_Product[ID == i.Product].Product;
9.         quan = i.Quantity;%>        <table width="400" border="1" cellpadding="1" cellspacing="1">
10. <tbody>
11. <tr>
12. <td><%=prod%></td>
13. <td><%=quan%></td>    <%}
14. }%>

Results

Palm Oil 50 Sunflower Oil 4 Sunflower Oil 59 Palm Oil 21 Green Peas 5

3. Regarding point 1, I assumed that I have to post each inventory in the database (as oppose to only update the quantity of each item), which ,in the future, will fill my record limit of 250k / 1mil. Is there anyway to fix this issue?

Currently, I have already create an application which can record each item by lot, please contact me if you would like to view it to help understand the problems.

Thank you so much.