Sage 100

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?

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…

is there a way to get a sum total of all the pieces ordered to calculate and print on the SO, Packing list or bill of lading. I am looking for the grand total of all the items. Having a grand total of the items shipped would also be helpful. Than…

I have a formula in my SO picking sheet it puts different words on the header depending on the number of days between the order date and the ship expire date. I want to edit this formula that the < 4 is actually 0 to 3 Business days. before the wording…

I would like to know if it is possible to only create Po's from a sales order for items we don't have in inventory? If I create a sales order that has lets say three items two that I can pull from our inventory and one that I don't have any in stock…

I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit). The client will have an issue with the Freight amount not saving on the Total tab. I will go in and recreate the customized…

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…

Does anyone that knows how to control and allow salesperson to be able user lock the by the salesperson to be able to see only see their only their customer statement and sales order invoice but no other sales representative. Currently, the lookup is…

I am trying to warn the user with a message when entering an A/P invoice and selecting a Job that is no longer active. Since there is no Active/Inactive jobs in J/C ,module, the customer is using the Sort field for this purpose. For jobs that are active…

We have a lot of information in our header tab already and when we print our sales order the space is mostly allocated. We have a new UDF field that we need to create and I am trying to figure out a place to put this new information, was hoping in the…

I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…

I need the Cancel Reason Description to appear on Open S/O report. I added using Database Expert I added SO_CancelReasonCode database. Put the field into the repport. Not the report ONLY displays S/O that are = HOLD and shows the Cancel Reason. If I remove…

We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…

I have been using MAS90 and Sage 100 for many years. Now I am needing more custom reports, but I do not know that much about creating or modifying crystal reports. I am using Sage 100c Standard 2017 V5.40.1.0 and Cryatal v14.0.3.613 RTM. Where can I…

We are trying to figure out a way to make and print packing lists per box, as opposed to printing one packing list for the full order and placing it one of the boxes. How is this done with Sage100 Standard? We want our customers to know the contents…

Hello, I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…

I'm working on a button script ("Execute on Server" selected, MAS 200) that will export a PDF of a Sales Order to a specific location without prompting the user. I'm running into some strange issues and was hoping someone has seen some of these things…

Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…

While in a Sales Order line, selecting the Price Lookup option from drop down, produces the correct match for this item, this customer. Is it possible to capture that data and print it on the Sales Order form? I want to get all the columns for Quantity…

Was wondering if there was a way to add ShipVia to the selection (Select Field) when entering a range of sales orders in Picking Sheet Printing i have an order range, and some of the orders are say FedEx and some UPS. I would like to enter the Order…

I have setup paperless office and it is working great, thank you all for your help. Is there anyway to also send the other forms requested by certain customers with the invoices such as the C of C's, BOL's or Packers? I'm not sure if there is a way to…

we are currently using Sage Standard 2014 5.1 version. We are loading Sales Orders using an EDI Translation software and MAPADOC. The orders are loading into Sales Order by Customer #. We have one Customer due to different divisions/vendor#s sends…

Is there an easy way to have customer invoices carbon copied (or blind carbon copied) to the salesperson when we use Paperless Office to send them to the customer? It seems like the only way is to set them all up as an additional e-mail address in Paperless…