Hello Gurus,

 

I have a tables which I called Dashboard Table; Materials Table and I have a related table Which I called Expiring Next Month & Retest Next Month.

 

I want to save all my Expiring Materials for the Next Month and Retest Materials for the Next Month in one Excel sheet.

 

Please find attached file that Im working.

 

Thank you so much.

Warehouse Management.fp7

Rosalie,

I attached a mod of your file that contains an export routine script. Here is what I implemented:

 - In your Materials table, I defined a global text field called "gType". I, also, added a few calculation text fields to deal with file prefixes on export files based on computer platform (Mac or PC). I normal would just add a few custom function for this. But your profile says you ARE NOT using FMP11 Developer.

- I defined a Materials Temp table. Same fields as your Materials table with an additional field called "type".

- Defined a script that initializes Materials Temp (MT) table (Show all/deletes all records), goes back to Materials table and sets gType to "Expiring", does a does a find for "expiring" materials, imports them to "MT",  goes back to Materials table and set gType to "Retest", does a does a find for "retest" materials, imports them to "MT", then exports to EXCEL on your Desktop.

Tear it apart and post questions if you have them.

Good luck ;o) 

Warehouse Management2.fp7

Hi Don,

Thank you for the file. I just add a dot(.) to the extension and it works like a charm.

Rose

Hello All,

This is a follow up question regarding the above, Can you please help me how to remove the count of my Materials that has a zero (0) balances. I dont like to see them in my warning count in my dashboard and in my portals.

Please find attached file that Im working on.

Thank you so much in Advance.

 

Rose

 

Warehouse Management.fp7

Edited October 2, 201510 yr by Rosalie

you could filter portals like:

Expiring Next Month::Material Balance>0

and layouts, maybe on layout enter script which will start at rec1 and omit where balance=0 ?

Hi Alex,

I figured it out about portal filtering. my next problem is how not to include the eliminated Materials with Zero Balances into my Count alert.

Thank you.

Edited October 2, 201510 yr by Rosalie

sorry my bad

Edited October 2, 201510 yr by Alex Lxj

Why you said sorry? Its your suggestion about portal filtering and its work.

Im so glad that your suggestion solved one of my problem.

Edited October 3, 201510 yr by Rosalie

Hi ALex,

Thanks again for the file. my other problem is how to change the calculation of my display alert count on my dashboard that showing the number of my expired and retest material.

I would appreciate if someone could help me on that.

Thank you so much.

 

Rose

Warehouse Management.fp7

Edited October 3, 201510 yr by Rosalie

uploaded wrong file  too many files everywhere

try this one

WM.fmp12