• 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…
  • How to get the users under specific company?

    Hi all, I have the following code where I list all the companies that have the same base currency as the current company. public List<CompanySelection> GetTheCompaniesSameBase() { List<CompanySelection> companies = new List<CompanySelection>();…
  • 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…