thought it might be useful to see an update of my layout. there is now a searchable selecter portal that i would like the qty available to display in
I am getting close! I have Inventory::cQTY available =inventory::Stock Level(how many we own)-sLine Items::qty in use(summary when sorted by inv id)
I am not familiar enough with the summary functions to know how to make it create a total of qty used between a date range.
I'm working on this exact problem/application, and am wondering how much of your work you would be willing to share? Having looked at various 'solutions' and turnkey solutions, I decided I just have to do it myself, however seeing your screenshots tells me we see things in the same way. Anyway, I'm only one step above beginner though I have built a fairly complex fm solution for my design work, and have a decent amount of programming experience to know what I need to do, then it's just a matter of finding the name of the function in fm.
Anyway, if you've finished, I'd love if you could at least share your approach to some problems, and if you haven't finished, I'd be happy to work together.
i had to put this on hold for the summer. It will be a critical component that I need functioning by march of 2013. I will be resuming development by December.