Hemen Babla

Hello All, Â My requirement is base on conditions, below is the scenario. Â Â 1) Count total number of Receipt base on The Order Number. Â 2) Count Total Number of Product Qty in the Receipt base on The Ordered Qty. ( Ex : Order Qty is 10, Receipt made 5, Per receipt 2 Qty which come Ordered Qty. ) Â I have tried many was like CASE or IF but cannot get the count/sum, please help me with this. Â Â I have added 2 img with this note. please let me know to go thru. Â Hemen Babla.

Hi, 1) the go to record is just to prompt the user on which product the qty is more or none. 2) Delivery qty is an number filed, and available qty is an calculation field base on which location is selected. i have uploaded an other image in my main post please check may be u will get an idea.

Hi All, I have put new image of the script, but even i will write the script down. Its able product qty check script. Product Deliver QTY Available QTY P1 5 4 P2 4 10 P3 2 3 This are the line items in the delivery order. before processing the order it check if it has sufficient qty to deliver. So i do an check with the loop Setvariable ($$ID,DO_Number) gotolayout enter find mode() setfield (DO_number;$$ID) performfind() //This is only to check for that perticular do number. which has this 3 item to deliver. Loop If ( Deliver QTY>AvailableQTY) Showmessage("insufficient stock") Else Endif go to next record. end loop. IF condition somtime give me message even i have more stock which in this case is line number 2. i have found one more thing on my loop is the error/message comes if the available qty has 2 or 3 digit number. my Available qty is calculation field which is base on the location selected by the user to deduct.

Hi Laretta, Thanks for the reply but this is what i am not looking for. I have this script which runs and check that the delivered qty should not be exceeding the available qty. The script works but sometime give me an prompt even available qty is more then the delivered qty. Regards

Hello,  I being trying to run the script but cant find any help with this.  basically i am trying to perform an condition where if the available qty is less then the delivered qty, it should not proceed. but the error i am receiving is different.  the error is also seen even it i have sufficient qty in the stock.  Please find my attached script and let me know if am making any error.  Regards

Hi, thank you very much it work for me. sorry was out so couldnt reply you. Also can you help me to intregate Barocode to my database. I have an inventory database where i do all the in and out. my client requirement is that during the time to stock receive he will just scan by the serial number of that product to save in the inventory database. can you help me?

Hi, I am trying to get the sum() of field base on two condition. Attached is my calculation : If ( Invoice Entries::INVPaid=0 and Invoice Entries::Age of record<-30;Sum ( Invoice Entries::Inv Amount );0 ) Please let me know if i am making any mistake.