Do you include a local tax group on the setup of the Jobs that fall into the reporting geographic area? (Job Cost, Setup, Jobs, AP and GL tab, tax group) Does the report need to sort first by vendor and then Job and provide a total for each vendor? Does this reporting apply to only those Vendors set with a vendor type = Subcontractor?

Denise:

1.  Thank you for your reply. 

2.  I hadn't included the tax group you mentioned in the job setup.  It sounds as though that would be fairly easy.   

3.  The sorting you described would work.  

4.  Yes, only applies to subcontractors.  

5.  I don't know if I mentioned it, but this would also have to be for a specific date range, typically, one calendar quarter.  

Thank you again for your reply. 

Denise:

1.  Thank you for your reply. 

2.  I hadn't included the tax group you mentioned in the job setup.  It sounds as though that would be fairly easy.   

3.  The sorting you described would work.  

4.  Yes, only applies to subcontractors.  

5.  I don't know if I mentioned it, but this would also have to be for a specific date range, typically, one calendar quarter.  

Thank you again for your reply. 

The Payment register by job allows a date range to be entered related to the date the invoice was paid.  A condition can be added to the report to show only the paid distributions associated with a specific tax group.  To add that condition you would select conditions in the Print selection window, then Add, then Index to select the AP Distribution record, the Tax Group EQ ..in the value enter the ID of the tax group for that is associated with City Mill. Click OK twice and then enter the range of dates in the print selection window

Denise:

1.  Thank you so much!  As soon as I come up for air, I'll give it a try!  

Regards,

CM