Browse By Tags

  • Contract Billing Report Customization in Crystal

    I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
  • Clob Field not Pulling Values(Menu item)

    Hi I have a task where I have to add a Text Field(CLOB) on the customer screen as a menu item(on right side) So far this is what I accomplished 1.Added menu item and Enabled it in SETBOUT 2.Created a new screen(ZACLOB) with a CLOB field When…
  • Printing a crystal report via webservices

    Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…
  • Line Menu - Data not stored

    Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…
  • Add Line to Grid

    HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?
  • recommend a Sage Specialist for writing reports in Financial Reporter

    Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.
  • Insert new line in AOWSIMPORT web service

    Hello, I'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…
  • creating a web app using mertial picking adc functionality

    Has anyone every created an external web app and that app uses the adc functionality or know of a way to do this? So basically, I am trying to create an an external web app, but I want it to behave in the same functionality when I am doing the material…
  • Validation rule on a custom field

    Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…
  • Creating new BP address field on Delivery

    The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record. I am trying to add a BP number and related…
  • ADC Soap API

    Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris
  • Adding Invoice number to email template for subject line.

    A client wants to add the invoice number to the emails subject line not only the $COMPANY_NAME. Is there a way to incorporate the invoice number either on the subject line or the pdf name without doing it manually? Thank you,
  • I need help with cloning a capability.

    Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…
  • Reading data from the REST Web Service

    Hi All, We are calling a REST Web Service via the classic 4GL code with " Func EXEC_REST_WS" . I am using a simple GET to retrieve information. The parameters that are described in the Online Help ( link here ) make use of a Return s parameter.…
  • Issue with Crystal reports prompting for SQL sa password.

    We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…
  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…
  • Invoice design

    Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…
  • How to do I get a substatus to show in the recontrol box?

    Hi, I am having trouble getting the substatus to show in the recontrol box. I got the substatus to show as a select but when I select it, it shows the name of the parent status which is A. I want the box to show the sub status AR which I created. How…
  • Customizing the date widget

    Hi all. Is it possible at all to customize the standard date widget? For example, i s there a way that the week number displayed at the footer of the date picker can reflect the week of financial year rather than the calendar year? Thanks in advance…
  • Edit right main links on Representation (Syracuse) to call action/source

    Good day every one, Does anybody now how to add a custom right lit link to a Representation (See red mark on screen shot). We want to add it to a customized representation. Thanks in advance.
  • Report print Macros

    i have the below Exception please any help ????