Open Forum

Hello,
I have a GL batch that is in master posting that I cannot get rid of.  It says, "no transactions available" and when I try to delete the batch it does nothing.  I looked in sequel to see if the batch was stuck but it doesn't appear to be.  I am not sure what I can do.  Are GL does balance so I believe we do not need this batch.  Can I delete this in sequel?  Has anyone ever had this happen?  In sequel it does have an amount for BCHTOTAL of -111594.74 but I do not see that amount anywhere in our system.  I have attached screen shots.
Thank you,

------------------------------
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
------------------------------

Hello Katie,

If there aren't any rows on GL10000 for that batch, I would feel comfortable deleting the row on SY00500

select * from GL10000 where bachnumb = 'SLSTE00029253'

Chris

------------------------------
Chris Donnelly
Director of Business Applications
Healthmark Industries
------------------------------

Original Message:
Sent: Jan 17, 2023 12:42 PM
From: Katie Pieczynski
Subject: Batch not posting in master post

Hello,
I have a GL batch that is in master posting that I cannot get rid of.  It says, "no transactions available" and when I try to delete the batch it does nothing.  I looked in sequel to see if the batch was stuck but it doesn't appear to be.  I am not sure what I can do.  Are GL does balance so I believe we do not need this batch.  Can I delete this in sequel?  Has anyone ever had this happen?  In sequel it does have an amount for BCHTOTAL of -111594.74 but I do not see that amount anywhere in our system.  I have attached screen shots.
Thank you,

------------------------------
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
------------------------------

HI Chris,
There are not any rows on GL10000 for that batch.  What script would I use to delete that row?  (of course after making a backup)
Thank you

------------------------------
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
------------------------------

Original Message:
Sent: Jan 18, 2023 08:23 AM
From: Chris Donnelly
Subject: Batch not posting in master post

Hello Katie,

If there aren't any rows on GL10000 for that batch, I would feel comfortable deleting the row on SY00500

select * from GL10000 where bachnumb = 'SLSTE00029253'

Chris

------------------------------
Chris Donnelly
Director of Business Applications
Healthmark Industries

Original Message:
Sent: Jan 17, 2023 12:42 PM
From: Katie Pieczynski
Subject: Batch not posting in master post

Hello,
I have a GL batch that is in master posting that I cannot get rid of.  It says, "no transactions available" and when I try to delete the batch it does nothing.  I looked in sequel to see if the batch was stuck but it doesn't appear to be.  I am not sure what I can do.  Are GL does balance so I believe we do not need this batch.  Can I delete this in sequel?  Has anyone ever had this happen?  In sequel it does have an amount for BCHTOTAL of -111594.74 but I do not see that amount anywhere in our system.  I have attached screen shots.
Thank you,

------------------------------
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
------------------------------

Here are a couple of SQL scripts I have used to check GL and batches

USE "company database"
SELECT * FROM GL10000 WHERE BACHNUMB NOT IN (SELECT BACHNUMB FROM SY00500)

SELECT GH1.BACHNUMB, GH1.BCHSOURC, GH1.JRNENTRY, GH1.REFRENCE, GH1.USWHPSTD, GH1.SERIES, GH1.ORTRXSRC
FROM GL10000 GH1 WITH (NOLOCK) INNER JOIN GL10001 GL1 WITH (NOLOCK) ON GH1.JRNENTRY = GL1.JRNENTRY
WHERE GH1.BACHNUMB NOT IN (SELECT BACHNUMB FROM SY00500) AND GH1.BACHNUMB <> ''

------------------------------
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
------------------------------

Original Message:
Sent: Jan 17, 2023 12:42 PM
From: Katie Pieczynski
Subject: Batch not posting in master post

Hello,
I have a GL batch that is in master posting that I cannot get rid of.  It says, "no transactions available" and when I try to delete the batch it does nothing.  I looked in sequel to see if the batch was stuck but it doesn't appear to be.  I am not sure what I can do.  Are GL does balance so I believe we do not need this batch.  Can I delete this in sequel?  Has anyone ever had this happen?  In sequel it does have an amount for BCHTOTAL of -111594.74 but I do not see that amount anywhere in our system.  I have attached screen shots.
Thank you,

------------------------------
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
------------------------------