Sage 300

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

Hi alll, I am trying to compile my module ID but having this error: makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found - Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…

Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

Hi All, In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table. But there is no entries for 3, 4, 5 in AOM. Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH? Thanks.

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

on OE/CN screen you fill in OE/Invoice number and Sage loads details I have certain customers where all OE/CN are on account, trouble is once you erase the OE Invoice# the screen details erase (can we stop this from happening?) I did not want to manually…

Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…

Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH") On "OnUIAppOpened()" Public WithEvents dsGLJEH As ACCPACDSControl Private…

Having problem with my SAGE 2020 (300 Premium) (Build 0) When I tried to add COM Components for example AP2100 (AccpacAP2100.AccpacAP2100UICtrl) and drag that to my Empty Project .NET (VB), it show's the error below (Failed to import the ActiveX…

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…

Hi, this is continuation from my question "Web SDK - generating multiple code type, and set fix Index.cshtml to be display" which is solved. Below is my screen. After user sign the signature pad, I want to 1. Save the signature (DONE) 2. add new…

I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro? I want to put it in the message box for the user.

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've recently installed 300c Webscreens which has a nice interface to it, albeit a bit limiting. The first thing everyone in the office asked, why do I have to have pages of records rather than being able to scroll through the entire list at a time…

I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.

A client wants to add the invoice number to the emails subject line not only the $COMPANY_NAME. Is there a way to incorporate the invoice number either on the subject line or the pdf name without doing it manually? Thank you,

We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…

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…

Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…

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

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