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.
We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300?
Comments…
I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…
Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me
ANY BODY HERE TO HELP OUT MY…
Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company
doesn't show any thing, but in sql server all data is avail able. kindly…
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…
I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report.
Any & all help is greatly…
Installed sage 2018 Premium with PU2 on a server. migrated a customer from sage accpac v6.0. Data upgraded fine but if i try and print any report to preview the UI container error comes on.
Windows Server 2016 with SQL Server 2014.
Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018.
When trying to print preview any default sage reports get error message.
Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines.
Appreciate if anyone has seen this before and has a solution…
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…
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,
I have searched the knowledgebase and i have not seen the answer.
The Print Financial Statement suddenly stopped working on my workstation. The other workstations are ok.
I get this error whenever I click "Print" and when Excel tries to run the report…
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…
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!
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…
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…
When we print a customer statement in the end of every month, those amount on the bottom do not match the total amount, it always missing one day. There is no current amount show. Is there any way we can change "1-30 days" to "0-30 day"?
Thanks so much…
