• Purchase Order Records Already Exists

    "Purchase Order. Record Already Exists - next number field is to be updated in PO setup -Options- Documents and Next Number. Client keeps jamming up the numbers by manual entry of the field - has someone built a logic around to deny manual input of…
  • Stock date of existing Lot number not updating at the time of Receipt !

    Hi, If we receive an item to an existing Lot, Why the stock date and Expiry dates are not updating automatically to the date of PO Receipt. ? This will make an issue of Auto-allocation in OE, system will take this Lot ,even it contains the latest…
  • Error message when post Invoices: Invoice Batch Attempt to perform Record Update without security authorization.

    Hello Team, I try to post the Invoice, but receive the following error message: Invoice Batch Attempt to perform Record Update without security authorization. Could you clarify how to fix this error message? What settings I should do?
  • Item Valuation Doesn't match with General Ledger

    Hello, Which is the correct procedure of comparing current Inventory value with General ledger? Item valuation by ''Transaction cost'' is matching with GL. But, ''Location details cost'' not matching with GL.
  • Can unshipped lines be omitted from Shipment and Invoice tables

    Can Sage300 order entry be prevented from copying the unshipped lines of an order onto the shipment and thence to the invoice tables, while still retaining backorder quantities on the orders? We have a situation where each order includes many products…
  • Sage300 Order Entry - maximum number of lines per invoice

    Does anyone know if there is a maximum number of shipments that can be on a single invoice, or maximum number of lines on a shipment.?
  • Sage 300 2019 with PU4 integrated with Sage CRM 2019 R2

    Client with the configuration above is reporting an issue in the Sage 300 Order Entry (Not Web based) The error is: "Unknown RSCID used in CRMReportOrder. (1158 oeordg1.CPP)." "Posting failed. You must enter the shipment again" This happened…
  • Intermittent issue - PO Invoice from multiple receipts,splits into multiple invoices in AP

    Intermittent. Job related PO Invoice for multiple receipts entered using drop down, the invoice appears to be OK but after day end the AP Invoices are split by receipt number with the same Inv#. This creates an Error batch in AP. V 2017 -PU6; cannot replicate…
  • Errors on Posting

    Client receiving errors in posting status on worksheet. stocktake does get posted and adjustment batch posted. But on post reconciliation, status is Errors in Posting
  • Serial Number Issue

    A little background to start off with. We use Large Hydraulic Cylinders and track them using our I/c serial numbers module. When we take it off a truck to be rebuilt we assign it a COXXXXXXX (Core) item number. Once it is Rebuilt we adjust out the Core…
  • Using PO for Assets and Expense Items

    What is the best way to use Purchase Orders for Asset and Expense Item purchases?
  • Requisition Entry

    What is the maximum number of lines that can be entered in requisition entry?
  • Credit Card Payment made with Sage Payment Solutions in Sage 300 to Wrong invoice

    A credit card payment was entered, posted to the correct customer, but to the wrong invoice. Is there a way to fix this. We attempted to reverse the entry, but since it was made with Sage Payment Solutions this was not allowed.
  • Finding Missed Preauth in Order Entry

    When the terms are credit card all orders in order entry should be pre authorized. Is there a way to find orders that should have a pre authorization and do not?
  • OE invoices not showing prepayments

    If I enter an order in OE and enter a prepayment and post the order, when I later invoice the order the prepayment is not shown against the invoice, but only on the right hand side of the invoice totals as an order prepayment. If I enter the prepayment…
  • Bank Rec

    We are doing a bank rec and the amount of deposits outstanding is incorrect. When we take a look at the outstanding deposits they are only $13,000, but the report shows $41,000. The outstanding checks are correct. Any ideas?
  • How to process a drop ship in Sage 300 ERP

    What is proper way to process a drop ship in Sage 300 ERP? I was told from their support that you process that in Purchase Order, but how do you bill the customer without deducting from the Inventory Control module? What would be the proper steps…