Browse By Tags

  • Project allocation on Sales Orders

    I enter sales invoices as sales orders initially. Some of the orders have multiple projects. But there is no column to allocate individual lines to a project. Only the entire transaction can be added to a project. Does anyone know if there is a setting…
  • Sage 2022 Customer Maintenance Custom Tab List-Box

    Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…
  • Sales Order To PO Address and lines button script

    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…
  • Program screen ID

    hi all, I am following example on this link https://www.sagecity.com/us/sage300/b/sage_300_erp_r_and_d/posts/launching-non-sdk-programs-from-the-desktop to create a screen using C#. I am able to create and working fine. However, the details is not looking…
  • Editing Field to Screen

    Hi Everyone! I try to edit Column Type Input and chose Enter but after saving error will goes like this Does anyone know if I am doing this correctly? Thanks!
  • Split Sales order with a script

    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?
  • Prevent identical Sales Site and Sold-to BP Number

    Good afternoon, we'd like to prevent our various sales sites from accidentally creating sales orders with identical Sales and Ship-to sites. Currently, there is a warning pop-up, but it does not fully stop the transaction, it just warns the user as soon…
  • All "lookup" windows Sage 2022

    We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…
  • Modifying Order of Secondary Grid Lines for All Users on Sales Order Module

    I'd like to modify the order in which lines are displayed in the secondary grid in the Sales Order Module (Sales Order Entry). We have several UDF's in that grid, but I am having trouble seeing the list of fields within that secondary grid. Using customizer…
  • SO entry screen

    We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…
  • Is DeactivateProcedure usable on external scripts?

    I've used DeactivateProcedure on scripts running within Sage, but not on external scripts. I'm working on a script that requires me to disable procedures in SO Entry. I've tried a few variations, but I'm getting "Object doesn't support this property or…
  • Issues opening Sales Order with Script Sales_Order_UI

    I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…
  • Script on SO Lines, Visual Bug

    Apologies for the large block of text but this is a strange one. I have a script that recalculates the Unit Price of a parent Kit item based on the component items' standard prices, and recalculates whenever a Quantity Ordered is changed for any component…
  • Launch Sales Order Entry to create new order from Customer Maintenance and pass Customer Number

    Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…
  • Reproduce Sage Interface design in C# Program

    Hi SageCity, which framework can I use to have the same user interface as Sage 300, Border Size, Title bar color Example Sage Interface : My Interface :
  • Launch Customer Memo from a button.

    Currently you cannot make changes to the sales order without closing the Memo screen. I'm trying to launch Customer Memo from a button in Sales Order entry. I tried retval = oSession.InvokeProgram("AR_CustomerMemo_bus.pvc","CustomerNo") The retval…
  • Can I use table IM_ItemWarehouse to trigger script?

    Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…
  • Need help with a script invoked on the button click to validate the customer's open invoices

    Hi friends, We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button. If the customer has any open invoices that are past…
  • Script to update child line

    I wrote a script sales order detail post write script that creates a child line that is a percentage of the parent line. If the updates the parent line quantity, unit price or extension the script updates the child line, BUT does not display the change…
  • Custom Panels Disappeared, need help!

    Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…
  • How can I develop an add-on for sage 50?

    Hi Expert, Currently, I need to customize my sage 50 software, something like add user defined field to sales order and sales invoice, create a customize form that I can define this page display and fields and logic. Could anyone show me some lights…
  • Add available stock qty columns from multiple sites

    One of the customizations we've added to our Sales/Bid Order entry line item screens is a column showing a product's available qty at the specified site. This is working correctly, however I would like to add more columns showing available quantities…
  • Create Script to Explode a Kit on a Sales Order

    I've created a script to add line items to a Sales Order, but adding a kit using the same method does not explode the kit as it should. Should Kit items still be added to the line item (oLines) array on the SalesOrder object, or should some other function…
  • Set a field as required in Order Entry/Shipment Entry

    I want my staff to mark orders/shipments as picked up or delivered using the SHIPVIA field. But even after training them they forget to enter this and leave it blank most of the time. Is there a way to make the "SHIP VIA" field required in Order Entry…
  • The "Fix" Button in Sales Order Tab "5 Payment" - How to control via roles and permissions?

    The "Fix" Button in Sales Order Tab "5 Payment" - How to control via roles and permissions?