Hi all,
is there any functions to do the following:
1. find the item
2. find the all transactions that uses this item
3. remove the items and transactions.
4. in the meantime, take care of the data to avoid data instability.
thank you.
Hi Guys
The Sales Ledger has now been closed for December, but I am still not able to print the invoice in Sage.
How do I get the invoice into Sage Spooler for printing.
I don't want to post but just print.
Hi all,
I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…
Hi all,
on customization on the Revalue foreign supplier account screen, where the Period Exchange Rate field is enabled. When user click OK button, I need the report generated to use the value from the edited Period Exchange Rate field.
I have…
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,
My users, lets say user A,B, and C have their own preferences on the menu sorting/arrangement/naming. Whenever customization update installed, the menu arrangement will reset according to Sage 200 default sorting/arrangement/naming.
Each user…
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>();…
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…
Before we start. It is important to make a backup of all files we are editing. As well as having a basic understanding of HTML and CSS coding.
Text editor fonts
You need to edit the following file found - ?:\Program Files\Sage CRM\CRM\WWWRoot\ckeditor…
Hi folks
I'd like to know if there's an easy way to show custom messages using the standard flyout banner (e.g. shown if record has been updated)?
I know I can use Infbox to achieve a similar result, but the user should not be forced to click a…
Hello,
Is there any way on CRM to hide the 'New Company' and 'New Person' buttons on the right side of entering a new Lead?
Highlighted in the image below:
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,
Lets say I have a user that only have access to specific page. As you can see below, this user does not have access to Fast Duty feature. This user have access to Fast Delivery feature.
Fast duty is about create, read, update, delete on…
" An error has occurred in a CRM .net customization. Please contact your vendor to resolve." when i try enter a quote from Sage CRM. I have tried all i know but i can't fix it. Anyone can help? It just keeps loading but displays no results.
Hi all,
on SalesReceiptForm, I added a new custom field "BankDate" and I assume I shall add the field to SLPostedCustomerTran table as extension (SLPostedCustomerTranX: column BankDate; data type datetime).
Then I see that this form is using Sage…
Hi all,
How to check the customer whether it is already exceeded credit limit or not, programmatically? Because I do not find any standard function to check it. I only find the exceptions, but I do not know how to trigger the exception during customer…
Hi all, I have a customize form that have been working for ages. On recent changes, it got error on customer side, while on my local PC the form is still working. Looking at the error, it is related to Sage library. The only difference from customer server…
Hi All,
I have a StockItemLookup and add it to my custom screen.I know how to embed additional columns (see below PKG, Size) from my StockItem extension (I have a table that is an extension from StockItem, called StockItemX).
My question is, can…
Hi all,
I have a sql script and previously successfully updated to Sage 200 company database. Now I add the following line
EXECUTE spCreateColumn 'UnprintedInvoice', 'FormNumber', 'bigint', '13', '2', 1, 0, 0, 1, '0', 'None'
EXECUTE spCreateTable…
Hi all,
I see there is tblParameter in configuration table, I would like to store my key value such as custom database name, servername, username, and password in tblParameter to be used in my custom form.
In Sage.MMSAdmin.DBSchema.Others, I see there…
Hi all,
I want to create a custom database using addIn.sql file from an Add on, so user do not have to go to MSSQL to create himself. But I have problem installing the add on because of this error:
"CREATE DATABASE statement not allowed within multi…
Hi all,
I want to create a program where all companies in Sage 200 should be able to access and the data provided in this program should be stored in a custom database, not individual company database. I assume for the create database query, I can add…
Hi all,
I am having this situation. I have A,B as my existing companies and have my custom table added to their database. Then I have a new company C, and this company does not have my custom table yet so none of my customize form is working on company…