Sage 100

Good Afternoon Does anyone have feedback on Scanco Warehouse as a solution to automate receiving inventory transfers and shipping? If you have experience with this product would you recommend it? We are struggling with the decision as the receiving…

Dear concern, I am using sage erp 100. I accidentally deleted batch . Now can not post invoices. But these invoices hold items which are not available for sale. I want to cancel or delete these invoices. Please help me to solve this problem

Is there a way to change an old REV of a BOM to history in order for the inactive REVs to not show on every inquiry? We have been using Sage for a long time and some of our BOMs are no longer active as we no longer build those items. We need to keep the…

A customer wants to migrate from Work Order to Production Management while remaining on version 2022. I have searched KB and even called support for answers, all with no luck. I am looking for the process to migrate existing work orders data to production…

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…

Do we have ability to charge restocking fees based on price net of prorated discount? thanks

Unit price drops down to 0 when changing the quantity of "ordered" on the same line item. Is this normal behavior, or was this intentionally implemented at some point? Can anyone point me in the direction of an article to reverse this? Thanks!

Upgraded to Sage 100c Advanced v2022.1 with OM PU1 from v2019.2 Shipping Setup Options has Auto Increment disabled, but when distributing Lot Numbers in in Shipping Data Entry, the Auto Increment in the Lot/Serial Number Distribution window is enabled…

We have numerous SKUs with a reorder point of 0 and most are treated as special order product. We often find that special ordered material arrives from the vendor only to find out the customer cancelled, the SO was deleted and no way to look back at transaction…

We currently use all the core modules (GL, AP, AR, BR, PR, IM, PO, plus Job Cost and Time Card. I am looking for something, for example - we may have 1-3 jobs at a time (up to 90 days each), each job will have 2-3 work tickets, and each work ticket generates…

Hello! i'm hoping you can help me with something that i'm sure is a very simple fix. We run small inventory counts usually to confirm and reconcile backorders or questions about shipments through the month. Usually, we run an inventory valuation report…

With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before. Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled. Our…

Has anyone seen this before? The Lot/Serial Column, which is normally blank for a FIFO Inventory Item Code, shows a random serial number, from a random Serialized Item Code (in our case this serial number that's showing up really is a serial number of…

I'm preparing my upgrade from v2019 to Sage 100c Advanced v2021 with PU1 (due to Scanco Operations Mgmt compatibility) and notice KB articles referring to slow performance issues with STANDARD and PREMIUM. But nothing with ADVANCED. Does anyone know…

Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you

I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…

Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…

How to delete a line item in a sales order invoice that has been pulled through from standard sales order. Sage Advanced 2020 6.20.0.1

We need a report (preferably one that would easily import into Excel) that breaks out the allocated cost for inventory receipts by lot. You can look at this information in the cost detail tab, but I cannot find a report that shows this information separately…

This might be a simple question, but I couldn't find a solution. I have an Excel Spreadsheet with a PostDate column whose value is: VLOOKUP(E2,upload!A:H,2,FALSE) and it shows as a Date. I'm using this spreadsheet as a data source, but my application…

We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP…

When I enter the purchase order, I s elect the standard order type as shown below. And the PO already has been issuing invoice and batch also has been run. So now the amount of PO shows as inventory G/L account. But it should be purchase G/L account…

Hello, my company currently uses inventory management to track in house supplies. We are a medical facility, that has 70+ departments. We do not sell the inventory outside of the company, however as departments need supplies we do an "Inventory Issue…

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.…