Sage 300

Hi, May I know what is the maximum number of lines can be entered in O/E Shipment Entry? One of our client requested to do import into O/E Shipment Entry with big volume of data. Is it possible to import 20,000 lines of data into O/E Shipment Entry…

A customer reports that he gets problems importing "large" CSV files to the GL. In his case, "large" is around 150 rows. Is there a theoretical (or practical) limit to the number of rows? Breaking the entry into smaller number of rows probably not practical…

Hi guys, I'm experincing the below error when importing the inventory balance. Description: System error. Write down the message, error and source codes. Exit Sage ERP Accpac and Windows. Restart and retry the operation. For more information, see Appendix…

Hi, I am trying to extract prices from Inventory Control for a client to import into another software package so I would like to know the following please: The best way to extract item pricing information out of Sage 300 V2014 for a customer when…

Hi Day end does not complete. This is the error: PO Options.Record has been modified by another program Sage 300 2017.1 AP, AR, GL, PO Any suggestions would be welcome. Thanks

Dear Forums, I have tried to export order entry to excel both 2007 or 2000, however, the table Orders could not be exported. Do you know the reason? Thanks a lot.

We have a fairly new install who can't delete location records. Based on other info from here in Sage City, we ran the data integrity checker and found a number of "Uncosted transaction fields are not zero" errors. We'll re-run the integrity checker…

Customer is getting "unknown database error (operation =, error = 226) when trying to inactivate an item. I have a copy of their data locally and I do not get the error. Is this a likely a connectivity issue or something else going on? Thanks.

Is there any way to delete a category that has been setup incorrectly(set to misc cost type instead of equipment) after it has been added to a project. The project does have other costs posted so I can not set the project to estimate. The category itself…

Sage 300 ERP 2014 Advanced Edition Dear Support, The order of the serial transactions within the I/C Serial Number Inquiry looks sorted by DAYENDSEQ and ENTRYSEQ. However, the transactions initiated by I/C Module all are given the DAYENDSEQ = -1.…

This might be a stupid question, but for how long is the Purchase Order module history kept in Sage 300 Advanced? Is it the same as the period set up for the financial modules? Thank you

I need to download the HF22031340 for version 2014 to fix the good 'ol "the sum of ICIVAL.STKQTY for item XXX doesn't match ICILOC.QTYONHAND". It is listed on the partner portal but not in Sage City's list of hot fixes. The problem is when I try to download…

I want to update the average cost field on the location table, using an import. I can get other fields to update successfully, just not the average cost. This is for a data migration, so we're not in production as yet. The items in question do use…

Received day end error "Internal error. qtysub failed (2724 POPORZ1.C)". Restored all items from backup as instructed in ID 27409 and no luck. I did run RVSpy and there is an error at the end but it is not helpful to me. RvSpy error is: [d78.7ff…

I had to make a new post because someone else had this question yet marked it as answered even though there was no answer which makes all the emails stop. In order entry, we are having some orders drop the tax grid information. This then pushes into…

Hi All, Has anyone got a working import excel template for PJC Contracts? (FYI: I'm working in Sage 300 2012.) I've asked Sage but they have gone all quiet. I've tried the "export and build a template yourself route" but before I bash away more…

Hi, Does anyone know how Sage Accpac populate these 2 fields for MISC Charges in table OEAUDD? EXTCOSTH EXTCOSTS What we notice is, when Misc Charges is processed, these 2 fields are populated…

In the OE Finder window, there is a column labeled "Order Completed". Based on the Sage 300 v2014 AOM, an OE can have 5 COMPLETE field values: 1 = Incomplete/Not Included 2 = Incomplete/Included 3 = Complete/Not Included…

Greetings! Is the AUDTTIME field in say, APIBH, a datetime datatype field? I get a "Arithmetic overflow error converting expression to data type datetime" when trying to convert to local time.

I am investigating a situation where PJC does not respond when a user tries to delete a Contract. This is what happens: user clicks the delete button.. Message comes up that says Checking to see if Contract can be deleted. > Progress bar appears. >…

Hi, I'm planning to migrate a 5.6 Sage 300 ERP database that also runs the Sale Analysis module running on Pervasive to a 2014 MS-SQL database. Doing the migration for the "normal" modules is not a problem but I'm pretty sure there are special steps…

Version 6.2 PU1 Sage 300 ERP SQL 2012 I exported an I/C receipt, copy data to it from another spreadsheet and tried to import it back in as a new receipt (i.e. changed the sequence #) and am getting the following error: Description: System error.…

Hello, My company just start to use Sage 300. One question we meet is AP can retrieve or apply invoice with receipt exceeds PO and receipt value and quantity w/o warning and can go ahead. I think that should be security problem, anybody can give me a…

Hi, For a particular item while posting PO- Receipt transaction getting this below error Description: Internal error. cstp xIFO iloc mismatch error (2559 ICCSTP1.C). Source: 17:26:01 I ran data integrity it gave me this error for that item, Location…

I have 6.0 Version and would like to import Lot information for the first time. what is the best way to do that a part from PO receipt. Please help