Sage 100

 View Only
  • 1.  **Some posted S/O invoices are missing**We have a

    Posted 09-18-2018 11:36
    **Some posted S/O invoices are missing** We have a very intermittent situation where posted S/O invoices are nowhere to be found in Sage 100 after successfully posting the Sales Journal. And what's really interesting is that the respective G/L impact is perfectly fine. Issue started about 6mo ago and has happened about 6 or 7 times thus far. Can't make it happen at will. Seems to happen monthly, but there was one instance where it happened about a week after the previous time. Initially when they first had the issue they were using Vertex to calc sales tax, but then they stopped using Vertex (although it remained installed) and still had the issue. Everything posts fine; no errors or any messages or anything. The invoices are not present in Customer Inquiry > Invoices or in A/R Invoice History. The related sales orders remain open in S/O Entry after posting the invoices. Issue has happened to two different users/workstations who perform invoicing. Waiting for IT to analyze things, e.g. network connectivity, maybe a virus, if running over wireless, etc. Ran S/O, I/M and A/R Rebuilds; no help. They did mention they do some back-dating of invoices but client says that doesn't appear to have a hand in this.


  • 2.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-18-2018 13:51
    Ugh, what version?


  • 3.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-18-2018 17:57
    Does their open invoice report tie to the GL?


  • 4.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-20-2018 05:29
    v2014.5. @WayneSchulz, do you mean the A/R TB? I'm guessing it doesn't tie since we don't see the invoices in A/R but the G/L gets impacted correctly.


  • 5.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-20-2018 07:02
    I'd check that - one of the issues might be that maybe the invoice is there but under a different customer number? First, verify that the invoice is truly disappearing by checking that the AR TB or Open Invoice reports do not tie to the GL.


  • 6.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-20-2018 08:31
    Good point, @WayneSchulz, but we're not seeing the invoice #'s in invoice history.


  • 7.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-20-2018 08:53
    The fact that you get through the register update seems to indicate sage is updating tables **somewhere**. If you browse to the MAS90\MAS_xxx\SOXXX folder is there another SOxxx folder inside of it? Maybe Sage is finding those tables and updating those, or maybe another copy of the MAS_xxx folder; or is there a copy of the SOxxx folder within the MAS_xxx folder?


  • 8.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-20-2018 09:51
    Any chance you have an undetected 3rd party enhancement in the mix?


  • 9.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-26-2018 13:19
    I would agree, @DavidOverholt, although that wouldn't necessarily quite explain why it happens so intermittently - unless you can think of a reason. I haven't been able to get back onto their server to take a look at what you suggested. @WayneSchulz, ""undetected""? In addition to Vertex, they also have the following: - DSD's SO-1032 Multiple Customer Deposits on a Sales Order - DSD custom programming to W/O and I/M - SWK's Timekeeper


  • 10.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-26-2018 13:54
    Brett - Sending you a chat.


  • 11.  RE: **Some posted S/O invoices are missing**We have a

    Posted 09-27-2018 07:41
    Just realized this client also has In-Synch.