• Emailing Statement of Account in Sage 300 Version 2023

    We have just upgraded our client to Sage 300 Version 2023 from 2016. In version 2016, when you email statements, it does so through Outlook leaving a copy in the sent items. When we upgraded to 2023, it uses SMTP. Is there any setting we can change…
  • 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…
  • Work Order Module

    I'm new to Sage. I'm wondering if there is a module for Sage 300 that allows one to create a work order, track its progress, and interface with the inventory system so that when a tech needs a part for a repair, it can be scanned and allocated to that…
  • Why does ROE not bring in data for box 15c for some employees, but does for others?

    I've been working with Sage 300 Canadian Payroll for over a decade and this is the first I have seen this. When generating ROE for a particular employee, usually it will auto populate Box 15C with all their pay periods starting at the most recent one…
  • Sage 300 Erp 2023 as a published app very slow

    Works fine when using on a terminal server but xery slow if run a published app from sale ŹER
  • 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…
  • Slow printing packing list in Sage 300 2022

    We are using Order entry screen to assign a shipment and print packing list. After upgrading from 2019 to 2022 time needed to print packing list more than doubled and now takes about 40 seconds for each packing list. No difference if it is print directly…
  • Why does Sage 300 not seem to convert the unit weight when clearly using a UOM that is different than the stocking UOM?

    Sage 300 OE module has 3 units of measure per line. A pricing UOM, invoice UOM and costing UOM. However it does not have a weight UOM, so it is taking the unit weight (which is for the default stocking unit of measure, and not using the conversion factor…
  • 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.
  • Lot Number Finder

    I just recently upgraded a Customer from 2017 to 2021. I can no longer see lot number optional fields in the I/C Lot number finder, nor can I select them. Is that a feature that has been removed or am I doing something wrong? Much thanks in advance…
  • Vendor Details

    My SAGE 300 is setup the way every time we enter receipt it will update vendor cost in Vendor Details. In general this is fine but lately we experiencing problem where PO’s are delivered after 3-4 moths and price is changing frequently, so old PO will…
  • Adjust a BOM during a transaction

    Is there a way to adjust a BOM during a transaction. My client has a BOM that can use substitute materials. We are creating versions of the BOM for normal customizations, like using 50% of one material and 50% of the other, but they can make many versions…
  • PJC work in progress report

    I'm trying to figure out the WIP report in Sage. The report in PJC doesn't give me what I would consider to be a proper balance even when looking at the totals in the contract maintenance screen. My client and I have run this on live data and on the sample…
  • SAGE 300 PROJECTS AND JOB COSTING INTERGRATION WITH MICROSOFT PROJECTS

    Where can I find a document or a user guide on how to integrate Sage 300 2020 PJC and Microsoft Projects 2016. Please advice
  • 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…
  • Good Template for Importing Files into "Asset Management - Asset Acquisition"

    Merry Christmas Everybody, Before I left my office for Christmas Eve Thursday night, I was struggling with the very clumsy and unwieldy asset acquisition data entry process of the norming asset management module of our Sage 300 system. I had noticed…
  • Item Finder displays wrong Qty On Hand - Optional Field.

    Hello all. We believe we have found an issue with the Item Finder Qty on Hand field. When the user applies a filter using an Optional Field, the finder will display the wrong qty on hand. For example, if we filter for "Item Number" starts with 20149…
  • 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 ERROR the field [bkenth].[totfuncamt] contains more decimals than the currency code [AED/INR etc] allows

    While Applying a Prepayment to AP Invoices or Reversing any Payment entry/ Bank Deposits the system is giving this error. The Decimal points are already 2 in the currency master. while creating new transactions it is accepting but while applying it or…
  • 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…
  • Sage 300 2019 - OE Committed Qty allowed even when there is no Qty Available

    My client is using Sage 300 2019 PU4. Allow Negative Inventory Level in IC setup is NOT selected. Some users are able enter the Qty Committed for an item for example, ‘N0006’ and insert and carry on with the order onto the next order line without…
  • OE Label Printing Very Slow

    I just started to use the label printing feature in Sage 300 2020 Update 2 and it is very slow. My last test took almost 6 minutes to tell me that there were no labels needed to be printed. Is there any way to speed this up?
  • Weird Sage 300 US payroll rounding

    Sage 300 2019 PU2 + UP73A PU18 + UT73G PU1 We found a rounding error in the payroll pre-check register. A time card was entered for 15 hours @ 62.2743 = 934.1145 Normal round would give 934.11 but the pre-check register shows to 934.12 Yeah I…
  • Changing Stocking Unit of Measure

    Is there anything we should look out for when we change the stocking unit of measure? We some items that have a couple of conversion factors and the items are used in BOMs. To be careful should I issue out all the inventory, change the stocking unit…