Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *
Welcome, Guest
Username: Password: Remember me
Questions and answers test do it together
  • Page:
  • 1
  • 2

TOPIC:

Turbocash: Year-end rollover error: violation of P 8 years 6 months ago #1153

Thanks for the help. I got it sorted out.
Have a great day

Nick

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 8 years 6 months ago #1152

Hi Nick

Under Setup/Extra/Activate_Plugins
scroll down to "Tools"-section (bottom)
select "HandyTools" and click on 'Activate plugin'

that shouyld not make it available under "Setup/Extra/Plugins/Tools"

r
The following user(s) said Thank You: Nick le Rock

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 8 years 6 months ago #1151

Sorry to bother again.

I cannot find Handy Tools in my programme. Is this a plugin I should Download?

Cheers
Nick

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 8 years 6 months ago #1150

Thanks for the reply, Pieter.

I can't seem to find the handy tools in my programme. Is this a plugin that I need to install?

Kind Regards
Nick

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 8 years 6 months ago #1142

The generator is out of sync.
The new id is not unique so its refusing to add it to the tabel.
Set the generator to a higher number.
Or use the handytools to reset set the generator using het reset generators button.
The following user(s) said Thank You: Nick le Rock

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 8 years 6 months ago #1141

Good day,

Sorry to wake an old thread. I am experiencing a similair problem when capturing payments for creditors in TurboCASH 5. The error reads; "Violation of PRIMARY or UNIQUE KEY constraint "INTEG_76" on table "OILINKS"

I added a screenshot. I have gone through the above solution, but I think my problem is a bit different. Any help would be appreciated.

Cheers
Nick

Attachments:

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #276

MANY Thanks, Pieter
I'll post this solution as an option on the other boards


Now just to get the data from the temporary set of books (new year, started clean) into the restored data to have all history in one place.

Thanks again

r

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #275

Yup should all work now.

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #274

OK
DELETE FROM TOTALS;
did the trick - I confirmed via FlameRobin there are no lines/data in the TOTALS table (note to anybody else: do NOT DROP the table)

Open in TC5 and the YearEnd process completed succesfully

Opened in FR and Totals-table only has one line of data

Opened in TC5 again and went to Setup/Tools/Data_Integrity_Check and select 'Recalc Totals' (bottom left)

Opened in FR and checked: 3169 rows of date (before I started it had 18 911 lines).

I assume current (new) year' totals will only be added once we start adding new transactions?

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #273

delete * from totals ?

Use 127.0.0.1 for server. that should work.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2