No journal entry created for transaction

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date No journal entry created for transaction Rick 10-01-2007  RE: No journal entry created for transaction Matt Hurst 10-09-2007  RE: No journal entry created for transaction MB 11-20-2007
Posted by Rick on October 1, 2007, 6:44 pm Please log in for more thread options In some cases where the CC or check transaction fails, a journal entry is not created for the transaction. All other aspects of the transaction are completed successfully. An entry exists in the transaction table, the transaction entry table, purchase history for the customer exists related to the transaction, on hand inventory is decremented, etc., just no journal entry created. Has anyone else seen this? How are you cleaning this up? Is there a way to re-render the receipt for the transaction? Please advise. Thanks! Posted by Matt Hurst on October 9, 2007, 3:30 pm Please log in for more thread options I have seen this since updating to RMS 2.0. The short term answer is to reverse the processes that already happened and do the whole transaction again. This becomes difficult, because there are so many things that get updated during a transaction, like charging the credit card, and updating tables: Batch, Transaction, TransactionEntry, Item (quantity), TenderEntry, TenderTotals, TaxEntry, TaxTotals, DailySales, and Journal. Our current solution is to ditch SQL 2005 and go back to MSDE. This is a painful process as well, but seems to fix this problem. "Rick" wrote: > In some cases where the CC or check transaction fails, a journal entry is not > created for the transaction. All other aspects of the transaction are > completed successfully. > > An entry exists in the transaction table, the transaction entry table, > purchase history for the customer exists related to the transaction, on hand > inventory is decremented, etc., just no journal entry created. > > Has anyone else seen this? How are you cleaning this up? Is there a way to > re-render the receipt for the transaction? > > Please advise. > > Thanks! Posted by MB on November 20, 2007, 7:49 pm Please log in for more thread options I'm having the same issue. I verified that the transaction was properly captured via EDC, inventory decremented, etc... The funny thing is a few days later, the transaction would show up in the journal. This happens about only twice in the last month, but it's very annoying. Anyone have any ideas? "Rick" wrote: > In some cases where the CC or check transaction fails, a journal entry is not > created for the transaction. All other aspects of the transaction are > completed successfully. > > An entry exists in the transaction table, the transaction entry table, > purchase history for the customer exists related to the transaction, on hand > inventory is decremented, etc., just no journal entry created. > > Has anyone else seen this? How are you cleaning this up? Is there a way to > re-render the receipt for the transaction? > > Please advise. > > Thanks! Similar Threads Posted How do receipts get re-created in the Journal? December 28, 2005, 12:09 pm Journal Entry for Purchase Receipts in MRMS January 15, 2007, 2:38 pm Layway and Work Orders are cancelled without journal entry April 20, 2009, 2:31 pm How to remove an transaction entry programmably August 19, 2005, 7:34 pm price level in transaction entry March 29, 2006, 11:44 am Trap the delete transaction entry event August 3, 2009, 7:54 am Entry of stand-alone Credit card transaction in POS System May 29, 2007, 9:59 pm Reciept Missing - no Journal for the Transaction Either September 21, 2007, 5:04 pm Receipt intermittently not printing - transaction not in journal September 20, 2007, 11:32 am serial number can not be created in POS June 29, 2005, 12:51 pm