News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Sales Journal 4069000 ...

Microsoft Dynamics SL (Archived)

Sales Journal 4069000 not posting

(0) Share

Report

Report

Posted on by Community Member

We recently discovered an open sales journal from November 2016 which has not posted to the customer's account activity in AR. We use OM to process all of our orders.

Does anyone know of a way to find open sales journals? Currently, the only way we have discovered un-posted sales journals is when we receive a payment for an invoice that doesn't exsist within the customers activity. Also, I am having an issue posting this particular sales journal... anyone know why it may not be posting?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mark E 6,439 on at

Like (0)

Report

RE: Sales Journal 4069000 not posting

Look for an AR and IN batches from Sales Journals that have a "V" (Voided) status in your database. You can do this by running Batch Register reports for each module, where the Batch.Crtd_Prog = 40690, and Batch.Status = "V".

If a Sales Journal process gets aborted before it is fully completed, those batches get set with a Voided status. If you locate any, you can update the Batch.Status field to "B" (Balanced) in SQL, then release the batches from the Release Batches screen from each module.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2

Martin Dráb 232,011 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans