Sage 300

Day End gives this error message Batch. Record has been modified by another program No RVSPY made; SQL Server service restarted

I have a macro v2018 that makes an OE Order and Prepayment it seems to work fine and prepayment goes to AR Receipt Batch and you can post the Receipt batch when I run data integrity in OE I get an error like : Order Prepayment: 2402630 <<ORDUNIQ…

We have a client running 200 2021 with Product update 1. On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change. Anyone have any sugeestions as to how to proceed.

Hi All What a different Table ICIVAL and ICHIST? The condition like this I have Shipment from IC Shipment, and have 20 detail item. When i look from ICHIST for this shipment, have 20 detail item, but when i look from ICIVAL, that data only have…

This has been running fine since 2016 only yesterday the files server run into a problem after running windows updates.The Pos is invoicing fine with out any problems even in the workstation The only problem is in the admin.exe file.I tried greating…

Am gettingthe below errors What might cause this to happen? Wjhat can i do to fix this? Purchase Order Line: PO0311816, 10, 700511-IRGP E: Item number does not exist. E: Unit of measure EA does not exist. Purchase Order Line: PO0311816, 14, 9533266…

My debits and credits equal but the GL total is out of balance and showing !!. Will File Doctor solve this?

I have just upgraded my client who has 3 databases on the server and I am having a problem with 1 of them. After activating Sales Analysis and OpsInquiry, I receive an error: Load of System Manager roto events. Load of System Manager roto events…

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…

During the year 2019 the pricing method was changed from 4 decimal places to 2. At year end the trial balance was out of balance by $0.02. How can this be fixed?

Hello, I have a client, where in what appears to be random cases, some lines of a PO receipts are posting, writing data to IC Location Details, but not to PO History or IC History. In the case I am studying, the first line wrote fine to POHSTH and ICHIST…

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

Invoice Detail, Database error (operation=INSERT, error=2) Posting failed, You must enter the invoice again

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…

Running Sage 300 Payroll 2017, when I loaded data into a machine used as a backup, I received the error..Damaged Data. Company Profile. Table CSCOM already exists. Cannot activate Common Services data. The backup works on 3 other machines and my main…

Have a situation where IC Item Finder (on any screen) shows 2 lines for 1 item If I do a CONTAINS 'dill' on Description field I get several items with one item showing 2 lines that go to same record SQL database only shows one item, reindexed all…

I have several entries in several different batches that error out and make an error batch with the message Currency conversion failed. Source=CAD, Functional=, Rate date=0000-00-00, Rate operator=M, and Rate=1.000000 anyone seen this before …

Hi, Data integrity report error - account - Inconsistent data. The sort code of the assigned account group is not the same as the stored sort code in the account record. I have attached the screenshot and the application version is SAGE 300 2014…

Currently running Sage 300 2019 and have noticed a number of errors during the data integrity check. Balance due $ is not equal to the sum of open documents for vendor. Restoration of data is not an option as the errors go a long ways back before my time…

Hi, My client is using Sage 300 2016. They did a year end about a month ago which ended with the following message (I see this in restart maintenance): Create New Year processing did not complete. Run the Create New Year program again in order to…

The above error in the subject comes up when trying to generate stock count sheet in SAGE 300

Lately we have been seeing more examples of seeing a negative qty on Sales order when looking at Location Details. IC Integrity check will fix it eventually, but in the mean time it can screw up a few things and I'm just trying to pin down where/why it…

Hi After completing an upgrade to sage 300 2017 Sp2 I went to assign Visual process flows to a user and notice all the user profiles and authorisations are not visible. I can't create new user records, the user profile report still runs and I can…

I was hoping to find out what the link is between an AP check (In AP) and a check in bank rec (originating from AP). We have a corrupted record that is preventing us from reversing (voiding) a vendor check through bank rec. We are seeing all checks except…

Hello Guys, one of Our Client is currently getting the below error message whenever they click in GL Batch List Description: Batch. Database error (operation=SELECT, error=824). [Microsoft][SQL Server Native Client 10.0][SQL Server]SQL Server detected…