Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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.
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…
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?
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?
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?
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.
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.
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…
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…
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…
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…
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: …
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,
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…
. 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…
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…
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
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…
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…
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.
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…
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?
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
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…