Sage 100

 View Only
  • 1.  Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-16-2016 11:26
    Sage100 **Premium** version 2016 PU2 approx. 45 users. they are seeing problems with purchase order Receipt of Goods not updating cost tiers or the General Ledger. Also they have seen cost tiers doubled up from ROG. They think this started happening just since we upgraded to 2016 and it also ""seems"" to be just one user. We can't confirm either just yet. but I've asked them to track every time it happens. (they have found about 5 instances, this user updates often! They have paperless office for all registers and for the ROG where cost tiers doubled, we could see in paperless office that his user and another user both printed the same journal register number and both documents showed just his entries. I'm leaning toward an issue where they both update separate batches at the same time. the only other ""odd"" thing I see is that this user always uses a warehouse code of ""XX"" nobody else uses this warehouse. Their administrator is going to give him a new Sage100 user code to see if the problem follows the user. They have called Sage and opened a case but have not gotten anywhere so they called us also. They do have DSD multi-currency


  • 2.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-16-2016 14:07
    Wondering if that warehouse code with a ""blank"" is causing the issue. Especially since they are SQL. If it is just one user, i would have that user try it with a different User ID and Different Workstation; to see if transactions for Whse ""XX_"" causes the same problem.


  • 3.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-16-2016 14:08
    The good news is with SQL you can rename the warehouse to XXX if the blank is the issue...


  • 4.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-17-2016 06:32
    good thought about the blank, I was not aware you could ""renumber"" a warehouse with SQL version


  • 5.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-17-2016 06:37
    update IM_Warehouse set warehousecode = 'XXX' Where warehousecode = 'XX'; update IM_Itemwarehouse set warehousecode = 'XXX' Where warehousecode = 'XX'; etc etc for other tables


  • 6.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-17-2016 06:46
    Ok, that makes sense.


  • 7.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-17-2016 15:40
    2-digit warehouse codes are incredibly buggy. I was going to suggest checking the Paperless utility to make sure locks are turned on for the user, but I bet you've found the issue with the warehouse codes.


  • 8.  RE: Sage100 **Premium** version 2016 PU2 approx. 45 us

    Posted 11-18-2016 07:17
    thanks Kevin! the client has quite using the 2 digit warehouse code and created a new one - I'm hoping that is the issue.