web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Posting issue

(0) ShareShare
ReportReport
Posted on by
Hi 
 
when i post the SOP invoice some of the transaction got deleted and posted, batch total is not matching with posted total. How to trace the deleted transaction 
 
Regards
Srinivasan
Categories:
I have the same question (0)
  • BJ-09051414-0 Profile Picture
    334 on at
    Posting issue
    Hello,
     
    With the description provided, it sounds like you might have had a Posting Interruption. I assume this because you state that the Batch was posted, some transactions got deleted but the batch still exists but has the incorrect total.
     
    My guess why some are missing from the batch might have been posted and removed from the batch and why the transaction count and total is no longer correct in the batch.
     
    To trace the transactions, if you printed the Edit List of the batch before posting, you can use this to get the Document Numbers of the SOP Invoices and use the Documents window to see if they exist by using a restriction of the Document Number.
     
    Another option is to Item Transaction Inquiry in Inventory for the item and filter by date or document number to see if you can find the Transaction.
     
    You could look at using the Sales Transaction Smartlist and add the Batch ID column and user a restriction of the Batch ID to see if the Smartlist will show you the missing transactions.
     
    If you have access to SQL, you can query the tables for the document number and see if they exist.
     
    SOP10100 - Sales Transaction Work.
    SOP10200 - Sales Transaction Amounts Work.
    SOP30200 - Sales Transaction History.
     
    I hope this helps!
     
    Brandon - Enavate

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 694 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 635 Super User 2025 Season 2

#3
CU05031448-0 Profile Picture

CU05031448-0 576

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans