• User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • Email SO Invoices with Attachments

    I know how to add attachments to emailed invoices, but I understand all recipients get the same attachment. How do I email invoices, each with it's own unique attachments?
  • Cannot update Comment$ column in GL_CompanyActiveBatch_SVC in BOI

    Hi Forum, Is there a way to update the Comment$ column in GL_CompanyActiveBatch table using BOI?
  • Have you ever had performance issues with Starship due to your UDFs? What is your UDF count?

    Hi all, We've been using Starship for years but in the last week have experienced major delays and performance problems EXCLUSIVELY with their integration (meaning other 3rd parties like ScanForce, Avalara, Paya, TrueCommerce, Insynch, etc.... are performing…
  • Data Validation Error 115 SO Detail

    Hello Does anyone know what the root cause of this break between the SO and PO Lines. Since we upgraded to 2022 version (Sage 100 Advanced 2022 7.10.2.03 64 bit) This scenario has occurred on a frequent basis. I know how to correct it; however, we would…
  • Disappearing some SO backordered lines

    Hi there, I really hope you can help me with something unusual that has been happening here for the past month. We've been experiencing some issues with SO backorders. Normally, when we print the Pick Ticket and there isn't a sufficient quantity,…
  • Crystal Report - Text not visible

    I am working customizing Quote Forms using crystal reports and we have a standard text on each specific quote. This standard text will not show up on the sage preview. It is like somewhere in the report its blocking a view in some of the groups. Any Ideas…
  • Can you auto-generate comments on Sales Order lines?

    I need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?
  • (REPORTING) How to link invoice line items to GL Detail Posting?

    Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
  • Visual Integrator; Importing into SO_InvoiceHeader and Leaves Back Order

    I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…
  • Partial shipping of a Sales Order, Scrap, and Operations Management

    Hello, I'm dealing with a situation that I'm not sure how to manage. Let me explain: Suppose I have a Sales Order for a customer, in which I have only one line containing two units of a product that we produce. I also have a Work Ticket linked to…
  • qty after shipping SOs vs ON HAND

    hello guys!!! I have a trouble, im new in using SAGE100 but i can't identify teh difference between qty on Hand vs Qty after shipping SOs??? Someone help me to explain what is the meaning of qty after shipping SOs?? I mean, for example: I can…
  • 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…
  • Deleting a batch - am I missing something or is this a bug?

    I thought I'd done this before, but perhaps I haven't. The batch is empty. I've confirmed that. But the below doesn't delete it and the retval doesn't return an error. Am I missing something? I've confirmed that sBatchNo has the correct batch number value…
  • Open Sales Order Analysis

    I am looking to sort my open orders in a specific way that I cannot figure out with the standard open sales order report/open orders by item report. I would like to sort all the open orders first by product line. Then when I have all the open orders for…
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Sales Order - Deposit Payment Type

    Hi, For one of our customers, we enter a sales order with the Deposit Payment Type of Pre-paid, but is there a way to see what GL account it is going to? I am trying to track from a previous order, and under the totals Tab that is where it mentions…
  • How to print Extended Description on Sales Orders?

    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.
  • Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • HOLD button in sales order entry

    We are trying to get our receivables under control and our IT department has helped so that our customers now go on automatic credit hold when they have invoices in 120 days. In our system, when a salesman attempts to open a sales order and the customer…
  • Prevent a Customer from ordering a specific product

    Currently, we ship selected items to Canada but there has been a recent change with Canada FDA that we are now not allowed to ship selected products. Is there a way in Customer Maintenance module to not allow the selected items to be entered in the Sales…
  • RMA Does Not Have Sales Order Attached To It

    Hello, I am using Sage 100. I received an RMA about month ago and the Sales Order I thought was attached to it was either deleted or used by someone else. I wrote the SO # that was created in the "Generate Transactions" screen when initially receiving…
  • Editing Received RMAs

    Hi Everyone! I forgot to zero out unit price for a received RMA that already has a created batch in the invoice data entry (already posted the RMA Receipts Entry). Is there a way to edit or correct? I would greatly appreciate any help!
  • Print Copies of Picking List According to Item Quantity Per Order

    Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
  • Automatic Sales Order Entry

    What are the best options for getting automatic entries for new Sales Orders? Looking to integrate orders placed through online sales and have them directly entered into Sage. Currently on 2020, but looking to update.