Formulas for Fields from Contracts in Report Designer

Question

I would like to add a couple of fields from the Contracts module to a report created in Report Designer. Does anyone have a formula I can use to add the Retainage percentage field and the Last Number Used field?

Char F · Accepted Answer

An example of a lookup formula using the job and contract records, which requires the job ID and contract ID to be identical, including any dashes or dots, is: 
 LOOKUP(last auto number (CN Contract), Job (JC Job)) 
 Additionally, you can retrieve the last draw number directly from the job record. This field, called "Last Draw," is updated with the highest draw number posted in job cost. The draw number on the contract can become out of sync with the job's draw numbers, as the contract last auto number updates each time an invoice is final printed. For instance, if draw 4 is final printed, then reverted to pending for corrections, and finalized again, the draw number would prefil as draw 5 and the last auto number would show 5 in contracts. If the user changes it back to draw 4, the last auto number on the contract will remain at 5, as it has already incremented. 
 If your job and contract numbers do not align, we may need to refer you to your consultant or Sage Expert Services for help getting the information you need on your report.

Sage Construction & Real Estate

Formulas for Fields from Contracts in Report Designer

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING