I am trying to produce a graph showing a stock level. My client holds stock of parts for his client and delivers 'just in time'. He will get a schedule of requirements for the coming 2/3 months. Depending on the requirements, my client may need to put into production items to cover the forthcoming deliveries. He obviously needs to see what the schedules deliveries will do to his stock levels.

His prices and stock level are determined by his client's annual requirements. His client will often cease to take parts without notifying my clients, so he needs to keep an eye on the situation.

I have set up 3 tables, Products, Transactions and Months.

I have produced a graph showing monthly deliveries in the Products table, the x axis is a rolling 24 month period, the y axis being the delivery quantity. This works well, it shows the monthly deliveries against a base level, it shows when his client stops taking delivery or doesn't take the contracted annual amount (per month).

I am trying to produce a graph to show what the scheduled deliveries will do to stock levels. Basically a graph of the running total over a period, say from 2 months ago to 3 months in the future. I can produce the x axis with no problem, but not the y axis.

I either get the net input/output for the month or a flat line showing the stock level, I can't get a graph of the effect of the deliveries on the stock level month by month.

Anybody tell me what I am doing wrong?

Thanks,

Nick Shutt
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>