Please, please, please provide a report that will show mismatches between g/l account and job cost type. I have searched & searched and cannot find one. I've tried to create a custom report, but Sage does not allow access to job cost records from the G/L module (in custom reporting) and does not give access to G/L account from the job cost side. Very, very frustrating! It sometimes takes hours to track down costs that were coded incorrectly in A/P, credit card entry, etc.
by: Kay K. | over a year ago | General Ledger
Comments
I completely agree. I thought I was the only one with this issue. I have even gone so far as to speak to a consultant who creates reports. However, he said that he can't find a way to link the 2 areas. There are several things like this in Sage 100 Contractor that seem like they should be obvious features. I came from QuickBooks Enterprise Contractor. Although QB is not robust enough to handle our needs anymore, it was a way more polished and user-friendly product.
Copy this report to MB7\Custom Reports and see if it can help you:
https://drive.google.com/file/d/0B-xomOX6DpeiMlJ0MEI1OUFBcGs/view?usp=sharing
I discover this problem whenever I close the month and it is hard to track where the error was made. I wish there was a warning pop up right then and there in A/P when the cost type doesn't match the GL account, saying "are you sure you want to post?" like how it does that when the posting period doesn't match the date.
Also need a way to reconcile G/L sub-account (if using Job # as subaccount) to J/C.
Agree with Gary! Our issue is on A/R invoices as well. The job listed at the top of the invoice should always match the subaccount in the table. We need a warning message to alert us when they do not match or at least an easy report to run to find errors.
I agree Jeffery C. This is not that complex. The direct cost account number should lock the job cost type. If I am posting labor in GL, it should not allow me to post that labor cost to material in job cost. This is not rocket science SAGE. PLEASE FIX THIS!!
If you lock the cost code type to the direct cost GL account number, then there is no need to enter it on 6-3. Simple fix. SAGE please fix this!!!
1-7 General Ledger Accounts has a field called Cost Type. If this is used for Direct Cost account why not make use balances for the GL match the balance for cost type in cost entry points like 1-3 and 4-2.
Def need this. I have the same issue monthly.
or give the ability to lock the GL account to a cost type!