AnsweredAssumed Answered

Invoice total field on job table not working

Question asked by petek157 on Sep 2, 2011
Latest reply on Sep 2, 2011 by petek157


Invoice total field on job table not working


I have been racking my brain trying to figure out whats going on.  I have done this a hundred times and it always works.  I just cant seem to see what I am missing and I have been at it for two solid days.

I have a Customer table, a job table, a materials invoice table, and a materials line item table.  I have all of the relationships set like I would any other time, What I am trying to do is take the total of all of a jobs material invoices and have a field on the job page that shows it.

I have a invoice total in the materials table that takes the sum of all of the line items in a portal on the Invoice layout.  That works perfect.  I have a field in the job table set to a calculation of the sum of the invoice totals.  But that field on the job layout doesnt show anything.

I have been going back and forth from another database that I have that does this exact same thing and it works perfect. So I am comparing the two and they are exactly the same.

Any suggestion on what I could be missing?

Need more info just ask.