Welcome to the Sage 200 Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Hi all,
I wanted to add a bespoke columns from completely different tables to this Stock list. I think the fastest way to do it is to have a custom stock list. However, my customer also need the same right click function that able to have options as…
Hi all,
I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty
select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo,
si.Code as ItemCode, si.[Name] as ItemName,
pg.Code as ProductGroupCode,
six.TriggerQty…
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…
Hi all,
I am looping the POPStandardItemLine or an Order using foreach loop. The item lines in the order consists of standard order line and a charge line. While looping, I encounter an error.
this is because 1 item in the POPStandardItemLine is…
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…
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…
Hi all,
On the form Currencies and Exchange Rate, I need to detect if user have added new currency on the currenciesGrid and prompt user and at the moment the Save button is clicked. But I am not getting much information about it.
OnClick Save button…