Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 119
  • Last Modified:

GP 2010 User deleted a recurring batch

User deleted a recurring batch with 100 rows by mistake.  Is there a way to retrieve this batch.  We have a test database that has this batch and 95% of the entries in that database.  Is it possible to copy from that database to our production database so that user will not have to re-type all of the entries
0
pstre
Asked:
pstre
  • 2
  • 2
2 Solutions
 
Victoria YudinCommented:
Hi pstre,

I believe you should be able to copy from the test company back to live using the code below, assuming the following:
- the batch is still there
- there are no AA entries associated with this journal entry
- there are no MDA entries associated with this journal entry

There are notes inside the code, but just to make sure you look for them:
- replace LIVE with your live database name
- replace TEST with your test database name
- replace YourJE with Journal Entry #

insert LIVE..GL10000 --replace LIVE with your live company database
select
BACHNUMB, BCHSOURC, JRNENTRY, RCTRXSEQ, SOURCDOC, REFRENCE, TRXDATE, RVRSNGDT,
RCRNGTRX, BALFRCLC, PSTGSTUS, LASTUSER, LSTDTEDT, USWHPSTD, TRXTYPE, SQNCLINE,
GLHDRMSG, GLHDRMS2, TRXSORCE, RVTRXSRC, SERIES, ORPSTDDT, ORTRXSRC, OrigDTASeries,
DTAControlNum, DTATRXType, DTA_Index, CURNCYID, CURRNIDX, RATETPID, EXGTBLID,
XCHGRATE, EXCHDATE, TIME1, RTCLCMTD, NOTEINDX, GLHDRVAL, PERIODID, OPENYEAR,
CLOSEDYR, HISTRX, REVPRDID, REVYEAR, REVCLYR, REVHIST, ERRSTATE, ICTRX,
ORCOMID, ORIGINJE, ICDISTS, PRNTSTUS, DENXRATE, MCTRXSTT, DOCDATE, Tax_Date,
VOIDED, Original_JE, Original_JE_Year, Original_JE_Seq_Num, Correcting_Trx_Type,
Ledger_ID, Adjustment_Transaction
from TEST..GL10000 --replace TEST with your test company database
where JRNENTRY = YourJE -- replace YourJE with Journal Entry #

go

insert LIVE..GL10001 --replace LIVE with your live company database
select 
BACHNUMB, JRNENTRY, SQNCLINE, ACTINDX, XCHGRATE, DSCRIPTN, GLLINMSG, GLLINMS2,
CURRNIDX, GLLINVAL, ACCTTYPE, FXDORVAR, BALFRCLC, PSTNGTYP, DECPLACS, ORCTRNUM,
ORDOCNUM, ORMSTRID, ORMSTRNM, ORTRXTYP, OrigSeqNum, ORTRXDESC, DTA_GL_Status,
INTERID, RATETPID, EXGTBLID, EXCHDATE, TIME1, RTCLCMTD, CRDTAMNT, DEBITAMT,
ORCRDAMT, ORDBTAMT, DENXRATE, MCTRXSTT, LNESTAT, CorrespondingUnit
from TEST..GL10001 --replace TEST with your test company database
where JRNENTRY = YourJE -- replace YourJE with Journal Entry #

Open in new window

0
 
pstreAuthor Commented:
It is not a GL transaction.  These were payroll transactions inside of a payroll batch.
0
 
Victoria YudinCommented:
Sorry about that, I am not sure why I assumed GL. I don't have a lot of experience with Payroll transactions, so I would hesitate to offer the same type of script for it. Perhaps someone else will chime in and be able to help you with that.
0
 
pstreAuthor Commented:
I didn't select my own comment -- I accepted Victoria's.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now