Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Is there any way to know if an entry is posted as auto reversing entry when looking at GLTRAN data?
I don't think you can tell by looking solely at GLTRAN. In looking at the BATCH table, if GL is set to create the reversing entry at period closing, then the AutoRev field of the batch will be set to 1 until the closing process creates the reversing entry. At that point, the AutoRev field will be reset to 0, the AutoRevCopy field of the newly created batch will be set to 1, and the batch number of the original batch will be added to the OrigBatNbr field of the new BATCH record.
If GL is set to create reversing entry on release of the originating batch, then the new (reversing) BATCH record will have AutoRevCopy set to 1 and the originating batch number in the OrigBatNbr field.
Thank you for your reply. How can I see the BATCH table? The only column related to batch I can see on the data spreadsheet is BATNBR, which shows the JE number.
My assumption from your original post was that you were using SQL to examine GLTRAN. I'm not 100% sure what you mean by data spreadsheet.
I have been given a spreadsheet which is created from Microsoft Dynamics SL (Solomon) GLTRAN. Below is the columns that the spreadsheet includes. As I didn't create this, I am not sure if I can add any more column to this spreadsheet that shows AutoRev status.
Acct Descr Sub TCO Loc Dep TranDesc User1 BatNbr CuryDrAmt CuryCrAmt Net Amount FiscYr Module PerEnt PerPost Posted ProjectID RefNbr TranType Crtd_DateTime LUpd_User Crtd_User ProjectID2 User2 CpnyID
I don't know of any way to do it other than adding the BATCH table to the query used in the spreadsheet (using either BatNbr or OrigBatNbr dependent on GL Setup and Closing statuses) and bringing in both AutoRev and AutoRevChk.
I will try it. Thank you so much for the help!
The GLTRAN feild is called AutoRev
Business Applications communities