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
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
Was this reply helpful?YesNo
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.