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 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.
I have two udf’s that are populated on the SO_SoDetail table, they are also printing on our pick ticket. How can I capture a date time stamp value for when that udf is edited (it’s a numerical value) and display it on the crystal report for the pick sheet…
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…
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…
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
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…
In general is there a maximum number of UDF's per table.
And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…
Is there a way we can add an "on-the-fly" text field that will show up on printed labels through Inventory Label Printing ? Our previous ERP system had a textbox on the print screen that allowed the user to type in a custom remark that then printed out…
During our shipping process we scan all inventory from the pick sheet into shipping data entry. I like to create a process that using a UDF will track that the item the was scanned into shipping data entry.
Example:
Item A quantity 2 Item A we scan…
Here is what I am trying to do: basically UDF # 1 will have options A, B, and C. UDF # will have options A through Z. If opton A is selected in UDF #1 then the user will be able to select A-D in UDF #2, if option B is selected in UDF #1 then user will…
I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…
I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…
I have a formula that I need to print with multiple conditions. I'm using a UDF with some codes in MAS that I need Crystal to convert into text. For example in MAS I could have in the UDF 23IJG . So I need Crystal to convert that too. if UDF_RESTRICT…
I want to link data in a detail line of PO Material Requisition Issue Entry through to IM_ItemTransactionHistory.
But when I try to pull a data value into the IM_TransactionPosting table, none of the Business Object sources listed are from the PO Mat…
I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…
I want to add field [Category4] from CI_Item to the Item Maintenance, but can not seem to find it in Custom Office User-Defined Field and table Maintenance. Can anybody help with that? Thanks.
I'm trying to create a custom dialog button in custom office on the SO Entry Detail screen to show some UDFs. The button would need launch a screen that allows me to put some UDFs that are linked to the line. If I create a custom dialog button in that…
