Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Linda Chau]

My accounting team is questioning mysterious journal entries made.  No one made them and they can not drill into it to see any details.  Can anyone tell us how this is happening automatically?  Why ? Can we stop it?
Thank you

——————————
Linda Chau
Paper Mart
——————————

[Steve Erbach]

,

The first thing I’d look for would be who posted the journal entry in the AccountTransactions View?, or use the Account Transactions SmartList. With the SmartList, add the “User Who Posted” column, and Search by the Journal Entry number.

Do the transactions themselves give you a clue?

Our GP installation is integrated with a number of external systems. Do you have any other software in your company that stuffs transactions into the G/L?

Regards,

——————————
“Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company – Appleton, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 (16.00.0439) / MR 2012 CU15
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach
——————————
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
——————————
——————————————-

[David Flowers]

You could look at MDGP>Tools>Setup>Posting>Source Document setup and at least find out where the prefix is coming from.  The Audit Trail Codes under Posting might also be useful.  I don’t have “IVAP” as one of our document prefixes.

——————————
David Flowers
System Admin -GP and Salesforce Support
RMG Enterprise Solutions
Addison TX
——————————
——————————————-

[Jen Kuntz]

Hi Linda,

I see some other useful responses. Some other things I would check or have an IT person check if you aren’t IT yourself…

One question I would have is where are you seeing “ivap”? Is it in the Reference field (i.e. JE description) or is that the Source Document or is it elsewhere? That may help, it may be irrelevant, depending on your answer.

1. Look at what third party products you have. It’s possible that something is creating things that you may need to follow up on with those vendors.

2. Do you have any customizations?

3. Integrations – Steve mentioned this. 

4. If you can’t find who posted, look in GL20000 and it may have some more info about source, or trxs on that same date/time/sequence of JE#’s that may clue you in to what is happening.

A client of mine uses Wennsoft (Key2Act) Job Cost and it creates seemingly random journal entries for cost variances. Those have odd descriptions, like SOPRCT###### so they look completely odd to the users. They are legit but something like that sounds somewhat like what you are seeing. In this customer’s case, it’s a journal entry with no details but the “RCT######” is a reference to a purchasing RCT number that caused the cost variance and therefore that is where they had to start to look to find what caused the JE to occur. 

That’s just an example of what you might find, even if the JE itself has no info to drill in on, it hopefully is created sequentially (more or less) at the same time as posting something else that actually triggers it.

Hope that helps
Jen

——————————
Jen Kuntz, CPA, CGA
Microsoft MVP, Business Solutions
Kuntz Consulting Inc.
Cambridge, ON, Canada
——————————
——————————————-

[Mahmood M. AlSaadi]

?Hello Linda
This is definitely not a standard source document, as illustrated above, this could be added either by third applications or manually.

Would you please share the details which you find under “Account Transaction” smartlist for this specific journal ? This will definitely give a broader perspective especially when looking on the other key fields

If you’ve got technical skills, then please share what’s available in the GL20000 table for this specific journal

Your feedback is highly appreciated
Best Regards,

——————————
Mahmood M. AlSaadi – MVP
Principal Dynamics ERP Consultant
SIROCo LLC – (844) 708-0008
McKinney TX
m.saadi@sirocollc.com
http://www.sirocotech.com
——————————
——————————————-

[Carol Livingston]

Hi Linda,

Is the IVAP included in the description on the JE as the document type?  

Have you implemented any new third-party software recently?   

I know that sometimes IV transactions are coming from inventory like an adjustment or variance transactions.  

Other suggestions that others have provided like creating a Smartlist to locate the user that created the transaction.  Or looking at any integrations that are running.  

Good luck on your hunt!

——————————
Carol Livingston
GP Practice Director
InterDynBMI
Minneapolis, MN
——————————
——————————————-