Invoice Data Entry Line Items Disappearing

We are on Sage 100 (Version 6.00.3.0).

We have noticed, only in the last week, that we have invoices dropping line items when we switch from Lines tab to Totals tab and go to print. I am not 100% sure of this, but it seems it is just the last item entered into Invoice Data Entry. When this started, it was just maybe 1 invoice of the 200 we do a day, but now it is at least 5 a day that drops the item. We have about 15 employees entering invoices and have done our best to catch these when they print or before, but know we cant get 100% of them. 

It is not just that the item does not print either. If you go back into that invoice, the line item is gone all together, not just from the printed copy, but within sage as well. 

I did create a test batch and try every combination of entering I could, but could not duplicate the issue, so I have no idea where to start here.

  • 0

    I have a similar problem with a client.  Cannot reproduce it.  We have tried recording the user's session and as luck would have it the problem doesn't occur during our recording sessions!  They now export the sales orders lines to Excel.  After the order is picked they make sure the line count is the same.  If not, the Excel file is used to put the line back on the order.  It always seems to be the first line of the order that is missing but occasionally it is more.

  • 0 in reply to mvz

    Ours seems to be the last item entered on the invoice. We have locations in Oregon and Washington, and it appears that only our Washington invoices seem to drop items, so maybe it has something to do with the Taxable items?

  • 0

    Any there third-party integrations/enhancements in use? 

    Are there extended descriptions on the item that is disappearing? ( see ) (Applies to an older version but worth considering)

    There is also a recent report of odd line sorting but this appears to apply to invoices that are created from orders and there is no mention of disappearing lines ( see )

  • 0 in reply to Wayne Schulz

    We do not have any third party integrations we are using. And we do not have extended descriptions, just extended Customer PO line. 

    We have had a small amount of the Odd Line Sorting happening, but not very much, maybe once or twice a week, over 1200 invoices. 

  • 0

    I saw this with a client that was using Avatax a couple of years ago and I believe it was traced to a patch for Avatax,  however it looks like you are on the current version.

    Same client is currently on 2016 and I recently had some people reporting dropped lines exactly as you are describing.   And of course we can't duplicate it on demand either.