Moderator: Phil Barton
2) I populated the pf.order table as well as the pf.orderinfo table and although i can see the orders in the select app but when I try to access them it says that I do not have permissions to access them. I used the same owning profile id as the sample orders that I entered into the db via the select app so what am I missing?
3) Cannot find any master tables for buyers, sellers, brokers, lenders etc. Where do these go? The pfm.buyers has a mix of buyers in different formats. Is this the only place to place them?
4) Where does settlement type come from?
Also, Settlement is an enum in SoftPro.Accounting.Client.Orders: SettlementType
What are you trying to do that cannot be done by opening the orders?
You should contact a SoftPro Customer Support Representative to discuss the option to migrate your historical data to Select.
private void CreateOrder()
using (SelectServer ss = new SelectServer(new Uri("http://localhost:8080")))
if (!ss.TryAuthenticate(out reason))
Results.Text = reason;
Results.Text = "Success";
OrderCreationSpec spec = new OrderCreationSpec();
spec.BaseNumber = "Test-007";
IOrderStore os = ss.GetService<IOrderStore>(); //this line of code generates the exception
IOrder order = os.NewOrder(spec);
dynamic o = (dynamic)order;
o.Project = "RAL Test";
Please send me the complete call stack, the InnerException information, and the version of Select are you using.
Also, while the user profile will set the default Settlement type, you should generally specify it in the OrderCreationSpec object if you know ahead of time. For instance:
Code: Select all
OrderCreationSpec spec = new OrderCreationSpec(); spec.SettlementType = SettlementType.CDF; spec.BaseNumber = "Test-007";