Jump to content

Rosalie

Members
  • Content count

    20
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rosalie

  • Rank
    newbie

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

649 profile views
  1. Rosalie

    Inventory

    Hi Webko, Thanks for the reply, just for a background, I want to trace the Lot Number of a certain product and how many quantities they used for production. If we have a production a certain product they will be putting the Lot Number and quantities they used on a Inventory Card. The information on the Inventory card are ( Date ; Lot Number of Product was Used ; Quantity Used and Quantity Returned) Thanks.
  2. Rosalie

    Inventory

    Hello All, Below is the calculation that I want to improve to get the result that I want. If ( IsEmpty ( Sum ( Stock Transactions::Units In ) - Sum ( Stock Transactions::Units Out ) ) ; 0 ; Sum ( Stock Transactions::Units In ) - Sum ( Stock Transactions::Units Out ) ) I want that if I enter a value to the "Units In" in the Stock Transaction Portal it will not add in the calculation on my "Units on Hand" ; and I want also that If I enter a value to the "Units Out" field in the Stock Transaction Portal it will automatically enter the remaining total quantity in my "Units In" and it will also update my "Quantity on Hand" field. is this possible to achieved? In the attached file If I received 15 Stocks and 3 is out i want that in the "Units on Hand" will show 9 not 2. Thank you.
  3. Hello Everyone, Im using the Inventory Starter Solution for my inventory needs. but I am having a trouble in changing the "Units in Hand" Field. I want that if I enter a value to the "Units In" in the Stock Transaction Portal it will not add in the calculation on my "Units on Hand" ; and I want also that If I enter a value to the "Units Out" field in the Stock Transaction Portal it will automatically enter the remaining total quantity in my "Units In" and it will also update my "Quantity on Hand" field. is this possible to achieved? In the attached file If I received 15 Stocks and 3 is out i want that in the "Units on Hand" will show 9 not 21. Please help me with the calculation on Units on Hand. I have attached the Inventory file that Im working for your reference. Thank you so much to any help. Rose Inventory.fmp12
  4. Whats the Acct Name and PW?
  5. 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
  6. Why you said sorry? Its your suggestion about portal filtering and its work. Im so glad that your suggestion solved one of my problem.
  7. 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.
  8. 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
  9. Hi Don, Thank you for the file. I just add a dot(.) to the extension and it works like a charm. Rose
  10. Rosalie

    Portal Command Menus

    Thanks Alex, works like a charm
  11. 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
  12. Rosalie

    expiring next month

    Hi BruceR, Thank you for the reply. Its not working the sense that I I tried to put October 08, 2015 to my Expiry Date field When I click my Expired next month button, not showing anything and its not going to my List View Layout..
  13. Hello All, I want to save and print my MAterials that are expiring for the next month; Below is the script but it doesn't work. Can you please help me improve and correct it. Enter Find Mode[] Set Field[Materials::Expiry Date,Month(Get(CurrentDate))+1 Perform Find[] Set Variable[$found;Value:Get(FoundCount)] If[$found>0] Set Variable[$Counter;Value:1] Loop Set Variable[$names & GetNthRecord(Materials::Materials Name;$counter) & "¶" Exit Loop If [$counter=$found] Set Variable[$counter;Value:$counter + 1] Show Custom Dialog [Expiring Materials for the next month" Attention!! "ATTENTION!!!! NEXT MONTH EXPIRING Materials\"; \ & $names" Go to Layout [Materials List View" (Materials)] Show All Records Save Record as Excel End Loop End If Thank you so much in advance Rose
  14. Rosalie

    Pop up windows

    Hi Fitch, Thank you. Please pardon the newbie... How can I integrate the Move/Resize Window to my new script New WIndow [Name: "Print Label"] Go to Layout ["Label" (Labels)] Enter Preview Mode [] Print Setup [Restore] Thanks you.
  15. Rosalie

    Pop up windows

    Hi Fitch, I tried the examples but I want my original window to be open when the other pop up window appears. Thank you.
×

Important Information

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