Clarity

Hi,

In our client organization we are are using CA Clarity 7.5.3 version. We face an issue in the GL allocation area that comes under the finacial management area of this tool.
The count inside the GL allocation count increases every week from the Normal count. While going through exception list inside preview GL allocation, found that the excetion with the entry "Debits do not equal credits" is the one which is raising this count. Does any one provide me the steps how to sort this our?

Any sort of your help will be very much appreciated.

Thanks & Regards

Kevin K Soman

Per KB TEC435594

Debits do not equal credits:

This exception means the total Credit amount doesn't match the total debit amount for the transaction. In this case, check if the allocation percentage for the Resource credit & the Charge To rule are set to 100%.

You could zero in on one transaction and check the credit and debit rules related to this particular transaction

Hello Connie_Fu,

Could you please provide the document of Per KB TEC435594 so that we could use it for fixing this issue?

Also let me know where to go to check if the allocation percentage for the Resource credit & the Charge To rule are set to 100%?

Thanks & Regards

Kevin

Document ID: TEC435594
Title: What are the possible GL Allocation Exceptions in Clarity?


Resource credit match not found:
Resource credit means which GL accounts receive credit for work done.
This exception means that there is no matching Resource Credit setup. Check in Admin > FOS> Resource Credit page, if there is an active allocation for the resource(s) is set. Those accounts are credited when the entity, location, department, transaction class, resource class, and date range of a ' resource credit ' best match the same fields on a transaction, which is created from a time entry or a voucher.

Resource credit is on hold:
This exception means there is a matching "Resource Credit" but is not active. Check in Admin > FOS> Resource Credit page, and change the status from On hold to Active.

Debits do not equal credits:
This exception means the total Credit amount doesn't match the total debit amount for the transaction. In this case, check if the allocation percentage for the Resource credit & the Charge To rule are set to 100%.

Charge To allocation rule not found:
"Charge to " is the GL account receiving the allocation, the one that has to pay, or is debited, a " sponsor. "
This exception means that an active project allocation is not set up. The allocation set up may vary depending on whether a project level or task level wip class is used. If the transaction is with project level wip class then check if an active allocation is setup in the Project > GL Allocations page. If the transaction is with task level wip class, then an active allocation must be defined for the charge code assigned to the task ( Admin > Project Management > Charge code).

Charge To allocation rule on hold / Charge To allocation rule is inactive:
Make sure the Charge To GL allocation rule that is set at Project / task level is 'Active'.


NJ

Hello NJ,

Could you please let me know how to find the allocation percentage for a Resource credit & the Charge To rule in clarity as mentioned your yesterday's reply?

Thanks & Regards
Kevin

Hello Kevin

Based on what you find in the transaction details (either query or look in the UI) : first identify the project department and location, identify the resource department and location; next check the project's Chargebacks > Options sub tab, find out if you're using investment debut rule or standard rule. Find out which department is paying for the transactions, for how many percents and in which time periods, find out if the transaction date falls in the time periods that pay out 100%

Next find out if you have a credit rule that credit back to the resource department, find out if there are other constraints such as charge code, etc

It will help if you set up chargebacks with very simple data and go through the whole process - it's actually not as complicated as some may think :) You can use the Financial Management User Guide for v13 which has really great explanation on how to set it up. The User Guide is very useful even if you are not on v13 yet.

Lastly check if administration > WIP settings is set to employee department and location, we're not sure how this should affect chargebacks and are getting clarifications. For now set it to Employee department and location unless you have specific need for it to be set to Project

-Connie

Hello Connie,

Could you please provide the solution with reference to the version 7.5.3 version?

Thanks & Regards
Kevin Soman

Kevin
Given that the deisgn in Chargebacks hasn't really changed much since v7, you can follow the same steps for troubleshooting

Regards
Connie

Hello Connie,

Could you please share a document containing the resolution of the above issue with screen shot?

This will be helpful on this.

 

Thanks & Regards

Kevin.Soman

Hi Kevin

I don't have a document completed with steps and screenshots for a walk through. If you are still experiencing error or incorrect data following the Financial User Guide, please log a Support case for assistance. There was a great level of effort that was put in to improve the Chargebacks portion of the Financial User Guide, so you might be surprised at how detailed it is compared to some of the other components.

Since this thread has already been marked as RESOLVED, please open a new thread with more details of the problem you are having so we can see where exactly the problem could be with your setup.

Thanks
Connie