• How do I add new lots on a receipt for a Purchase Order?

    I have created a new Lot item in Sage 100, and then created a new PO with the new lot item. When I go to add new Lot numbers to the Receipt of Goods Entry, and run day end processing, none of my lot numbers are available to use on Sales Orders / Shipment…
  • Connecting SO_OrderTierDist to SO_InvoiceTierDist in Crystal

    Has anyone had any luck connecting these two tables together? I am trying to create a daily sales report that has profit based on the lot number. The problem I am running into is the OrderTierDist clears when the sales order is being invoiced and pushes…