Jump to content
Sign in to follow this  
vancity

How to "scan" a table/db

Recommended Posts

I need to scan for a part_ID in PO file to extract all occurrences of "qty not rec'd." to populate a "BackOrdered" field in Product DB for the Part_ID.

I also need to scan all Work Orders for Part_ID * Quantity of each to remove the total number from "stock on hand" field in Products.

Anyone know how I can do this, either via script, key field, etc?

Share this post


Link to post
Share on other sites

Please don't double post.

Edited by Guest
duplicate deleted

Share this post


Link to post
Share on other sites

Apologies Lee re: double post - trying to be more accurate.

Kent, what I mean by "scan" is: When a Purchase Order is made, there can be multiple Part #'s on a PO, (even the same Part # twice on the same PO, you never know), and there are multiple PO's "active" (where they don't have a "all received date field entered which closes the PO) - there is a manually populated quantity received field and a quantity back ordered field - I need to take all quantity received in all PO's for part # X and add that number to the stock on hand number in the inventory database for that part #. If any part # is back ordered, I need to show that there is a quantity back ordered in the BO'd field in inventory.

On the other side, when a Work Order is made, i need to take whatever part # quantity out of stock on hand.

It would be nice to have a notifier, perhaps a portal (don't quite know how to use them yet) to bring up the basic inventory info displaying part #, stock on hand, and Backorder Qty when entering a work order.

Any help is appreciated folks, I "inherited" the backbone for this database and I'm having a little difficulty trying to get it to manage inventory.

Thanks to all

Share this post


Link to post
Share on other sites

Any reason you didn't delete the double Lee? Or do you just want to wait to see what the user says first..

Share this post


Link to post
Share on other sites

You nailed it. Plus, I didn't have the time yesterday to write a Private Topic.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.