How to update quantity after save

[hsiuwenwu]

I have a grid that has Actual_Qty, Qty_On_Hand, Qty_To_Order, Qty_To_Post.

All the calculation working fine, now I would like to find out how to update Qty_On_Hand after saving the grid.

Qty_To_Post = Qty_On_Hand - Actual_Qty, and then update Qty_On_Hand with the number from Qty_To_Post, is there a way to do this?

From the attachment...use 9 to replace 24 after saving.

1.jpg

[Larry Gordon]

I THINK you may have had no replies as your query is confusing - to me, certainly.

If POST = ON HAND - ACTUAL, and you then want the POST to become the ON HAND number, it looks like a 'circular' calculation.

Maybe you will get a better response if you explain the problem again...

[tboogerd]

I'm looking for similar functionality. I have a grid with OHQ (OnHandQuantity) and a button. When the user clicks the button I want to subtract 1 from OHQ and save/update database. If OHQ is 1 and user clicks button to subtract 1 (for a total of 0) then I want to remove the entire record from database. I don't even know where to start.?.

[Keith Hubert]

The goods supplied table should not be the same as the Inventory table where the Quantity in Hand value is held.

Have a look at AlphaSports Invoice form and see how the field rules work there for Invoice Items. I know this is a desktop application but you need to get your heads around how the posting rule works and what your table structure should be.

[hsiuwenwu]

What I mean was, I started this Job with 24 on hand, and used 15 of them which left me 9 on hand. So, when I create next job, I will start with 9 on hand, but I couldn't find a way to update this number.

[madtowng]

I think I do something similar. Let me describe it.

We warehouse products for several customers.
My coworkers are responsible for adding and subtracting inventory.

Additions get posted and are available immediately (we have them onhand in the building).
Subtraction transactions get dumped into a transaction file for posting the next day (much like a bank does with your checking account).
The page will show a quantity onhand (at the start of the day), and a quantity available (start of day - transactions that have not posted).

The next day, I chose 1:03 am, I have the system post the transactions.
One advantage of doing it this way is when a coworker says "hey, I goofed. Can you put those parts back in", I can easily void the transaction
without having to jump through all kinds of hoops.

[hsiuwenwu]

Gregg,

So how do you achieve that? I just need to update the quantity on hand after subtract whatever was taken and ready to be use for next order.

[madtowng]

I would actually do the post as quantity onhand - quantity-taken.

For accountability reasons, I would keep quantity onhand and quantity-taken amounts in seperate tables.

In my case, I use .dbf tables, and some calculated fields to provide the information.
The code I use is below. I'm not sure how well this will work with what you have, but I think it's easy enough to follow.

maxtpull    = Qoh-tablesum("outboundtrans","postresult = 'needinfo'.and. uniqueid = '"+Uniqueid+"'","qtypulled")