Hello!
I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product.
However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
Good morning,
I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says:
Only simple conditions using "le", "ge", "eq", "lt"…
Hi there,
I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…
Hello,
I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM:
Unfortunately, this script does not exist in the…
I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
I've set up a custom field in the ITMBPC table to denote that a particular customer product needs to have a special dispatch label printed. It's a simple yes/no, so I have linked it to Local menu 1.
How do I get it to display in the ITU screen so that…
I've started doing some very basic scripts in house but I've run into a wall recently. I'm trying to emulate the same behavior that is seen with MANHLDREL tied with the manual hold button on the SO screen. That is, when the action is triggered, a window…
Hello All,
Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.
I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
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…
Hi all, i have a problem with this function:
Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…
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…
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?
Hi Guys
I'm quite new to how the development works in Sage X3
Am trying to calculate totals based on a currency on the Purchase order Screens
Have added a new field to the Purchase Order table and POH3 screen
field: ZTTVORD
so based on the currency…
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…
I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.
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…
Hi,
The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates.
Is this possible using Windows Task Scheduler or is there…
Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…
Greetings,
I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message.
Has anyone…
Hello,
I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt)
The field is currently showing six decimal places on items related to labour (i.e…
Hello,
I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt)
Each field is currently showing…