Browse By Tags

  • Optional Field Values

    I had set up some optional field values in common services that contained an apostrophe and realized it created issues. I inserted new values but now cannot delete the old ones. The old values are not used or linked to any items. I don't get an error…
  • Export select criteria not working

    When doing any export, that works fine, However when I try and use the Select criteria option the option to select anything is empty and i get the following message - "Navigation to webpage was cancelled" / I did not know that this was trying to even…
  • Shipment Detail Lot Number. Record has been modified by another program

    Sage300 v6.2, Customer use v6.2 over 8 years ago. This message is the first time. Customer shipped Item with Lot in a Order Entry > Sales Order. Then, Customer want to clear shipment in Shipment Entry(before Invoice). There is 1 item with 2 lot…
  • System behaviour- Security Groups

    Just wondering if anyone has experienced the same issue. We have put in credit control approval alerts for our clients, and the only way to override it when the limit has been exceeded when performing Order Entry or Shipping, is for the authoriser to…
  • Sage 300 2019 P/O Forms Purchase Orders not printing completed PO

    Hi Everyone, I am currently trying to edit the report popor01.rpt because we are unable to print reports once they are completed (or so I think). Basically any PO that is classified as not completed prints completely fine. But if the PO is marked as completed…
  • Unable to add 6th Company Database in Sage 300 2022 Advanced Edition Database Setup

    Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…
  • Sage 300 2023: Issue with Expense Account Not Updating in AP Invoices

    We're utilizing Sage 300 2023. After generating and receiving a Purchase Order (PO), along with creating the associated Accounts Payable (AP) invoice and posting it to the General Ledger (GL), we've noticed that the expense account remains unaffected…
  • 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…
  • Sage300 Virtual Process Flow for WebScreen

    Anybody know how Virtual Process Flow work on WebScreen?
  • 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…
  • Error "AR68ARRD: Critical Error: [1212] invalid working directory path." sage 300 v2023 (Account code change)

    Getting this error (AR68ARRD: Critical Error: [1212] invalid working directory path.) when trying to run Account code change. Tried reinstalling still not working.
  • Changing decimal places back and forth?

    If the decimal places in a currency in Common Services > Currency Codes > was changed from 2 decimals to 3 decimals. Can this be reversed back to 2 decimals? If so, what are the options/procedures?
  • Calculation issues in exchange rate: AP Payment

    Making an AP Payment Entry to a foreign vendor in AUD. FJD is the local currency We are converting AUD 21,640 at a rate of 0.6620 per FJD The amount should be FJD 32,688.82 Sage300 calculated FJD 32,689.238 Is this because the decimal places are set…
  • Sage 300 2023 and Custom Crystal Report

    Failed to retrieve data from the database error is received from Sage user interface when running a custom report created when client bought sage. Report works on sage 2014, 2019, 2020 and 2022 environments but doesnt on 2023 version. At crystal level…
  • FR - Print Financial Statements - Run-time error '0' when trying to print to file

    Our client has the issue when trying to print their financial statements to file using the Print Financial Statements Icon (Sage 300 2023.4) The report generates no problem to Preview. We have Checked there are no other excel add-ins ticked…
  • Intelligence reporting module

    While working on the Bank reconciliation of previously January 2024 and lately February 2024, I am facing issues in the Sage Intelligence Reporting module. The bank statement figures do not match at all with the A/R and A/P entries. The Income statement…
  • 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…
  • Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • Sage 300 2024 w/PU1 Sage 300 Cannot Connect to Signon Manager - Resolution

    Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
  • I upgraded from 2023 to 2024 SAGE 300 but when I tried to login on the web screen, it gave me below error

    when i try to logging via http locally, any help please
  • Importing Production Quantities in Sage 300.

    Does anyone have any experience importing Production Quantities installed into Sage? We are looking to simplify the process of getting data from our production tracking timekeeping tool back into the Job cost report in Sage.
  • Order Confirmation Creation Time

    Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you
  • Emailing 1000's of invoices out or Sage in error

    I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…
  • User unable to promote company to Sage 300 Customer/Vendor

    Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …
  • Cost Codes last used

    Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?