• Limit access to columns on custom Stock item list programmatically

    Hi all, how to Limit access to Columns on custom Stock item list? I only need to show Code, Name, and Reserved Stock (custom column) for specific users. I have try removing the fields from the extended view. But the columns still showing in the…
  • Join tables produce ambiguous error

    Hi all, I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below. StockItems sis = new StockItems(); try { Sage.ObjectStore.Join join = new Sage.ObjectStore.Join(); join.RightTable = "StockItemSupplier"; join.RightTableAlias…
  • Error Sage.Common.ProgrammingByContract.PreconditionException: 'Contract Failure: A referential integrity exception on update has occured. This method should be overriden by the subclass.' when trying to add new financial currency on another compa

    Hi all, Lets say I have 3 companies of the same base currency, Company A, B, and C. When I add new financial currency on Company A, I want to add to Company B and C as well. So I am using the code below, which I refer to this site https://my.sage…
  • How to automatically add customized form to Menu after assign roles?

    Hi all, I am a developer making customized solution for my customer. Usually when I create forms, I will have to assign the roles to the forms, and after that I need to add the forms 1 by 1 to the Menu. If I have 20 new forms, then I will have to do…