Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Referring to multiple fields throught different tables/db's properly

Status
Not open for further replies.
VanCity

VanCity

IS-IT--Management
Apr 30, 2007
18
Trying to manage inventory:
Need partno X qty to be properly effected by adding po's received qty, (logging backordered qty), alloacating (removing from inventory partno X qty) workorder amounts and when the corresponding invoice is made from the work order, removing the allocated amount in enventory at that time.
Right now I can track the rec'd amount to add to Stock Qty in inventory for one PO only, I need this to apply to any partno on any PO
Hope thats enough info for you.
Been a while since I've been on this forum (different user name) - it's never failed me yet !!
 
Sort by date Sort by votes
Perhaps a clearer explanation here:
Tracking quantities of a given part number to maintain inventory.
Trying to make inventory consolidations: databases that effect any given "part number's qty field" in inventory database are:

"PO's received field" in PO database(adds to "stock on hand field" qty in Inventory database),

"Backordered PO items field" in PO database(adds to "Stock BO'd field" in Inventory database),

"Work Orders Quantity field" (for any partno)in Work Orders database (removes from "stock on hand field" in Inventory database and puts into "allocated field in Inventory), invoiced work orders remove part # qty from "allocated field" in Inventory.
 
Upvote 0 Downvote
So far I can only update BO'd Qty (in inventory) for any given part number from the first occurance only in the PO BO'd field (doesnt matter if it is the first, second last, etc PO where the part number is, it only picks the first occurnace), how do I get it to "scan" all PO's for a BO for any given part number?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PaulHunt
  • Locked
  • Question
Switch to Another Printer in Script WITHOUT Printing
Replies
0
Views
605
PaulHunt
PaulHunt
wallie32
  • Locked
  • Question
If statement to multiple fields
Replies
1
Views
245
JeanW
JeanW
Lemur21
  • Locked
  • Question
Calculation Fields referring to previous record
Replies
0
Views
165
Lemur21
Lemur21
shivnarine
  • Locked
  • Question
re-activating restricted fields in browse mode
Replies
1
Views
256
gmannatl
gmannatl
jimoo
  • Locked
  • Question
Move from Filemaker server to Network or other option...
Replies
2
Views
271
jimoo
jimoo

Part and Inventory Search

Sponsor

Back
Top