x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 239 subscribers
  • Views 1598 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Siri H.

Field for Unbilled vs Billed WIP on Report?

SOLVED
Posted By

I am creating a report in Report Designer to show all billable entries against a job.  The report pulls from the Billing WIP tables - both Billed and Unbilled.  Is there a way to mark each row to show which have come from which table?  I'm searching for the field to add to my report to indicate that but I can't figure out what it would be called or if it's possible.  Any help is appreciated.  Thank you.

Parents
  • +1
    verified answer

    Hi Siri H,

    You may be able to use other fields on the table to help.  For example, "if(invoice_num = "","Unbilled","Billed") and save it as a formula called "Source."  You will need to test different fields out to achieve the results you are looking for.  Let me know if you have any questions.

    Thanks,

    John DiCostanzo

    Managing Partner | Nexus Consulting LLC

Reply
  • +1
    verified answer

    Hi Siri H,

    You may be able to use other fields on the table to help.  For example, "if(invoice_num = "","Unbilled","Billed") and save it as a formula called "Source."  You will need to test different fields out to achieve the results you are looking for.  Let me know if you have any questions.

    Thanks,

    John DiCostanzo

    Managing Partner | Nexus Consulting LLC

Children

*Community Hub is the new name for Sage City