Jump to content

malia

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About malia

  • Rank
    novice
  1. I don't know if the Malaria was an insult or a typo (and it comes across as an insult), but... The table was there, the knowledge of how to calculate the values I needed wasn't there when I first started the thread. Yes, John was trying to help, but he was insisting I do it in a method which was not feasible for me. I feel that you have been helpful, with the suggestion of the inventory table. However, if this is going to degrade into what was said when and what was and was not clear, then it becomes pointless.
  2. Hi laretta When I first started the thread, I didn't have the solution. Later on, I found an older post on this board that provided a link to a downloadable file that does count off inventory and I was able to resolve most of the problem by incorporating that file's calculations and methodology. My last post was simply just posting what I came up with, after the fact, just to check and see if anything was missing.
  3. Hi Laretta! I did create an inventory transactions table. I should have mentioned that upfront, but I wanted to keep the question simple (and maybe that was not a wise thing to do). I have different types of transactions in that table: starting inventory orders (deductions in inventory) purchase order receipts (increases in inventory) manual adjustments (can be a deduction or increase) (thus far... I have not added in returns yet) The calculations will take longer with more data, but my thinking (which could be wrong) is that I can set regular time intervals to c
  4. If i think I understand you correctly: you have one table that holds the "master information" of the items and the locations of those items and quantities you have another table that keeps track of movements of those items or increases or decreases in quantity If this is correct then In your master file that tracks the summary data, you can use the calculation field and base the results of the calculation field on the sum of the value in the appropriate field in the table that tracks all the changes. Which is essentially what comment wrote (it's not a summary field)..
  5. I could have been more clear, yes, lesson learned. But the fact still remains I asked how to do something specific and you continued to question why I would not or could not do it a different way. Again, thank you for your help. Your suggestions are appreciated and may be useful in the future, they just were not useful for this particular application because I needed something to do exactly what I asked about (for various reason). Again, thank you.
  6. I didn't want to know how to prevent a line item from shipping, I wanted the database to only INDICATE which items could not ship. Just to return a value indicating the stock status of that particular item. This was my initial question Correct, but revealing that the data was imported was only relevant because you figured that it should be done differently, not because you actually looked at what I asked. Only because you said "why don't you do it this way" did it become necessary to explain how the data got in the databse in the first place. I could have gone on about
  7. Mr. Vodka, I appreciate your help, but it seems now you are getting into arguing business processes rather than taking the problem or question at face value. This is the way it needs to be done. Yes, at order import, I can write a script that loops through and checks inventory, however, that still does not solve the problem of updating that inventory availability status when new stock is received. There are also other conditions that affect inventory status, such as another order being cancelled before shipping, thus releasing the stock to become availabile. Or another order bei
  8. Even if I used the loop, the loop would still have to perform the same function of being able to count off or allocate quantity to know if the item was available for shipping, so we're right back at square one, which is actually having a way of counting off or allocating the quantity. Also, having a constant look wouldn't be good, because, when inventory is received, the count needs to be refreshed and looping each time would be a lot of scripts. In searching this site some more, I found a solution which does this feature, http://www.nightwing.com.au/FileMaker/demos8/demo807.ht
  9. I can't do that becuase the orders aren't manually entered, one at a time, they are imported from a website's export feature.
  10. I'm new to the forums, and I am seeking help because I've had this issue that I can't figure out. To simplify, let's say I have three tables: 1- Orders 2- Line items in those orders 3- Products The line items contain the quantity of an item ordered. The products database calculates how many items are left in inventory by taking the starting inventory and deducting the sum of the quantities for the line items, that all works fine. However, this is the tricky part. Say item 1234 has 4 units in stock Order 1- has qty 1 unit Order 2- has qty 2 units Orde
×
×
  • Create New...

Important Information

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