• Inventory Valuation Report and Available Quantity

    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…
  • Report that breaks out allocated cost

    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…
  • "[ProvideX][ODBC Driver][FILEIO]No Data Found" when refreshing Microsoft Query results in Excel against table MP_04SuppliesAndDemands. Worked until recently.

    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…
  • Crystal Graph Sales History by Period

    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.…
  • Crystal 2016: GS1-128 Symbology: FNC1

    Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …
  • Kit items on reorder report

    Sage 100 ver 2015 The items within the kit are included in the inventory sales history, but not included in the Inventory Reorder Report as either qty sold or qty issued. How do we get these sales to be included on the reorder report?