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 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 would like to see the Job Name, in addition to the Job Number, for each invoice, on my AR Aging Report.
Using UDF links and customize the Crystal AR Aging Report.
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…
Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields. I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…
I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory.
I've tried several links and can't seem to get the correct combination.
Can someone…
I have created a "description" field to hold the description of the unit of measure as the 4 letter unit is often pretty cryptic. I had no problem creating it, but when I go to add the field to the panel (Dmain), I cannot add my UDF. The add field is…
I am trying to add a UDF with a one to many relationship with an inventory item.
I created a UDT to store the values of the UDF that will be associated with the items. Then I created a second UDT to store the relationship between the items and the UDF…
I am getting this error message on my bills "The field " " for Timekeeper cannot be blank". I understand that I need to change the Timekeeper Classification setting in the LEDES set up box, and in order to do that, I need to create a custom field. However…
Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…
I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
When adding a particular SO Header UDF to the report I get this error message.
"data provider or other service returned an E_FAIL status"
I have reviewed all the data in the field and there are no unusual characters it's all numbers.
the report…
We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
We sell valves for oil and gas pipelines and installations. We use one short description for sales orders and then very long detailed descriptions for purchase orders on how the valves are to be built. As Sage 100 only has one item description field we…
Optional Field Value. Attempt to modify a different record than was retrieved.
Im getting this error while trying to enter new value for the optional field. Kindly help.
Thank you
I added a tab to my Invoice Data Entry panel with UDFs
I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry?
The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…
Recently upgraded client to v2019 Adv. They wanted some UDF's cleaned up and I am seeing these fields from the report on older tables that are no longer available. How can I clean these up so they do not show on the report anymore? The report I am referring…
Hi,
I have a UDF created in Inventory Management in tab 8. Web, which is called UPC, so I can add this information into Sage 100.
I'm wondering if there's a way to bring this UDF for UPC from the tab in Inventory Management to the Sales Order module…
I have a UDF in Customer Maintenance that is validated against a UDT.
The UDT has 3 values:
NoCal, SoCal, and Texas
When I select the UDF in Customer Maintenance, the UDF value is stored as upper case.
Is there any way to store the UDF value as…
Hi everyone,
Does anyone know the fastest way to find the largest value in a number field using User-Defined Script/VBS?
Background : I'm working on creating a unique ID, like GTIN/UPC, for each item code as the item codes are generated. To get things…
Hi
We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF.
I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…
Hi...
I want to create a new tab on the customer maintenance screen with each of the 50 states listed. Each customer may have one or many of the states listed checked. My question is will I need to create a user defined field for each state, which is…