Sage 100

Customer is getting Database Connector Error when running the GL Detail Report. I know this is a bad date issue and I have managed to find the bad records in the GL_DetailPosting file. The problem is that there are about 500 such records, all related to an Invoice batch they posted in AP. The question I have is, can I somehow export and then import back the bad records or do I have to fix one at a time via DFDM?

------------------------------
Kenny Daniel
Technoclarity, Inc.
------------------------------

I think you are stuck with manual corrections.  The posting date is part of the table's primary key so if you import values with a different date it would add instead of update.


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Thanks Kevin, what if I delete the records and then re-import?. Deleting in DFDM is a lot easier than changing one at a time.

------------------------------
Kenny Daniel
Technoclarity, Inc.
------------------------------

Original Message:
Sent: 05-12-2020 13:09
From: Kevin Moyes
Subject: DataBase Connector Error

I think you are stuck with manual corrections.  The posting date is part of the table's primary key so if you import values with a different date it would add instead of update.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

The table is not available for import unless you edit the DD... even then there will be fields (DateCreated, DateUpdated, UserCreatedKey...) that will not match the original postings (which an auditor would not like).

Maybe someone else has a better idea?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-12-2020 13:13
From: Kenny Daniel
Subject: DataBase Connector Error

Thanks Kevin, what if I delete the records and then re-import?. Deleting in DFDM is a lot easier than changing one at a time.

------------------------------
Kenny Daniel
Technoclarity, Inc.
------------------------------


Original Message:
Sent: 05-12-2020 13:09
From: Kevin Moyes
Subject: DataBase Connector Error

I think you are stuck with manual corrections.  The posting date is part of the table's primary key so if you import values with a different date it would add instead of update.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON

Kevin, I think you can import transactions via G/L Exchange but I think you are right about the Audit trail. I guess I better get started, it's gonna be a loooong day. Thank you.

------------------------------
Kenny Daniel
Technoclarity, Inc.
------------------------------

Original Message:
Sent: 05-12-2020 14:16
From: Kevin Moyes
Subject: DataBase Connector Error

The table is not available for import unless you edit the DD... even then there will be fields (DateCreated, DateUpdated, UserCreatedKey...) that will not match the original postings (which an auditor would not like).

Maybe someone else has a better idea?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 05-12-2020 13:13
From: Kenny Daniel
Subject: DataBase Connector Error

Thanks Kevin, what if I delete the records and then re-import?. Deleting in DFDM is a lot easier than changing one at a time.

------------------------------
Kenny Daniel
Technoclarity, Inc.


Original Message:
Sent: 05-12-2020 13:09
From: Kevin Moyes
Subject: DataBase Connector Error

I think you are stuck with manual corrections.  The posting date is part of the table's primary key so if you import values with a different date it would add instead of update.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON

Delete the records then reimport via JE Entry.  Easy to do.  Use the same source #'s.  Might have to open the GL period to accomodate the VI import
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 05-12-2020 14:45
From: Kenny Daniel
Subject: DataBase Connector Error

Kevin, I think you can import transactions via G/L Exchange but I think you are right about the Audit trail. I guess I better get started, it's gonna be a loooong day. Thank you.

------------------------------
Kenny Daniel
Technoclarity, Inc.
------------------------------


Original Message:
Sent: 05-12-2020 14:16
From: Kevin Moyes
Subject: DataBase Connector Error

The table is not available for import unless you edit the DD... even then there will be fields (DateCreated, DateUpdated, UserCreatedKey...) that will not match the original postings (which an auditor would not like).

Maybe someone else has a better idea?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 05-12-2020 13:13
From: Kenny Daniel
Subject: DataBase Connector Error

Thanks Kevin, what if I delete the records and then re-import?. Deleting in DFDM is a lot easier than changing one at a time.

------------------------------
Kenny Daniel
Technoclarity, Inc.


Original Message:
Sent: 05-12-2020 13:09
From: Kevin Moyes
Subject: DataBase Connector Error

I think you are stuck with manual corrections.  The posting date is part of the table's primary key so if you import values with a different date it would add instead of update.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON