Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
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 need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?
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…
Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…
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…
I was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.
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…
Hello everyone,
I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions.
One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…
Sage has built-in support for storing dates in a UDF by simply changing the "Data Type" to "Date". Then under default value, "<SystemDate>" to allow the date to be immediately filled upon new record creation.
Did they forget that dates are usually paired…
Trying to color the SO header customer# field if the customer type fall = specific value. I appreciate if you can help.
Ctype = ""
retVal = oBusObj.GetValue("CustomerType$", Ctype)
If Ctype = "SDIS" then Set myUIObj = oSession.AsObject(oScript…
Is there a way to make hidden columns by Transaction Entry type show in transaction types they don't typically? And be editable?
For example, the Unit Cost / Price definition in the Sage Help has this note:
" The transaction type selected in the Transaction…
New to this forum, and new to using the Business Object Interface.
Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
Is it possible to have a locked UDF field display its contents in red, possibly via a DFDM property change?
I've attempted (without success thus far) to update the color via the DFDM Nomads_Color property to 01FF which appears to be the hex code for…
Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?
I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…
if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version?
we had an employee accidently create a customized panel and it is not correct how can I get her back to…
From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card.
First I actually…