• "LNGDES_0" of table ATABDIV invalid column name in SQL query

    Hello, I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…
  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…
  • Views wont accept like statement

    Why cant sage handle LIKE in the views? Has anybody found a way around this?
  • SQL cluster, availability group setup for x3 to connect to listener

    We have setup sql 2016 on v11 p15 with the high availability option which in the end uses a "listener" which is a virtual server with static ip to connect to. if the primary node goes down the secondary becomes primary. So the current std setup has X3…
  • Purchase Invoice billable quantity should be "A" status

    Hello Everyone, I want to create a purchase invoice for the receipts which are having only "A" status. For Q and R status receipts system should not allow us to create an Invoice. Just for your reference, I had done the following setups:- Parameter…
  • PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

    Hello All, Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table. I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…