Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 3 of 3

Thread: Script Needed

  1. #1
    Forum Member
    Join Date
    Aug 2017
    Posts
    1
    Location
    Lake Los Angeles CA Los Angeles
    FileMaker Pro Software
    FileMaker 11
    OS
    Windows
    Skill Level
    Intermediate
    Last Post
    08-24-2017
    Local Date
    09-20-2017
    Local Time
    06:52 AM
    Last Active
    08-25-2017

    Script Needed

    I need a script for a monthly billing solution. I would appreciate any help but would be willing to pay.

    There is a single file and a single table.

    There are 7 fields
    Customer #
    Date
    Description
    Charge
    Payment
    Balance
    Status

    The Layout is similar to a check register however I need more than a simple check register. Customers do not always pay every month and when they do they sometimes don't pay the entire balance.

    I need a way to
    A.) disperse payments to charges and close the transaction (charge) if the payment is equal to or greater than the charge.
    B.) if the payment is less than the charge I need to deduct the payment from the charge.
    B.) change the balance to reflect the change.

    Also, sometimes customers pay more than the balance or they are credited and I need to reflect that also.

    The purpose of the status field is for aging however I have already written code to age the transactions.

    Example

    Example.png

  2. #2
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    86
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    09-19-2017
    Local Date
    09-20-2017
    Local Time
    07:52 AM
    Last Active
    09-19-2017

    Payments Script

    The attached file should do the trick or at least get you going in the right direction. Enjoy!
    Attached Files Attached Files
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15.

  3. #3
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    86
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    09-19-2017
    Local Date
    09-20-2017
    Local Time
    07:52 AM
    Last Active
    09-19-2017

    Whoops

    Just seeing in your profile that you have FileMaker 11 and I posted a .fmp12 file. Here's a screen shot of the script.
    Attached Images Attached Images
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15.

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Similar Threads

  1. help needed writing a script!
    By yikim in forum FileMaker Pro 7.0
    Replies: 0
    Last Post: 07-13-2009, 12:49 PM
  2. Dev Needed for Script
    By Asta in forum Looking for a FileMaker Developer - Consultant - Hosting Provider
    Replies: 3
    Last Post: 06-21-2008, 06:37 AM
  3. Simple Sort Script needed
    By er777 in forum FileMaker Pro 7.0
    Replies: 14
    Last Post: 03-15-2008, 06:39 PM
  4. Help or tutor needed for a script
    By jinglesms in forum Microsoft Office & FileMaker
    Replies: 1
    Last Post: 12-19-2007, 11:23 AM
  5. Simple script help needed
    By Mitchripple in forum ScriptMaker and Scripting
    Replies: 1
    Last Post: 09-13-2002, 06:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.