• 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…
  • Creating a finished good Item that's procurement type is a make

    FormerMember
    FormerMember
    Good Afternoon, I am creating a part number in Sage 100 and it is a finished good that's procurement type is a make. From what I have been taught, if it is this kind of finished good, I fill in the Retail price and the Standard price but do not touch…
  • Has anyone created a Crystal report that shows the warehouse quantity on hand by warehouse in column format instead of row?

    I am using Sage 100 version 2013. I have a report that uses the IM_ transactionHistory, CI_item,and IM_itemwarehouse files that are all equally joined. I am grouping on the item number in the transaction file. The detail information is suppressed but…
  • Direct Labor Costs Built into Bill of Materials for Items Sold as a Kit (always explode)

    We have a packaging company with a large variety of items which are packed to order. As we don’t prepack, virtually all our sales are through kits with the option selected to “always explode”. We do have a bill of materials (BOM) for each kit as items…
  • JobOps with Sage 100 ERP using barcoding with JOScan

    Community, We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…
  • Utility - IM Balance Quantity and Cost for Average Cost Items

    Can anyone tell me specifically what this IM Balance Quantity and Cost for Average Cost Items utility does??? I have missing transaction records in my IM_TransactionHistory file and now way to recover them. Thus when running Recalculate Item History utility…