Departmental Reporting Issue - Income Statement

SOLVED

Hello-

We are just starting out with Sage 100 Contractor.  I have created a job and assigned it to a department.  I have created an invoice, dated 5/15/17, against this job and it has posted to both AR and my Revenue account. 

I tried to run an income statement using "between May and May" and the revenue amount comes up as $0.  If I run the income statement with YTD totals, and the same period filter, the amount only shows in the YTD column.

I can't get the amount to show up at all using the departmental Income statement.  

All of our income will be logged a jobs and I would like to use the jobs as the mechanism for assigning cost and revenue to the departments.  I notice that the payable entry form and the AR entry form do not include the department field.

Is there a better way to get departmental reporting functionality at the same time as using the job cost system?

Thanks

Tim

  • 0
    verified answer
    Tim,

    I suspect you will find that you inadvertently posted the invoice dated 05/15/17 to a posting period other than May 2017. Remember that Sage 100 Contractor general ledger and financial statement activity is driven by the designated posting period, not the transaction date (as it is in QuickBooks). If the Invoice has not had a payment or credit posted to it yet, find the invoice, drill down to the resulting journal transaction, confirm that it was posted to the wrong posting period (look at the fields at the bottom on the 1-3 screen. I presume you will find that it was posted to April or earlier. If so, back out to the original 3-2 Invoice record, copy it, void it, paste the copied record and post it to the correct posting period. If a payment or credit has been applied, the system won't let you void the record and the correct gets more complicated....
  • 0 in reply to Walt Mathieson
    Thank you Walt. You were correct, the posted period was incorrect.