Sage 100

I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…

When I do the lookup by customer I have multiple listing for the same customer. It looks like the breakdown is based on year and period. However when I select one of the same customs for a given year it's the data is not the same when I select the same…

I have a role that only prints blank work orders when ever WOT printing is processed. Header detail of the crystal report appears but all fields and details are blank. Im holding the Role Maintenance of a working role side by side with the non-working…

I have a lot going on in this pic but a recent upgrade to v2019 Adv with Production Management show on the Item Maintenance Orders tab the choices Work Ticket (s/b Purchase Order and they are under there) Sales Order and Work Order (looks like it should…

We have a finished good that is serialized, however we will now be selling this item with an additional component that we would like deducted from inventory automatically. We had considered changing the serialized item into a 'kit', however that would…

After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…

Where does the QuantityOnHand value come from in the SO_OpenOrderWrk file? The field value is always zero when I try to use it in an Open Order Report. I would like to pull the QuantityOnHand from the IM_ItemWarehouse file based upon the WarehouseCode…

Is there and if so, where can you switch Direct time entry in the manufacturing module SAGE 100 to batch positing? TIA, Tracy

Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…

We are going with SAGE 100, Starship and other integrated solution providers. What Zebra printers, shipping label sizes are best for printing both UPS and Fed Ex shipping labels. Michael

When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…

If you do not have the box for "Post AP Invoices" checked in PO Options...how do PO's drop off the PO clearing report?

Does Sage have the ability to supersede an item? I am new to Sage and coming from my last system(CDK) it had the feature to automatically supersede to the newest number.

Hello, I am working on an application for SAGE 100c for inventory and order management. I just need to be able to do basic functions such as pull-down product data and create orders for the customers. If anyone could provide examples or documentation…

Has anyone found a way to have Item Cost show in the line information during an Inventory Management Issue transaction? Thanks, Erin

I am very new to Sage 100 and have not seen any general ledger postings to an account called Mfg Variance Adjustment until just about a month ago. Not sure what changed in the file, but can someone explain what this account is used for and how I can back…

Tryiing to find documentation for EZ import

Has anyone else been told this? Did anyone receive notice of this?

Is there a quick handbook for putting together multi-level bills? Thanks! Dan

"Invoice History Printing" let's you reprint invoices. Is there an equivalent tool for Purchase Orders? We are an importer. We send the original purchase order to our vendor overseas. Once the goods ship, we add the container number as a comment on…

Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …

We have been using Sage 100 along with the Scanco and JobOps modules for quite some time. We recently purchased a module from another ISV which requires some integration work to be completed to ensure they operate together without conflicts. We’ve tried…

Does anyone know how to change the valuation default in Item Maintenance from Standard to Lot? Trying to prevent incorrect entries when setting up a new inventory item. Thanks for your help!

Hello all, I know that the "PO Number" field within Sales Order Entry is used for Auto-generating PO's from Sales Orders and creating drop ship PO's from a Sales Order, but I wanted to know if it has any other purpose? I wanted to use this field for…

Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…