I am just curious on the best practice for User Defined Table name vs a User Defined Field name that has the UDT linked to it. I have made both of them the same name in the past but i was talking to someone the other day that stated they usually make…
Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table?
I've tried creating an UDF via CM under SO Additional Picking List Work, but I…
I discovered that if a date field (e.g. PromiseDate or ExpirationDate) is changed on a new SO or PO line with a Pre-Write event that also sets any other value in that line, the screen format of the changed date for that line also automatically changes…
I need to increase the Length of the Item Maintenance screen to accommodate a large number of UDF fields that will be entered on a new tab. I have never been successful at doing this. I usually get error 65 once it's done. Is there a special trick to…
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…
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 All,
I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....".
On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write.
…
I've added a field to the Employee Deduction file for the garnishment account number. Added it to the Deduction tab screen, but then realized I can display it there just fine, but I can't ENTER it anywhere! Can't modify the Deduction ENTRY screen. WHAT…
I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?
Hello,
I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query.
This needs to be run on the Client…
Hello,
I'm working on a project where I need to pass a parameter to and open a custom crystal report. I have done a lot of searching, and understand that it is possible, but I can't even open crystal let alone pass parameters. I keep receiving the…
Hello,
I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…
Hello,
We are trying to set up our customer maintenance screen to look identical to customer inquiry, except for one tab so that a certain department can access just that one tab. To do this, I am creating a custom panel which locks all fields except…
Hello,
I'm curious if it is possible to have a visual process flow button simply open a file instead of download it? I have a button set up linked to an excel document and another linked to a crystal report, but clicking these buttons causes an internet…
Hello,
Our accounting team inquired about the possibility of making the "Comment" field on Sales Orders editable even after they are put into the history table.I do not believe this is possible, but was hoping that it IS possible to add a NEW "Comments…
Hello,
I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…
Hello,
I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel.
For…
Hello,
I am trying to create a button/link inside of AR Invoice History that pulls up the Sales Order and Quote History window. Basically, something that acts identical to the "Invoices" button at the top right of the screen on Sales order Quote history…
I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great.
Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…
Hi Folks,
my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend.
is there a way to create…
I'm trying to create a mask for a string UDF that displays <blanks> for missing characters. If I use 000 000 000, the empty field displays the zero mask even when the field is empty. This is confusing as there's no way to tell if the entry is truly 000…
I am writing to find those that have used the document attachment feature for some time now. I would like to know if you embed or link your attachments? If embedding, does Business Works run efficiently with a lot of attachments?
We are new to this…
I am trying to write a script that will take numeric values that are currently stored in a string field and perform a mathematically expression on them.
For example:
Field 1 is 10 character String field
Field 2 is 10 character String field
I am…
I'd like to create an additional field in SO Totals that shows a fixed percentage of the sales order total and then, in a separate field, shows grand total (sum of order total + %). How can I achieve it?
