Jump to content

Removing Zero (0) Balances to the Count


This topic is 3074 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Rosalie
Link to comment
Share on other sites

This topic is 3074 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.