• inventory maintenance Sage 100 standard cost field

    Which Sage 100 IM table contains the Standard Cost field? I need it for a Crystal report, but can't seem to locate it.
  • Has anyone had experience GetX?

    I have a customer that wants to the line comments in Purchase Order. They are thinking of buying GetX by xkzero. Does anyone have an opinions or experience that could give me some information on that idea? Thanks, Sidney Kay Wells
  • What is the field name in table

    Good Morning All, I'm trying to find out related field (ColumnName) in Table based on the SAGE screen. So in "AP Invoice History Inquiry" Screen there are following fields, Date Inv Entered $ amount invoiced Date Paid $ amount Paid …
  • Can you identify a sales order that was converted from a quote?

    We are trying to ID all quotes for a part number regardless if it is still a quote, a canceled quote or was converted to a sales order (Not entered directly as a sales order). Is there a field that identifies that the sales order was converted?
  • Interesting question regarding tracking materials from a client

    Client posed this question to me. Anyone aware of any already created add-ons to do something like this. Is there a method in Sage, or via an add-on, to track material exposure time or “out time”. Specifically, we would like to: Scan a barcode…
  • Historical Quantity On Hand for reporting purposes

    I am attempting to write a report that needs to list the on hand qty of an inventory item for a given closed period. The same information you see in the History tab of Item Maintenance/Inquiry. I need to be able to look back at period 1 of this year for…
  • Cross referencing WO Transaction numbers and batch numbers

    The Item Inquiry uses the Transaction Number as the Ref No for all Work Order transactions, but the Paperless Office Journal and Register Viewer uses the Journal No and Batch number. Does anyone know of an easy way to find out which Batch Number a particular…