Sage 100

Can't find this having been discussed anywhere, although I thought I had. I am assuming I can use a Temp field and either assign "<CompanyCode>" or Calculate it somehow. So far, nothing that I have tried has worked.

Wondering if it’s possible to have Sage Alerts & Workflow refresh a power query right before it sends it as a file? Maybe with & Sage Alerts script? Need to send it as a power query file vs. a crystal report since can’t duplicate data in crystal reports…

Hi all, Is there a way to have the work order notes prefill with each new work order without using a template? Would like to setup a series of questions that CSR can see in the work order notes and type in answers after for example: Problem: (CSR…

Good day, Question regarding sales order allocation. Near as I can determine, each sales order is manually allocated and there is no functionality to be able to perform a batch allocation to sales orders. Does there exist an add-on that facilitates…

Hello - we are using Sage 100 Premium 2021 and I have questions about item kits/kit explosions. Item Kit "ABC-KIT" has 3 components: Components: ABC-001 ABC-002 ABC-003 Explode Kit field is designated as "Always" SOs show the following…

Hello, We have noticed on a hand full of Sales Orders that we pull up in Sales Orders and Quote history when we go to Invoices and check the tracking information it is incorrect and sent to the wrong address. However when I go to the shipping website…

Is there a way to customize the field "Add Sales Order Customer Detail as a Comment Line" field? Right now it inputs the SO #, Customer #, Name, QTY, and Customer PO#. I only want the SO # and the QTY to be included. Is there anyway of doing this?

Does Sage 100 have the functionality to incorporate invoice and PO approval work flow without 3rd party software or add-in?

Does anyone have any experience selling embellished items through Sage? We embellish most of the products we sell, i.e. monogram, screen print, decal, sewing. We have set up actual items in Sage for the embellishments, the item has a standard form in…

When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…

Hello, Is there a way to get SAGE to default the price of an item to the 'Standard Price' instead of the 'Standard Cost' in sales order entry? Before the quantity ordered is changed, the standard price shows (but greyed out). Once we change the quantity…

Please forgive me as I am very new to Sage 100 being recently promoted to production manager, a new position in our company that's greatly needed as you will read below. I am in charge of a small metal fabrication shop, that currently has around 85 open…

Hello, Running 100c 2016 on SQL and have Sage Alerts. Need to email invoices to all the email addresses set up for the Customer in the Paperless Office settings using Sage Alerts. How & where do we access those fields via Sage Alerts? Thank you…

We are looking for a way to allocate costs in Sage. We are trying to do something like what you can do in AP with expense distribution tables but we want to do it with an import, probably through Visual Integrator. What we want to do is to do an import…

Some products have only one layup tool available while others have multiple tools. Tool availability impacts capacity (and throughput). Does Sage accommodate adding the number of tools that are available to manage capacity planning or does each tool need…

I need to be able to show on the invoice a price of $ 20.00 per unit. I want the accounting to allocate 15.00 to product revenue and 5.00 to freight. My thoughts are to set up a kit to accomplish this. Please advise as to how you went about solving this…

Hi Everyone, I am setting up a shadow table to capture Master PO lines (which are not saved in history) I have done several other scripts for this client so I know that some of the basics are ok - External access is set. I made sure that everyone has…

Hi all, I would like to create two different manual check VI Jobs 1. Writes manual checks for amounts that are automatically deducted from our bank accounts. We have already entered and updated the invoices . The checks are often paid in a different…

We are using an old extended solution, On Demand Fill (SO-1099) to allocate inventory to orders and then automatically select orders that are ready to be pulled for shipment or assembly. It works great for regular orders but pick sheets for work tickets…

Is there a way to set an alert for when the "Required Date" field is changed?

Hi, Our company recently upgraded from MAS90 v4.05 to Sage 100 (2015). We are in the testing phase and I see that when they migrated our VI jobs over to Sage the Transaction Journal Upload did not work. I was comparing the MAS job vs. the Sage job…

Maybe a newb question.... however, I am trying to put landed costs on my purchase order. It seems that the FRGHT works as I would like my other types of landed costs to work. By this, I can enter FRGHT on the Totals tab of the purchase order prior…

I am wondering why the Standard Cost does not update in the Item Maintenance window. The item is set to Standard Cost in the Valuation slot, but when we enter a new updated cost in the "Last Costs" category, the "Standard Cost" space, in the Purchases…

Version 4.5, trying to import routings into wo.routing. it asks for a "blanks" line. What is that? The output of this data file looks like it has a header and detail, but the Visual integrator does not have the usual check box for header and detail lines…

can someone post a pdf of this page all I get is symbols and I am looking for the next package bar code, thank you, Tj update, I talk to sage and to print the barcodes from shipping setup screen you have to run C128Tools_Setup.exe from the workstation…