I ran the daily transaction register for yesterday's updated invoice batch in the Sales Order module and got the transactions from a batch from 10/25/06 along with the ones for yesterday. A call to Sage got me nowhere except on hold for an hour. Are there any solutions besides updating the register and reversing the GL entries manually?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Daily Transaction Register from Sales Order Module
- Thread starter IreneM
- Start date
First what version are you on? If the entries show up on the DTR this means that they have already been posted to various other files and are in the GL works files. Basically it is already posted and there is nothing you can do. Complete the posting and then research the invoices that were posted. Look at the customer's history and inventory history. Was inventory relieved? Do the invoices show up on the customers? If so you would need to do a credit to the invoices which would clear them out and put back the inventory.
This happens sometimes when using batch entry, here is how. A year ago you used batch 123 but when updating the batch you checked the box Update all batches. Batch 123 or SO500123 was left behind. Now a year later you reused batch number 123 this caused the system to pickup the old batch. The result is invoices with no lines because the header comes from SO500123 but the detail from SO6.
You need to check the daily sales journal to see what invoices were from the 2006 batch.
This happens sometimes when using batch entry, here is how. A year ago you used batch 123 but when updating the batch you checked the box Update all batches. Batch 123 or SO500123 was left behind. Now a year later you reused batch number 123 this caused the system to pickup the old batch. The result is invoices with no lines because the header comes from SO500123 but the detail from SO6.
You need to check the daily sales journal to see what invoices were from the 2006 batch.
- Thread starter
- #3
Thanks for the reply. I really appreciate the help. I am on version 4.10.1. That is what is wierd about this. The sales journal only shows the invoices from yesterday and there are no outstanding batches. Those invoices are posted and inventory relieved but nothing from the 10/25/06 batch hit either place. The only place anything from the 10/25/06 batch shows up is on the DTR.
I have to wonder if it is picking up old data because the source journal and number are the same from last year. I would print out everything and finish the update and then research to see if the entries were really posted. I suspect they might not be.
- Status
Similar threads
- Locked
- Question