Browse By Tags

  • Sage 50 US. Search for inventory items using "description" keywords, inside the sales order.

    Can anyone please help find out ALL the ways possible to search for inventory items using "description" keywords, inside the sales order. Say, there are hundreds or thousands of ID's, there is no way to know or remember them. But the users know the…
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Sales Order - Stock Status on Sales Order Quantity and Sales Order by Item Report Quantity are Different

    For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…
  • How can I verify where items are committed? Sales Orders/Backorders/Etc.

    My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • Inventory SO Qty issue (Sage Evo 100)

    Good Day All So firstly I do not know what section to post my question in so here I go We linked our Sage Evo 100 with our new website that was developed so it will show available stock for sale, but we are having an issue currently Say I…
  • Need a solution for Sales Orders with different ship dates

    We are a metal fabrication shop with a manufacturing division. One of our clients sends SOs which can range from 1 item with multiple quantities to 60 items with multiple quantities and different ship dates. I understand we can't do different ship by…
  • Inventory Valuation Report That Includes Items on Sales Order

    Months ago I created this post about the Stock Status Report and Sales Order Qty: https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/110446/inventory-valuation-which-shows-available-balance…
  • Quantity Avaiable field

    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.…
  • Reverse Item Merge

    Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
  • INVOICING PROGRESSIVE BILLING

    Is there a way to keep track of materials used and labour for a project on excel and export it into sage as a sales invoice? I have been weeks trying to figure out the easiest way to keep track. I could use time slips to keep track of labour but it doesn…
  • Allocation of components to a Sales Order to be produced

    Is there anyway standard to register detailed allocation of components to be consumed on the WOs but previously in the Sales Order? Example: I have a Sales Order with product A; Product A needs component C1 and C2; I create the sales order and…