Details of 2 problems discovered with QIW. My client made an error on one of her invoices and went in and changed certain amounts in a line item that does not print on the invoice. As she is from the old school she still does a manual sales book, and noticed that her QIW batch total and her Sales Book Batch total did not match. They were exactly out by the changes she had made previously. After trying numerous things to get the QIW Batch total to match, she decided to Delete/Cancel the offending invoice and enter it again. Still did not balance. If I reactivate this invoice, delete all line items, Totals show nil, but on the main screen still shows a total of the amount our batch is out. (Does this make sense ... it does to me). Hence, I decided to export the batch, and re-import into another batch. This created PROBLEM 2, which I only discovered later. Very interesting. Invoices in the batch dated 23/8/2000 get pulled into Excel as 2/10/2001. This went unnoticed and obviously caused a bit of havoc in AR. I have simulated the problem in my office and it does the same thing. Invoices dated early August go through to Excel fine, but only those on or around 23 August 2000 come through with funny dates.

QIW ver6.5 (990215). Mine was on a standalone notebook, the clients was on a Peer to Peer Windows 98 network.

Any help will be appreciated.

PS : This month similar problem. Made a R300 change. Showed a R300 difference on batch total even though the invoice was cancelled. Reactivate the invoice, change the amount by R10, Cancel the invoice, and the batch total is now R290 out of balance. How can a cancelled invoice effect the batch total ? If you print the batch listing the total is correct .. different from the Batch Total on Batch Summary Screen.

Wayne