Page 1 of 1

Invoice Numbers/Dates Out Of Synch

Posted: 26 Mar 2013, 14:50
by andyUKIS
Running Sage Line 50 2011 Version 17.0.15.208 on a 3 user Windows 7 network. Been using with minimal issues since 2005.

Had a data corruption issue in December, which was resolved by rolling back to a clean backup and manually inputting the necessary transactions. Check for errors and take daily backups, no issues since then. Have obviously been keeping a close eye on all invoices/statements to ensure they tie up and have been noticing what now appears to be an ongoing issue:

Customer Invoices Numbers and Dates appear out of synch on Customer Statements.

On one statement from this month I can see invoice from 8/3 appears before the invoice from 7/3 on their statement.
On another customer statement one 6/3 we created 3 seperate invoices/cnotes for that customers, and they appear out of order ie 1033 then 1030 then 1039

Have reindexed and so on and this hasn't corrected, and am not getting any error messages when I check data, has anyone ever seen anything like this before?

Re: Invoice Numbers/Dates Out Of Synch

Posted: 26 Mar 2013, 15:12
by brucedenney
Transactions on the statements and in the account history should appear in "Transaction Number" order.

This is the order in which they are entered into the ledger, not date or invoice number order.

Re: Invoice Numbers/Dates Out Of Synch

Posted: 27 Mar 2013, 10:33
by andyUKIS
thanks bruce, looks like some invoice/cnotes have been updated out of sequence causing the issue, just wanted to check it wasn't a case of more data corruption, thanks a lot for your help :)