Jump to content
Sign in to follow this  
efrancis

Inventory Database calculation

Recommended Posts

Hi community, this is my very 1st post as I just registered and I am a newbie to FM, so please bear with me. I am creating an inventory database for a small bar. When for instance products like (1 litre wine bottles) comes into stock I enter the items into stock and it added the amount of bottles that was purchased fine. Now when it is time to sell wine to a customer for instance, it is sold as glasses of let's say (X) amount from a bottle, but not the whole bottle is used since it is divided into several glasses of wine that in total are equal to the 1 litre. How do I calculate the (X) amount that was sold from a bottle until it's equal to 1 litre,therefore the stock is now updated to 1 bottle out of stock, instead of showing that an entire bottle was moved out of stock. I hope I explained it right. If that topic was already discussed, please point me to it. Thank you and have a great week-end

Share this post


Link to post
Share on other sites

Did you look at the Templates a.k.a. “Use a Starter Solution” files that came with the FileMaker Pro application?

 

Here is an article and file that I like.

 

Inventory Transactions by Todd Geist 

Share this post


Link to post
Share on other sites

Not sure what exactly your question is. Obviously, you need to know how much wine is served in a glass. If it's, say, 125 ml, then you can multiply the total number of glasses sold by 0.125 and get the total amount in litres.

 

If you want to know the number of whole bottles sold as glasses, use this formula =

Div ( glasses * glass capacity ; bottle capacity )

For example, 15 glasses of 125 ml (total of 1.875 l) sold out of bottles of 750 ml each is =

Div ( 15 * .125 ; .75 )

which will return 2 whole bottles.

Share this post


Link to post
Share on other sites

Did you look at the Templates a.k.a. “Use a Starter Solution” files that came with the FileMaker Pro application?

 

Here is an article and file that I like.

 

Inventory Transactions by Todd Geist 

Thank you guys for your responses. Actually I did use the inventory template as a starting point, but it only gives you the option of adding to and taking from stock. In my case I need to add one more option that will divide the 1liter bottle into let's say 5 glasses sold. When you multiply the 5 glasses, then you will have the one liter bottle taken out of stock. different bottles will have different sizes and I could assign a code to each onre of them that tells me exactly how much wine (1,2, or 3 liters) each contains and how many glasses sold will equal to that amount of liters..I hope it's a little clearer and thank you for your help Mr Lee.

Share this post


Link to post
Share on other sites

Not sure what exactly your question is. Obviously, you need to know how much wine is served in a glass. If it's, say, 125 ml, then you can multiply the total number of glasses sold by 0.125 and get the total amount in litres.

 

If you want to know the number of whole bottles sold as glasses, use this formula =

Div ( glasses * glass capacity ; bottle capacity )

For example, 15 glasses of 125 ml (total of 1.875 l) sold out of bottles of 750 ml each is =

Div ( 15 * .125 ; .75 )

which will return 2 whole bottles.

I think you understood it right but let me set an example, and please be patient with me as I try to fully understand the workings of FM. Let's say I have a bottle of wine that is 70cl and I know that is equal to 20 small glaces. I used the inventory templatewhich does not have another option for how many glaces is sold. So I played with it and added that option which does not have any calculations assigned to it yet. Where do i go from there to add all my calculations for this scenario, including assigning a code that identifies the bottle with it's size and number of glasses it contains automatically when i enter it into the system. A detail screen with examples would be greatfully appreciated for a FM dummy such as myself. Thanks in advanced and have a blessed day.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Rich
      Greets, all:
      I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table:
      UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) )
      (I'm using this calc because the child table contains multiple records with the same course number; it's not a key field.)
      My intent is to use six buttons--in the parent table--where each button would grab an assigned row's value using the calculation above. For example, say that the above calc has this result:
      AST-100
      EDU-100
      EDU-300
      PHY-100
      SOC-100
      TMA-001
      I want Button 1 to grab AST-100; Button 2 to grab EDU-100; Button 3 to grab EDU-300, etc.
      Mind you, I can't make a value list out of Temp because it can't be indexed.
      TIA for your help! 
       
    • By Asu
      I know. Don't use them. But There is a simple task and a repeating field would be a quick solution.
      Field 1: a number
      Field 2: a calculated repeating field, each repetition adds the repetition number to the value of Field 1.
      Can it be done?
      Thanks
    • By TaiChi56
      I have always developed with FileMaker for windows. I have bought myself a MacBook Air and love it. So now I am using FileMaker 16 Pro advance for MAC. I know that MAC does not label their directories like windows does. So I am having problems figuring out to get the right coding to access my photos. I have a folder called "Photos" that reside on the C: drive in windows. Then I reference that folder so pictures will populate automatically when I put in a record. Here is what I have on the windows fileMaker:
      ImagePath:
      Let ( [ // Transform the contents of a container field named Images to text ImageRef = GetAsText ( ImagePath); Photos = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/")) ]; Middle ( ImageRef; Photos + 1; Length ( ImageRef ) - Photos ) ) images:
      "imagewin:/C:/Photos/" & Film::title & ".jpg" Then I go into Import folder and point to the folder all the photos are in. The problem I have now is how to point to that folder in "imagewin", is their an alternative called imagemac, then I could put in Macintosh HD/Users/patricks/Documents.  The folder is in the Document folder, called Photos. Thank you for any help.
    • By stan111
      Gents, need your help on the following issue:
      I need to track my expanses. There are 4 tables: Products, PriceChanges, Transactions.
      The problem: I need to make a script which will make calculations in transactions tab, accounting for the latest price change.
      Example:
      01 jan17 I bought one bottle of wine for $1 
      03 jan 17 I bought the same bottle of wine for $1,5. So the latest price is $1.5
      In Products table there is one record which is wine. 
      In PriceChanges table there are two records: $1 and $1.5
      I need that Transactions table automatically take corresponding wine prices while adding new or past records.
       
    • By Asu
      Hello FM Mavens, 
      I am likely missing something. 
      I have a script step that calculates the dimensions of an image in a container field. There are many such fields so the script should work with any arbitrary one. 
      I get the name of the field by using script parameter Get(ActiveFieldName). 
      Let's say I have a container field "cont1". The script is triggered by entering the field.
      I am trying to calculate the height of the image by using 
      GetContainerAttribute (Get ( LayoutTableName ) & "::" & Get ( ScriptParameter ); "height" ) The results are question marks - I am not sure why. If I explicitly identify the fields then the expression works. 
      Tried the same expression (Get ( LayoutTableName ) & "::" & Get ( ScriptParameter )) in the script step "Set Field by Name" and it worked, which means that the expression correctly identifies the field the script is attached to. Then why is it not getting it the first step? What's wrong with the calculation? (FM17)
      Thanks
      Asu
       
      (I hope I posted it in the correct section)
  • Who Viewed the Topic

    3 members have viewed this topic:
    moriya0238  Pacotools  aztrix55 
×
×
  • Create New...

Important Information

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