ForumsMessage Boards
Reversing Journal Entry Excel Integration
Jessica Hutcherson, modified 3 Years ago.
Reversing Journal Entry Excel Integration
Post Date: 2/19/21 (Bronze, 2 Posts) Recent PostsHow do I set the journal entry excel integation for a reversing journal entry?
Houcine Hanzouli, modified 5 Years ago.
Re: Reversing Journal Entry Excel Integration
Post Date: 2/22/21 (Bronze, 6 Posts) Recent PostsHello,
You have o add these colums to yur JE excel integration :
PostingIsAutoReversal (value = 1 )
PostingAutoReversalDate (Value = First day of next period)
Here are columns used for that (I could not upload file) :
| Record ID | tPosting.Posting_ID |
| Voucher | tPosting.PostingVoucher |
| Posting Date | tPosting.PostingDate |
| Sys Date | tPosting.PostingSystemDate |
| Value Date | tPosting.PostingValueDate |
| Description | tPosting.PostingText |
| GL Period | tPosting.PostingPeriod |
| Year | tPosting.PostingYear |
| Automatic Reversal | tPosting.PostingIsAutoReversal |
| Reversal Posting Date | tPosting.PostingAutoReversalDate |
| Correction | tPosting.PostingIsCorrection |
| Daybook Code | tPosting.tcJournalCode |
| Trans Curr | tPostingLine.tcCurrencyCode |
| Record ID | tPostingLine.PostingLine_ID |
| Seq | tPostingLine.PostingLineSequence |
| GL Account | tPostingLine.tcGLCode |
| Sub-Account Code | tPostingLine.tcDivisionCode |
| Cost Center | tPostingLine.tcCostCentreCode |
| Project Code | tPostingLine.tcProjectCode |
| Description | tPostingLine.PostingLineText |
| TC Debit | tPostingLine.PostingLineDebitTC |
| TC Credit | tPostingLine.PostingLineCreditTC |
| Intercompany Code | tPostingLine.tcIntercoBusinessRelationCode |
| BC Debit | tPostingLine.PostingLineDebitLC |
| BC Credit | tPostingLine.PostingLineCreditLC |
| Exchange Rate | tPostingLine.PostingLineExchangeRate |
| Scale Factor | tPostingLine.PostingLineRateScale |
| Base Curr | tPostingLine.tlPostingLineIsLocalCurrency |
| Allocation | tPostingLine.tcAllocationType |
| Allocation Key | tPostingLine.tcAllocationKey |
| Open Item Posting | tPostingLine.tcAllocationPostingLine |
| Record ID | tPostingSaf.PostingSaf_ID |
| Parent Type | tPostingSaf.PostingSafParentType |
| Seq | tPostingSaf.PostingSafInputSequence |
| SAF Code | tPostingSaf.tcSafCode |
| SAF Concept Code | tPostingSaf.tcSafConceptCode |
| Structure | tPostingSaf.tcSafStructureCode |
Regards.
Jessica Hutcherson, modified 5 Years ago.
Re: Reversing Journal Entry Excel Integration
Post Date: 2/22/21 (Bronze, 2 Posts) Recent PostsThank you so much! I will give this a try! Have a great day!
Message place holder