Client is to flour mill and they have a customised module named as Commodity purchase where they have something called “tickets” which is posted and settled and once settled system will automatically create purchase order and vendor invoice and related journal entries as configured in inventory posting profile. Once tickets are settled, the ticket is closed for any further transactions.
For one of the tickets, system is posting recurring entries on random days in a month and we are not able to make out the source of those journal entries.
Can anyone advise how to find the source of those entries. Whether it’s a batch job process or part of month end /inventory closing transactions?
you need to find the voucher for the posting and hopefully you can identify a source based on the number sequence. Furthermore I would review all batches, e.g. Inventory counting journals and other can be automated and periodically executed. Having an detailled batch plan with Batch number, description, recurrance, expected run time, ... is also a good idea to have control over all batches to avoid undesired executions. We recommend to organize batches e.g. in this way Batch Jobs; Take control of the executions | Kurt Hatlevik – Dynamics 365 Blog
Maybe you can set up a custom field to record the source of the journal entry. Or you can do database field monitoring, refer to this blog: dynamics-tips.com. The database logging feature allows you to determine which table, and fields should be monitored and the events that should trigger the change tracking. This article will show you how to set up database logging and then give you a click by click walkthrough and demonstrate the functionality.
Best regards,
Kevin
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.