Removing Zero (0) Balances to the Count

[Rosalie]

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

[dwdata]

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

[Rosalie]

Hi Don,

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

Rose

[Rosalie]

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, 2015 by Rosalie

[Alex Lxj]

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 ?

[Rosalie]

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, 2015 by Rosalie

[Alex Lxj]

sorry my bad

Edited October 2, 2015 by Alex Lxj

[Rosalie]

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, 2015 by Rosalie

[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, 2015 by Rosalie

[Alex Lxj]

uploaded wrong file  too many files everywhere

try this one

WM.fmp12