Marks Group

Thanks Fixed my Issue

2012-05-21T17:15:56.457-04:00

Thanks Fixed my Issue

Talk about perfect timing with your post! I was st...

2012-05-16T17:31:58.949-04:00

Talk about perfect timing with your post! I was struggling to find the answer and you gave it to me exactly in the conext I was applying it.

Thanks!

I'm sorry to hear of your situation, but glad ...

2012-05-09T13:31:11.085-04:00

I'm sorry to hear of your situation, but glad that you reached out for help.

You said that this was only done wrong for a year, so I am going to assume that the liabilities are still showing as due to be paid on the Pay Liabilties screen and in the chart of accounts.

There are several methods, but I think it important to maintain an audit trail and keep the "incorrect" checks that have cleared in QuickBooks. Therefore here is what I suggest....

Before you start making any corrections, make a backup of the data file.

1) Print or document the checks that were originally written so you have them to review when making the corrections.

2) From the "Pay Liabiliaties" screen, "Pay" each of the taxes again by check. Use the same check number and date of the originals. QuickBooks will warn you about a duplicate check number, but say OK.

4) When you are finished, the liabilities screen and chart of accounts should be current.

4) Go back to the original checks and void each. You may want to add a note that indicates corrected via liabilities payment.

5) Now you will have to complete your bank reconciliation as you will have altered each of the months touched by this correction.

Since I will assume that you have already reconciled April, you can do one "adjusting" reconciliation and date it 5/1. Use the same ending figure as you did for April, and then check off all the checks that have been rewritten and voided. You should then print the reconciliation report and keep it as documentation of the adjustments.

You should be good to go after this. If you have any questions, please let me know. Good luck in your new position!

This was very helpful - but is there a way to make...

2012-05-09T10:21:18.878-04:00

This was very helpful - but is there a way to make sure the minutes will always show 2 characters?

Example:
232:07 instead of 232:7

I have recently assumed control of finances for an...

2012-05-08T17:48:20.363-04:00

I have recently assumed control of finances for an organization whose previous financial authority did exactly what your post said not to do. Liabilities for the past year have been paid with "write checks" and applied to a tax expense account, which really throws off the budget!

So what's the best course of action to correct this mistake?

oh man...so simple.....:) Thanks Justin, Bill

2012-05-07T16:49:53.346-04:00

oh man...so simple.....:)
Thanks Justin,
Bill

Glad you decided to try it! To delete your test la...

2012-05-07T12:50:18.666-04:00

Glad you decided to try it! To delete your test label, simply enter Screen Design mode by right-clicking anywhere in the Fields Tab. Then, single click your label to select it. Then, simply hit the Delete key. I remember this took me awhile to figure out the first time.

So I went ahead and did as suggested. It was just ...

2012-05-07T12:41:06.226-04:00

So I went ahead and did as suggested. It was just a test so how do I now delete it?
Thanks,
Bill

That's a great tip, DJ; thanks! My Tip was mos...

2012-05-04T14:17:15.462-04:00

That's a great tip, DJ; thanks! My Tip was mostly geared towards getting GM users more familiar with using xBase within Picklists.

seems like a coppy/paste from the help file. where...

2012-05-04T09:55:54.773-04:00

seems like a coppy/paste from the help file. where's the 'tip'?

Although this is a good example it does not provid...

2012-05-04T08:23:09.339-04:00

Although this is a good example it does not provide uniqueness if in an environment that has Remote Users Synchronizing. Personally, I would rather see this done via the Lookup.ini because of the 29 character limitation of the F2 Lookup List expressions. Here is an example from GoldMine Premium - The Definitive Guide:

[AUTOUPDATE]
NewRecord = Key5

[KEY5]
Otherwise = &&UserName+padl(ltrim(str(counter([AcctNo],1))), 8, [0])

Good to know about these two solutions. Not to men...

2012-04-26T14:56:51.976-04:00

