• Import AP Invoice from own excel file failed

    Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…
  • Sage Order Entry Import by Excel

    Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.
  • Modifying existing Orders from Order Entry via import

    Hello! So I've been able to successfully import orders via the import function. I'm wondering though, if I want to make changes to orders already in there, is it also possible via the import function? As of now it will give me an error saying the…
  • PJC Unit Maintenance Update Descriptions from Excel Spreadsheet

    Is there any way to update my unit descriptions from an excel spreadsheet? I tried an import but apparently there is no insert/update for that import, just insert. Would a macro be the only way?
  • Cannot continue verification, a database error occured (error=60001).

    When running Verify in Database Setup for a System Database, it returns the following error message: ARADV: Table does not exist. Cannot continue verification, a database error occured (error=60001). How do we resolve this error?
  • IC Item Change Error

    Getting an error 127 every time a client tries an item combine function. I believe the 127 indicates a duplicated field but I cannot find anything. RVSpy is giving no clues. Any ideas for where to look?
  • List of invoice credits

    Hello, We need to pull a list of invoice credits for our auditors. We need the customer key, document number, date and amount. Which tables do we need to use to extract this information? Ty.
  • Items cost

    Hi, Is there a table that contains the latest (current) cost by item/location? We are looking into ICIVAL but it contains all transactions that have been processed for each item. Ty.
  • Importing long list of items into O/E

    Hi Sage City, I work for a company that sells imagery to companies that print and frame, as such our inventory is huge, we have upwards of 50,000 different items. Customers will order upwards of 2000 at a time which means our sales team is forced to…
  • item at location does not match the sum of the lot quantities on order

    We have a customer that has recently upgraded to Sage 300 2021. They encountered this problem entering a sales shipment and trying to apply Lot Numbers to it. Although there was sufficient quantity available if they looked in either location details or…
  • IC Item Number Change Import File Issue

    When trying to use an import file for IC Number change we get the following errors before it starts trying(and failing) to read the actual item numbers. We've used this functionality in the past with no problems. Even tried an old import file and still…
  • Database Error (Operation = GET-LE, Error = 0) [Microsoft][SQL Server Native Client 11.0] Communication link Failure ....

    The error above appeared on one workstation only at a client when posting a Purchase Order. This workstation was fine for several months after the upgrade They were recently upgraded to Sage 300 v2021 PU2. They are also integrated with CRM 2021 if that…
  • CREDIT NOTE IMPORT requiring credit note number?

    Is there a way to import an OE credit note without specifying the CRDNUMBER? I'd like the system to assign the next available number so I'm not duplicating and causing an issue with a manually entered one. When trying to import I'm getting an error: …
  • ec=60256 during database copy

    We care trying to copy the production database to a new test database and receive a database error (ec=60256). Has anyone seen this error and how do we resolve. Thanks,
  • 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…
  • On order quantities linger after an upgrade

    . The client is noticing quite a lot of this. This is from the IC location details screen Sage 300 2020 Perpetual license. The screen shows 10 on hand 44 on sales order. However, 44 are not on sales order. There are only 24 total on sales order. I…
  • Item Invalid characters put to field 'Item Number'.

    Description: Item Invalid characters put to field 'Item Number'. Source: 22:05:05 I know that I have an invalid character added to the item number field as a result of using Item Number Change Utility. How do I find these items? I am lost. Just FYI…
  • anybody seen messages like this dayend IC from PJC

    IC Shipment from PJC Mat Usage Day End posting error I know the line/item number it is sick on Transaction Number cannot be blank Transref should not be zero, should be Transnum
  • Error during retrieve from Sage 300 to Sales Analysis

    During an end of month retrieve into SA the client is getting the following error message: [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert duplicate key row in object 'dbo.UXARINVHO' with unique index 'UXARINVHO_idx0'. The duplicate…
  • Import a receipt against multiple PO's

    Has anyone managed to make this work? I created an import template for a PO receipt, based on an exported record from Sage 300. The "MULTIPOR" field was set to True, however that box wasn't checked after import and the receipt wasn't logged against the…
  • IC Item import error [Item Attempt to change read-only field 'Structure code']

    Hello, As per subject, it pop-up error message and i have to manually delete off from my excel and continue import. I have 130k of new items and i do not wish to do the deletion part. Please help. Sage 300 2016 Advance PU 5.
  • Cleaning up old I/C optional fields

    We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…
  • Import Orders

    I have searched the help in my Sage 300 and in this forum and cannot find instructions on how to import a batch of sales orders. Can anyone point me in the right direction please?
  • Sage 300 2016 with SQL Server 2017

    Does Sage 300 2016 work with SQL Server 2017? I have a client that does not want to upgrade their Sage 300, but has other SQL based software that wants to upgrade to SQL Server 2017. Is anyone running Sage 300 2016 with SQL Server 2017? TIA
  • IC Item Pricing export to import into another program.

    Hi, I asked this question 2 years ago but am asking again in hopes there is now a solution or third party vendor that has created a solution. I am trying to extract prices from Inventory Control for a client to import into another software package so…