Sage 300

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…

i want to know the status of my 3rd period in 2014 is locked or not i had tried using code below Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI…

I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.

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, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…

Hi, I have encounter this error when add the OCX screen into Visual Studio window form, using .Net Framework 3.5. Error: Failed to import the ActiveX Control. Please ensure it is properly registered Any solution to this?

Every time I try to "Get Info" from UI Info for PO Entry (PO1210) it crashes. I've tried several different machines and the same thing every time. I've tried uninstall and reinstalling. No luck. Sage 300 2017 PU5

Hi, The client is using a custom form (not written by me). In Inventory Control, when printing labels from 'Received' or 'On File' the quantities are never what is specified - except when it is one quantity. The out put for multiple quantities is…

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…

I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters. The report DOES NOT…

Hi, There is a rounding error (1981.11 to 1981 for example) when cheques are printed off (July 1 Tax table ). The pre-cheque payroll register too displays this behaviour. And, the amount in words at the top of the cheque shows the right amount…

Hi, I have modified popor04 and am running it successfully on my computer on the clients data. When I run it on the clients server, I get the following: I have no parameters in the form. I always have to enter a 0 and then it prints. Haven't…

HI, I have a .AVB file and I want to see the contents of this particular file. After a lot of research I came to know its a macro file and still I m new to sage so doesn't know how to open this file to view its contents. Any help is really appreciated…

Hi, I'm developing an Order Entry macro, by using "AccpacOE1100UICtrl" object. This macro should be able to add an item and delete the item if the user selects a certain ship-to location. I'm able to add the item, but when deleting the item, the…

Customer is running Sage 300 2014, Update 2. They also use GIMS. We customized a GIMS report for them a while back and it worked fine for all users until the upgrade. Part of the customization is that we added a criteria for Style - and Style is defined…

I am trying to write a Crystal Report on Internal usage. The client wants it a certain format (different from Stock transactions Inquiry) hence the effort. I am not able to get my starting inventory formula accurately. Does anyone have some ideas on…

Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…

Greetings, I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message. Has anyone…

Hi, we are using Sage ERP Accpac 500 (Version 6.0A), i need to Track Users Activity . how create the invoice, how post it how print the check i konw the user id is saved in the Dbase files but through the application , does any one know how…

Hi, Can I add the user name who is printing the form on the form? Thank you!

Hi Accpac Gurus, Development Environment: Windows 7, 32bit, visual Studio 2005 VC++, Accpac & SDK 2014 MS SQL Server 2008 Client Environment: Windows 8, 64bit, Sage 300 ERP 2014, MS SQL Server 2008 I am trying to upgrade one of my custom module (Add-on…

Hello, I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) The field is currently showing six decimal places on items related to labour (i.e…

Can anyone tell me advantage or disadvantage of using one over the other? My scenario is that I am writing a C# dll for an external .Net application I am writing. Currently I started out using Accpac.Advantage but am unsure if that is the best approach…