Browse By Tags

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…

We are wholesale greenhouse, currently we don't track our inventory through sage. The inventory items are grouped under the container they are grown in (10" hanging baskets, 1203 Flats, 1801 Flats etc.). I am trying to get our inventory to be tracked…

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'm trying to edit the sales invoice to show both quantity ordered (from sales order entry) and quantity shipped (from sales invoice entry). When printing invoices it fills in the quantity ordered column with ??? rather than the quantity ordered from…

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…

Hello. How can I delete a specific row, from sales order rows list? Thanks. Regards. MS

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…

Cannot find any answers online for this.. Is there a way to convert sales orders to an invoice without showing the backordered items on the printed invoice? Any help is appreciated. Thanks

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'm syncing orders from the eCommerce store to Sage 50 US using .net SDK. The sales tax amount is calculated based on different sales tax percentage. I can not configure each time in sage 50 as I make changes in tax percentage in the eCommerce store…

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 set my software up to pull up the last paid price for individual customers when items are input in a sales order. I haven't been able to find anything that says that we can do that in Sage 50 US. I have found a couple of things…

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…

I would like to be able to print Sales Orders for our customers showing the amount received as a deposit towards the Order. I currently enter the receipt under Pre-Payment but that doesn't show up on the Sales Order.