Browse By Tags

Rather basic question considering what I have seen on these forums, but, I cannot figure out how to do it. To further clarify my goal here, when creating a PO and entering each line item’s price and quantity, I would like an intuitive way to multiply…

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…

Is there a spot to enter a customers Purchase Order number on a Sales Invoice? Seems to me its a very important piece of an order, yet I can't find where to enter it for my customers ! (I have Sage 50 Premium)

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…

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

Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…

When trying to add comments in the "Delivery Comment" box of the "Delivery" tab on the Order Management screen, I encounter the error message in the attached screenshots. This seems to occur when trying to add several comments. I'm trying to shorten the…

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…

Hi All, I'm making a macro to post receipt entry based on PO number and the receipt number is pre-generated. For the detail line, I do not want to receive all. But so far did not success. How to prevent receive all? Below is my code. I have set…

I am having issues setting the Purchase Order lines with a GL Account code or key gathered from a SQL table. It doesn't matter what I try to pass, the system always defaults it to some obscure account code. All other fields I set work except for the GL…

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…

Hi everyone. I am struggling to export the bank details I spent hours loading into Sage one. You can extract Allot of details but not what I need. I tried creating a user field which I named Bank account, Br code and bank name and was hoping there…

Is is it possible to have the product Desc 2 show up on Purchase order Screen? I looked at the screen level on PO and it is not hidden or available. Product screen:

Hi Guys I'm quite new to how the development works in Sage X3 Am trying to calculate totals based on a currency on the Purchase order Screens Have added a new field to the Purchase Order table and POH3 screen field: ZTTVORD so based on the currency…

I there, I'm new in Sage X3 V8 My Company has large Item descriptions with more than 30 chars lenght so we need to use both description fields, description 1 and description 2, but this 30 chars limit start to make a lot of troubles for the user becaus…

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…

How do I change the default text for a discount so I don't have to change it each time I apply a discount while entering payments?

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…

Does anyone know how to printing row numbers in takeoffs? Would be great to reference the row numbers on the printed PDF takeoff

I have a checkbox UDF in PO_ReceiptDetail called UDF_LINE_COMPLETED, I have the same UDF within PO_PurchaseOrderDetail. I am trying to map the checkbox from RoG to the purchase order lines. Here is how I have it set up: This however is not working…

We have a checkbox UDF in purchase order entry at the lines level called UDF_LINE_COMPLETED, when they check this box I would like to zero out the quantitybackordered field. I have tried this script as a column pre-validate and post-validiate on the UDF…

Hi, Is it possible to change the Extend Price Calculation in Order Entry? Right now, our products are sold by the item number and the length. For example, a wood pole may have an item number called,"WP". We cut the WPs based upon the customer's request…

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…