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…
We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?
I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab?
am I able to put a custom view in here somehow as a shortcut?
We are attempting to copy over all of our customized to fields from a test company to a brand new company. Is there an easy way to copy over the customized fields and panels while creating the company?
I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail.
The Code field appears from the table but i cannot select it.
what needs to be changed?
UDT
AP Invoice Detail
UDF in AP
Thanks for your assistance…
As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all!
I am working with the Open Sales Order Report now and stuck on suppressing some items in the report.
The end goal…
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 created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed.
I am now receiving an error 88 type mismatch (error window below). Any thoughts?
START OF CODE
Dim retVal Dim cpwgt Dim cpwgtstr Dim…
I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order…
When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…
Good morning
I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present.
The problem is when you go back into the function and…
Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…
So I have been presented with an interesting challenge.
In our company we've set X3 to batch allocate all available stock to meet all demand in the system.
We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
Hi everyone, I'm using Sage 2013
I've added a new tab to the Sales Order module in Main > Invoice Data Entry
I've added fields/UDFs (some are already ones that existed), but I'm unable to add to anything in this tab or figure out how to get some of…
I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…
Hello,
We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'.
Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
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…
We just hired a remote team member to process orders that drop ship either entirely or partially or are fulfilled electronically. Our current work flow revolves around paper and that doesn't work any more.
Have you built or found an Order Manager…
Updated from Sage 100 Standard to Sage 100 Premium. Need to supply vendor name on job cost invoice. for customer. JC_InvoivoWrk only supplies Vendor id and Division id. How best to link JC_InvoiceWrk to Vendor File to get Vendor name in database
I'm having an interesting issue at the moment.
I'm trying to call the TCWPOHTOSIGM representation and TCWPOHSIG class via the $details facet. It is not returning the supplier name though.
The supplier name exists in the table, and the field BPRNAM1…