Solutions > Core4 CRM

Find for unpaid invoices works on local, fails on server

(1/2) > >>

Gnurps:
We are having trouble with Invoice Payments, probably on only some records. On the hosted file, using the Script_Use_Invoices layout, I can find a particular customer's invoice by _kft__Contact_ID. The zz_Balance_Due_cn field clearly displays a number; the invoice is partially paid. But when I search for the same _kft__Contact_ID and add a second criteria of zz_Balance_Due >0, no records are found. If I find only for zz_Balance_Due > 0, it finds some records, but the particular customer's invoice is not among them.

If I perform these same finds on a local copy, it works. The customer's invoice is found.

This problem does not occur with all invoices, only some. That is, for some records, hosted, a find for a particular _kft__Contact_ID and zz_Balance_Due > 0 works for some,but not others.

Filemaker knowledge base warns that some unstored calcs will execute differently for hosted file vs. local, but Core 4's Invoices::zz_Balance_Due_cn field does not fall within any of the situations where that would happen.

I have tried closing and re-opening the file and that did not change anything. What now?

Jerel Malong:
What version of FileMaker and FileMaker Server are you running? Are they the same or different? Are they updated?

Gnurps:
Filemaker Pro 12 and 13 clients; FMS 12.03

Jerel Malong:
I've just tested a find for a specific contact ID and a zz__Balance_Due__cn > 0 on a hosted file and it worked. For your scenario, what is the difference between the invoices that do work and those that do not?

If you would like, you may want to consider a Paid Tech Support to help resolve the issue. You can contact us directly at (760)510-1200 or email support@productivecomputing.com.

Gnurps:

--- Quote from: Jerel Malong on March 14, 2014, 10:00:42 AM ---I've just tested a find for a specific contact ID and a zz__Balance_Due__cn > 0 on a hosted file and it worked. For your scenario, what is the difference between the invoices that do work and those that do not?

--- End quote ---

I have reviewed the problem in more detail. The find for zz__Balance_Due__cn > 0 evaluates differently depending on whether the file is hosted on Server vs. opened locally. On Server, this find does not find the invoices in question. When hosted by Pro, it does the find correctly.

Why is this happening? Filemaker has an article, KB6996, that notes differences in unstored calc evaluation, Server vs. Pro. But the conditions that cause this -- such as reliance on some get() functions -- do not apply to this field. The field is an unstored calculation that depends on the unstored field zz__Payment_Applied__cn, which calculates Sum ( invo_PMTLI::Amount ).

The problem made me worry that the file may be corrupt. I downloaded a copy and did a recover. The recovery process ALWAYS says that Core 4 is corrupt if you don't have all the plugins it is programmed for. So I also did a recover of the original Core4 file that I received from Productive and carefully evaluated what the two reports say. They do not have any significant differences, so I don't think my file is corrupt.

Not sure what to do next.

Navigation

[0] Message Index

[#] Next page

Go to full version