Sage 300

Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…

Is there a way to disable the forcing of capital letters in the PO no. field within order entry? We have a partner who sends us PO numbers that contain both capital and lowercase letters. When we transmit through EDI back to them the information is…

Hi Support, we have a client facing network issues so Sage became very slow. Initial workstation setup had both program files and data on the server. i tried to install Programs on local machine and data on the server however it does not install…

I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…

Hi, The OE shipment entry is not generating GL entries if the invoice tick box is unselected. If Invoice option got selected, then invoice entry and GL entries are being posted to respective modules. How do I set the system to allow to post the GL entry…

We have «Sage 300 ERP AccPac v2014». We export IBM Notes data in XML to TransAcc module. I must modify le doctype for actual data, they are considered as «Prepayment», and I must change doctype for «Receipt». Here the sample of data: [code]<?xml version…

An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016. Is Sage 300 ERP 2014 compatible with SQL Server 2016? Thanks,

Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…

Hi, We want to upgrade one of our Sage databases to Sage 2017, while maintaining the other databases temporarily on Sage 300 ERP 6.0. The network will be same but different application and database servers. Will there be any major issues? Priti

If I set up a new company with an Oldest Fiscal Year 2014 and then copy an existing company (using Tairox Copy company module) with a Oldest Fiscal Year of 2015, does the new company fiscal year setting get copied over? Is there a way to retain the fiscal…

Sage 300 2017, MSSQL Client daily dump data, as a backup. last week, they dumped data, for strange reason, dumped data only has data up to end of 2016. No 2017 info. any ideas? thanks!

Our client runs Sage 300 Version 2016 and have multi locations where they sell from. They want Orders, Shipments and Invoices to have different prefixes as per the locations they are sold from. Is this achievable? All responses will be highly appreciated…

One of my clients is looking at using SQL replication for a satellite office. What they want to do is have the satellite office work against the replicated db and then sync it to the live database. I have heard of using replication as a means to offload…

Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…

Can someone please tell me what table/column will give me the current fiscal period for a company?

Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

I deployed Sage 300 2016 Web Deployment and were able to login from client computers without "Enable Application Security" box being enabled in Database Setup Utility. However, after enabling this option, I started getting the warning message "Session…

Hi All, I am new for ACCPAC .Net APIs, I want to import customer data into Sage 300 using APIs, can anyone help or give me some hint for this? Or share some sample code and data dictionary, please? Thanks for your help

Hello, I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…

We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

Can anyone explain to me what happened after an item 0001 merged into item 0002 ? What happened to item 0001 old receipt, PO etc? After clicking the POST button in Item Number Change, a message box pop up to ask back up database, is that normal? Thank…

We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty. How do I get SAGE to automatically sync the Bin and IC Qty? Doing each transaction manually takes way to long. Thanks

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?

Hi, We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time. Any clue?