I am trying to make a custom report in Business Insights Explorer that shows:
Item Code
Item Description
Product Line
Quantity on Sales Order
Total Quantity on Hand
But I cannot link a "Qty. on Sales Order" column to the rest of the report…
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…
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…
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…
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?
We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…
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…
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…
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…
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…
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
I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below:
retVal…
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…
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.…
One of the customizations we've added to our Sales/Bid Order entry line item screens is a column showing a product's available qty at the specified site. This is working correctly, however I would like to add more columns showing available quantities…
Greetings,
We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco.
The manual for the add-on is here. https://wiki.blythecodev…
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…
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…
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.
Hello!
A textbox has been added to Maintain Customer so that we can add custom notes. We would like to have these notes displayed in the Enter SO and QO task when the customer is selected.
I added a textbox and did a databind on custkey between my…