Browse By Tags

  • Importing and Exporting Purchase Orders in PO Module

    FormerMember
    FormerMember
    I am in need of a purchase order import template. I have tried using the help section to create one with no luck. Our consultant doesn't have one and I cannot work backwards by exporting because I get the following error: Can someone please send me…
  • Validate PO Invoice with Webservice

    Does anyone here have any idea how to validate a PO Invoice using a webservice, or other similar method?
  • PO archive and upgrade?

    Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…
  • Purchasing Lead Time calculation

    Is there a way to automatically calculate the lead time on purchase order and update the calculation field in the Reorder lead time on the product screen purchasing tab - OFS on screen ITM. The field is needed to use the calculation of other reordering…
  • Purchasing Module hangs on Configuring Database on Win10 machine

    We have one user of the Purchasing Module POIV that gets the error Not Responding when opening the program. It hangs on configuring database. This doesn't happen with our Win7 users only the Win10 user. We are using Sage300CRE version 16.1. Any ideas…
  • How to handle a Complimentary (sic) / Complementary Invoice that has been keyed with incorrect value?

    Update 9, patch level 8. What's the best way to handle a Complementary Invoice that has been keyed with incorrect value? The complementary invoice is for a stock receipt. The stock has already shipped and is no longer on hand. The complementary…
  • Demand Horizon for "Purchased" Products

    In the product-site record there is a demand horizon. From my understanding, anything before that time MRP considers Firm SOs and anything after is Firm SOs and Forecast Demand. For me this makes sense for the products that are manufactured What…
  • Purchase Order for Tools, Supplies, and Non-Stock Items

    I want to know what is the right way to make purchase orders (or equivalent entry) for items that aren't going to be sold like tools, equipment, machine, and supplies. Is a PO the correct entry for this? I do not think it is appropriate to receive these…
  • How to Amend Products Showing as RED on Product List

    As we all know, products which show on red on the main product list, appear red as the total amount in stock is less than the Re-Order Level. We are finding that it is a little hard for us to see which goods need to be ordered, as the above does not…
  • Invoice hung up between PO and AP due to wrong invoice # being used and the month has been closed

    Our clerk entered the wrong invoice number in Purchasing when receipting the invoice. He posted invoices to AP, and that is when he realized he used the wrong invoice number. Instead of deleting the invoice in AP, unposting it in PO, and rerecieving it…
  • Entry of purchasing invoice

    I'm wondering if there is a way to link a purchase invoice to a receipt after the invoice has already been entered. Since the receipt is done using the purchase order, can the invoice be entered using the purchase order and then manually or automatically…
  • How to UNVALIDATE Purchase Return

    How can I unvalidate a purchase return. The Gen CR on the grid needs to read "YES"
  • Seeking solution -- Purchasing error "System.ServiceModel.Channels.ServiceChannel, cannot be used for communications because it is in the Faulted state.

    FormerMember
    FormerMember
    We have been getting this error for months randomly, the solution thus far has been to exit Sage completely and relaunch. After a number of attempts with Sage support we've nearly given up, this only occurs in Purchasing.
  • Table: STOCK[STO] Key: #### No current records When deleting a Subcontract Order

    I am trying to delete a subcon record. I am getting the following error. Table: STOCK[STO] Key: #### No current records Nothing has been done against the subcon.
  • PO - Goods Receipt Reversal

    Hello All, A Pleasant day with you all. I was planning to delete or reverse a newly created Goods Receipt against a Purchase Order. However, upon doing so, I am getting the following error. Please help as I have a very limited knowledge when it comes…
  • Closing intersite PO

    We have intersite POs that need to be closed. But we get the following error. The PO is a sales order->delivery-> and an invoice. But it still gives this error.
  • Manage the by-products in the sub-contracting BOMs (GESBODS function) as in the production BOMs (GESBODP function).

    Example : subcontract order, receipt and purchasing invoice with an additional by-product component.
  • How Can I find deleted POs? Maybe SQL?What would the script be?

    Can someone advise if it is possible to find deleted POs? We are missing some documents that we know exist but cannot be found. It is possible that they might have been deleted by the users. Can we run a script in SQL manager?
  • Purchase Metrics

    Trying to get a handle on purchase cost over time for our Raw Materials. I cannot find a report or dashboard for this type of information. What am I missing. How are others solving this issue? Noel
  • Need reference for Inventory Module/Cost Accounting in Sage 100

    We are considering purchasing this module to use for a new manufacturing division that is schedule to open soon. I was hoping to get some advice on how the installation went well or poorly for your organization and whether you would recommend the purchase…
  • What are the benefits of entering PO/commitment in PO module vs JC or Project Management?

    PO Module Question
  • Complementary invoice – numerous pop-warning messages if period for associated original invoice is closed.

    In the Purchasing>Invoices>Invoice Control function, when processing a complementary (CMP) invoice against an original product invoice that was posted in a previous period that has already been closed, the system gives a pop-up message advising that the…
  • 3rd Party Procurement Software that integrates with Sage 300 CRE?

    Does anyone have experience with any 3rd Party Procurement Software that integrates with Sage 300 CRE? We have test Sage's Procurement Module and found it lacking several key features that we need. We do not currently manage an inventory. Our purchases…
  • Commitments to Multiple GL Periods on One Purchase Order

    Is it possible to have commitments made to multiple GL periods on ONE purchase order document?
  • MRP for Raw Materials

    My company recently migrated to X3 v7. I would like to utilize the MRP module for raw material replenishment and would prefer a simple min/max process. It doesn't seem that the MRP module functions with customary min/max logic. I have been trying to…