• PO and Account Payable Invoicing Configuration Issue

    Hi, We have an issue with customization. In the Purchase Order Entry Screen....price and quantity are entered in their respective fields. When I go to invoice entry....price and quantity are reversed. Price populates in the quantity field and quantity…
  • Full Piece vs Partial Inventory

    Hello, Does anyone know what the standard way to handle full piece items vs partial items is in the inventory management world? We currently keep our full piece steel sheets in an entirely separate warehouse within Sage even though it's physically in…
  • Sage 100 Inventory Module Setup

    How do you setup FEFO
  • Auto filling Inventory from Receiving Purchase Orders

    We are using Scanforce to receive our purchase orders once they are placed. We can see the receipts in the Receipt of good entry section once they are received, but would like to see the inventory auto update to our on hand stock once received. Do we…
  • BOI Purchase order entry to Receipt of GoodsGuidance

    Hello I am currently entering a Purchase Order into a Receipt of goods using BOI but the issue is when we don't receive an order fully it is leaving our items on backorder... Is there a way to get rid of pending backorder through BOI? or is this a bad…
  • Assign the correct Tax Schedule in Visual Integrator

    Hey All, I have a VI question. I have a pretty decent understanding of import jobs, but this one has me stumped. For our eCommerce website, we now have to start collecting sales tax in states where we meet economic nexus, and bring those taxes into…
  • Template No. Question

    We have a company with BOM turned on as well as Production Management turned on. A few questions have been asked about having a template number on an item in Item Maintenance. The issue with this is for us an item could be used in multiple different product…
  • 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…
  • Check Customer Balance while Backdating

    My company has two departments, the main account dept are doing a process called Backdating. While they do this, another department is doing customer lookups for their current balances. The issue is when the main Account Dept is doing the backdating;…
  • Purchase Order Standard Comment

    Is there a way to setup standardized memo comments that we can use on specific orders? Example: We place 100 orders a day. About 30 orders a day need a specific comment to be used on each order. Currently in SAGE we need to reenter value each time…
  • Making changes to the components of a kit in the BOM

    I am wondering if there are any negative repercussions that I may not be thinking of if we make change to the BOM for our kits. For example, we have kits that have multiple boxes in them and sometimes we may decide to repackage this kit and break what…
  • VI Export - how to export the Company Code

    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.
  • VI Job for PM Work Ticket Entry

    Can anyone help me with importin in PM Wok Ticket Entry? I've created the Temp H file, but it gives me an error "HS Record Invalid"
  • Receipt of Goods Entry: Auto Toggle

    Currently, when scanning serial number based products into our system we have have to hit the "enter" key on our keyboard. Is there a way to setup an auto toggle/move to the next line after scanning the first serial number on the product? We do have…
  • AutoGenerate from Sales Orders Does Not Copy Item Comments from DropShip Lines

    Hello, We have comments on sales order dropship lines that we would like copied to automatically generated purchase orders, if possible. We are unsure how to accomplish this. Is it possible to transfer sales order line item comments to dropship purchase…
  • Memo File Attachment Location

    When using the Sales Order Module, attaching a file seems to simply link that file from the original location. Is it possible for Sage 100 to manage the file location? In other words, Sage 100 copies the file from the user's machine, and places it…
  • Sage Alerts & Workflow refresh a power query?

    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…
  • Automate Work order notes

    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…
  • Auto Sales Order Allocation

    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…
  • Copy tab 6 from customer maintenance to Job Maintenance panel in its own tab

    Is it possible to move tab 6 (invoices) in customer maintenance over to its own tab in Job Maintenance? Where to start with accomplishing this? Users are just tired of needing to open 5 or 6 modules every morning and keep them up all day, so we're looking…
  • Bill of Materials - Parent & Component Serial Numbers

    The Bill of Material allows a parent item with components. Is there a way to create a serial number for the Parent Item and then assign serial numbers for the components? Thanks!
  • Hot List

    If you do not have the Document Control but you can access the Project Work Center - Can you still use the hot list checkbox? If so, how can you determine the flow for approval?
  • switching to calculating retention on jobs in mid-stream

    Is there anyone out there that has turned on calculating and maintaining retention in Job Cost and AR? Crediting IN invoices that are total retention and creating a RT invoice. Just getting started. I was looking for any help...trying to be pro…
  • Items Kits / EDI

    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…
  • Memo attached file

    Hello, We attach excel spreadsheets such as vendor price list (not large 75k) to memo's when we try to open some that are located on a shared server (not sage server) they won't open, Sage will kick us back to vendor entry screen. In the past I was…