Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About eibcga

  • Rank

Profile Information

  • Gender
    Not Telling

Contact Methods

  • Skype
  1. I have taken a somewhat different approach to Dr. Evil's solution... I have one table called "Contact" which includes customers and vendors. In this manner, if a customer and a vendor are the same company, it will only appear once in my database. Over time, any particular contact can have many transactions ("Journal"). Each transaction, due to double-entry bookkeeping requirements, can have many line items ("Ledger"). Each account type (asset, liability, equity, revenue, expense) can have many account groups. Each account group can have many accounts. Each sub-account can have m
  2. Here's the new online help link with the detailed new features in FMP12. http://www.filemaker.com/12help/html/fmp_basics.3.2.html#1081648
  3. I wanted to follow up on the problem I was having that I mentioned in the previous posts on this topic. I have figured out a work-around on my own, thanks to all of your guidance I have received in the past. I created a new calculation field in the Journal table called "total_jrnl_alloc", Unstored, =Sum(Ledger_Alloc::amount). If the sum is equal to zero, then the total debits (any positive values) equal the total credits (any negative values). I also created a new number global field in the Ledger table called "g_acctid" and input the field value "3999", indicating that account ID'
  4. Hello all, a FMPA11v4 Mac beginner user here trying to design a human resources database to track employees and their promotions throughout their employment in a large publicly traded company. Attached is the ERD which I hope has the right idea. An employee can receive many job ratings, and a rating can be shared by many employees. An employee can have many job positions, and a job position can have many employees. A department can have many locations, and a location can have many departments. A department can have many positions, but each position can only have one department. A di
  5. Thank you Vaughan and comment. Comment, I thought I could resolve my previous thread by just approaching the problem another way by using conditional formatting on the layout that had a lot of irrelevant information. Based on Vaughan's response, I'm back where I started. It was worth a try. Thanks.
  6. As shown in my attached screenshot, I'm trying to print a list of records from a found set, but only those records where the value in the LEDGER::total summary field is equal to zero. Currently, the layout is showing all records, not just the records where the total field is equal to zero. I thought I could use Conditional Formatting to accomplish this. If the field's value is not equal to zero, I want to "skip" these records by changing the text colour of each the fields to white. But, I'm not getting the desired results (the result is that it white's out all records). I thought using Ge
  7. I'm understanding now that, while I understand the accounting theory and what information I want, I'm having difficulty trying to explain it in database terms, and to design the database to reflect the real-world situation. I'll try: I want to find any and all particular journal entries that only: 1. debits one or more expense accounts, and credits one or more expense accounts, or 2. debits one or more revenue accounts, and credits one or more revenue accounts, or 3. debits one or more expense accounts, and credits one or more revenue accounts Notes #1
  8. Thank you bcooney, and comment. I tried to get the following script working, but it's not giving the desired results (i.e., the found set is giving me transaction line items in the LEDGER table that also involve accounts with account IDs < 3999 when this is not what I asked for] . Go to Layout ["LEDGER" (LEDGER)] View As [View as Table] Enter Find Mode [] Set Field [LEDGER::_kf_acct_id; "> " & 3999] Set Field [JOURNAL::date; Year (Get(CurrentDate))] Set Field [JOURNAL::total; 0] Set Error Capture [On] Perform Find [] If [Get (FoundCount)>0] Go to Rela
  9. Hi LaRetta, I think you and I are on the same page. Perhaps I'm just not explaining things properly and have not provided all the details. I'm a beginner FileMaker user, but I'm a professional accountant working in an accounting firm for many years. I'm trying to develop a solution to be used to analyze financial transactions in various ways for auditing and fraud investigation purposes. It is not designed to be bookkeeping or accounting software. I have tested this very crude solution by using it to track my own personal finances. As well, I have been using this solution to import
  10. Yes, would like to have a result that is a found set of all ledger records where the sum of these child records equals to zero, but only if all the child records affect revenue or expense accounts. That is, account IDs >3999. Revenue accounts have ID of 4000-4999. Expenses have account ID of 5000-5999. Ledger_GTRR is a query relationship used in a separate and unrelated script. Journal is basically another name for transaction. Ledger is basically transaction detail or journal line items. You're right, _kf_trans_id could be renamed _kf_journal_id. For example, I enter a transaction
  11. Hello all, I'm a beginner using FMPA11v4 on Mac OS X Lion. I designed a basic database that helps analyze financial transactions in various ways using standard double-entry bookkeeping journal entries. It suits my needs so far, but I'd like to add more features, etc. as I learn new skills in FileMaker. I'm trying to automate these steps in FileMaker using a script, etc. Here are the steps I currently do manually in FileMaker: 1) Enter the LEDGER layout in table view (LEDGER tracks JOURNAL details or line items, with an amount field that has positive amounts for debits,
  12. We are told that a nurse can only work at only one facility. But, unless there's typos in the above listing, I'm confused why the relationship would not be the following, since, for example, Nurse Tyrone (Katrina, and Andy) can be related to more than one facility (Facility 2 and 3): FACILITY ——< NURSE_FACILITY >—— NURSE ——< NURSE_DOCTOR >—— DOCTOR ?
  • Create New...

Important Information

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