I am wondering if it be possible to create a script for an invoice to do the following - if someone gives us cash for an item, we would check a payment option box marked "cash" which would then prompt a calculation to take place where the amount received was subtracted from the total, giving us the change due. When a payment option was marked "credit" or "check" we would want this calculation to be stopped.

Right now we have a calculation set up that subtracts the amount received from the total; however, we never input the amount received unless we are getting cash. What is happening as a result is that the "amount received" for credit cards is not being input, and filemaker is taking the empty field to mean 0 dollars. It then subtracts 0 dollars from the total, and the total will appear again in the amount due field. This understandably freaks out our bookeeper, who sees this and thinks we're not charging people or giving them their change back.

Please let me know if I can clarify, thanks in advance for any help you can provide!!

This seems easier to address at the field definition level. Maybe you can start by giving us a list of the fields used in your current calc, along with the script/calc that calculates the balance. Then it should be clearer as to what you need.

Hello, here are the following fields:

Subtotal, Discount, Tax and Shipping which are all added together to create the calculation field Total (the calculation for that is: Subtotal - Discount + Sales Tax + Shipping). Below the Total, we have the fields Amount Received and Amount Due. Amount Due is a calculation field, and the calculation we have for that is "Amt. Received - Order Total."

For now, we only put a number in for Amt. Received if we receive cash. How one chooses the type of transaction (Visa, Master Card, Amex, cash, check) is by filling in a radio button by the appropriate choice. Perhaps there is a way to make it so that filling in the "cash" radio button triggers you to imput "Amt. Received" which will then trigger the calculation Amt. Received- Order Total. I'm assuming something similiar is set up in regular retail software like RetailPro, but I'm not sure.

Let me know if I can provide any more info that will describe the situation better.

Thanks!!

Edited October 25, 200619 yr by Guest

Maybe try:

Amount Due (calculation, number result) = case(Type of Transaction = "Cash"; Amt. Received - Order Total; 0)

I'm sure there's different ways these things are done. You can imagine that many stores need to allow for different types of payments for a bill, like putting some of it on a credit card, some on a check, etc. And there may even be some places that allow the customer to give a check larger than the bill in order to get cash back. Your system doesn't really allow for either of these possibilities, so hopeully it won't be an issue.

Thank you!! That works perfectly!!