• Accpac 5.5a

    Hi, we currently are using AccPac 5.5a version and we would like to see what options we have to move to newer versions. We run a small business and AccPac 5.5a is perfect for us but do realize its time to upgrade. Currently our systems run on Windows…
  • Banking Details Table

    Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…
  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…
  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…
  • old company data lost during creating a new company

    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…
  • Migration From Sage Accpac ERP 5.3 with Pervasive 8 to Sage 300 ERP 2018 with SQL Server 2017

    I have a Sage Accpac ERP 5.3 using Pervasive 8 but we want to migrate to Sage 300 ERP 2018 using SQL Server 2017 someone knows the best way and best pratices to do it please
  • Sage 300 2018 Error on export button

    Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…
  • Where in the AOM can I find flag for "fiscal period" locked or unlocked?

    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…
  • Color AP check logo printing in black and white through RDP

    We have a client on Sage 300 2014. They have macs they use to RDP into a server to run Sage. A recent update to RDP causes the AP check logo, which is Red, to print in black and white. Has anyone seen an issue like this before?
  • Importing «Receipt» data from external...

    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…
  • Can not execute macro syntax

    I create a user in ACCPAC. But i can't execute my macro syntax. But if i change the user to Admin, its working fine. Can anyone help me? How to configure the new user, so i can execute the syntax
  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…
  • get Field value in macro into a variable Vb.net.

    I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…
  • Why after changing the flag on a AP batch to ready to post, transaction posted from PO keeps updating same batch ?

    We have configured our system to do all costing during posting. and with multiple departments using the PO module we'd like to set a AP batch as ready to post to avoid modification. Now what we have notice that even after setting AP batch as ready…
  • Is Sage 300 ERP 21014 compatible with SQL Server 2016?

    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,
  • Removing SSL 3.0 protocol - Impact on Sage and SQL Server 2012

    Hi, The client is running on Sage 300 ERP V 2016 - SQL Server 2012 - Both servers running on Windows Server 2012 R2. One of my client is asking if they would be any impact for Sage 300 if on the SQL server they would drop the protocol SSL 3.0? Thanks…
  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?
  • How many MSSQL user CAL licenses should we buy?

    We have a new installed sage 300 2017 with MSSQL server. I'm confused on how many MSSQL user CAL licenses we should buy. We have 5 staffs using the sage 300 (i.e. 5 Sage 300 logon accounts). But it seems that only one username needed in MSSQL server for…
  • Inventory Adjustments

    Is there a way to upload multiple lines to adjust or write off inventory via a template? I exported a prior entry. Can I change the data and import it back into I/C Adjustments?
  • Database error (operation=get, error= 16389) - Sage 300 Erp

    Occurs when opening a new batch in ap and when opening po module. please help.. have been working before but the error has persisted for the past 1 week to all my clients .
  • Workstation install on OS 10.6.8 and Windows 10?

    We are currently going through a conversion from Accpac (DOS ver. 6.5) to Sage 300 2016. We have the windows version of Sage 300 ERP 2016 installed on: Server: Windows 2012 R2 DB: MS SQL 2012 Workstations: Windows 7 machines (32-bit) I want…
  • Is Sage 300 2016 compatible with Windows 2003 32bit OS at the workstation level?

    I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…
  • How to customize AR/AP Aging?

    Hi Expert, I'm very new with Sage. Can you please give me a hind to extract AR/AP aging? Any query would be appreciated. Rgds, Sokkorn
  • installation 2016 Server 2008

    We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions? We're also looking at the possibility of using server 2016. Is there any chance…