Good to know about these two solutions. Not to mention the easy to follow steps. I always thought that a reversal is the only thing I could do. PPI

I have used this concept several times in the past...

2012-04-26T14:47:37.337-04:00

I have used this concept several times in the past. BUT, I didn't know you didn't have to put the formula on the report! I thought it had to be on the report to be evaluated. Nice to know that I don't have to clutter up my report with formulas like this and still have them do what I want them to do. Thanks for sharing!

Worked perfectly for me, thanks

2012-04-26T14:38:32.868-04:00

Worked perfectly for me, thanks

Managing finances is a cumbersome task. Softwares ...

2012-04-23T10:17:36.070-04:00

Managing finances is a cumbersome task. Softwares such as Quickbook help a lot in making life easier in managing finances.

can this be done if your are using unified login s...

2012-04-19T07:26:27.872-04:00

can this be done if your are using unified login so that windows authentication will work too? I tried creating the rule but the hss create login fails.

Thanks for this!

2012-04-12T10:49:31.471-04:00

Thanks for this!

File corruption is a common problem nowadays but i...

2012-03-30T01:18:10.056-04:00

File corruption is a common problem nowadays but if you can't prevent it, you can now fix it using file repair like what I did.

CRM Calculated field from equation http://ahmed--a...

2012-03-28T07:29:55.473-04:00

CRM Calculated field from equation
http://ahmed--abdelghany.blogspot.com/2012/03/crm-javascript-calculated-field-from.html

try True Time Tracker: Time Tracking Software

try TTT:
2012-03-27T02:13:04.754-04:00
try TTT: Time Tracking Software

Thanks for the post! Certainly, almost all aspects...

2012-03-23T12:45:39.511-04:00

Thanks for the post! Certainly, almost all aspects of Crystal can be controlled conditionally. This is something we get into often during our monthly Crystal webinar. To sign up, visit www.marksgroup.net, thanks!

Use of both of mentioned methods will leave either...

2012-03-23T10:38:57.341-04:00

Use of both of mentioned methods will leave either first or last blank page.
User will need to add a condition, this StackOverflow post explains ...
http://stackoverflow.com/questions/1704296/how-can-i-insert-page-breaks-between-groups-in-crystal-reports-with-two-sided-pr

The assumptions make sense. The questions probably...

2012-03-21T02:04:59.146-04:00

The assumptions make sense. The questions probably need more details to have a more substantial answer.

Check out the following posts too, it is having ni...

2012-03-15T08:36:39.166-04:00

Check out the following posts too, it is having nice with good explanation on Database field in crystal report.....

http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Thanks Everyone!!

Marks Group

Thanks Fixed my Issue

Talk about perfect timing with your post! I was st...

I'm sorry to hear of your situation, but glad ...

This was very helpful - but is there a way to make...

I have recently assumed control of finances for an...

oh man...so simple.....:) Thanks Justin, Bill

Glad you decided to try it! To delete your test la...

So I went ahead and did as suggested. It was just ...

That's a great tip, DJ; thanks! My Tip was mos...

seems like a coppy/paste from the help file. where...

Although this is a good example it does not provid...

Good to know about these two solutions. Not to men...

I have used this concept several times in the past...

Worked perfectly for me, thanks

Managing finances is a cumbersome task. Softwares ...

can this be done if your are using unified login s...

Thanks for this!

File corruption is a common problem nowadays but i...

CRM Calculated field from equation http://ahmed--a...

try True Time Tracker: Time Tracking Software

try TTT: 2012-03-27T02:13:04.754-04:00 try TTT: Time Tracking Software

Thanks for the post! Certainly, almost all aspects...

Use of both of mentioned methods will leave either...

The assumptions make sense. The questions probably...

Check out the following posts too, it is having ni...

try TTT:
2012-03-27T02:13:04.754-04:00
try TTT: Time Tracking Software