Sage 300

I have Windows Service which read some data from database then run macros to generate some reports as pdf files automatically (statement of account, Customer Aging....), when I run the service as "local system" the service can read the data from database…

I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…

Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…

Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…

I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears

I wrote a .NET application for a customer that created Orders/Purchase Orders. No problems with doing that. Now I need to update those Order/Purchase Orders. The problem that I am having is that I can't insert detail items where I want them to go. For…

Hi, Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…

In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes. Dim oRpt As AccpacCOMAPI.AccpacReport oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ") Dim oRptPrintSetup As AccpacCOMAPI.AccpacPrintSetup…

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.

I created a folder (new Object) that contain customized reports in Sage 300 premium (version 2016). When I run these reports Sage crash and closed with no error message. The reports I created work well in another PC. What can be the problem?

[sage300erp 2018] I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

would like to change the default text on the Purchase order entry screen to use the Arrival Date field, and call it Contract Date. can see where you can customized thee screen and add it to profile to add or remove a field but cannot see where you can…

I have a macro that exports Sage 300 financial reports to a file. When choosing the export type using CmdFRFileFormat( ngReportName ) 0 - Text Format, 1 - Excel Format, 2 - Excel Format with DrillDown information, if 1 or 2 is chosen, it exports as…

We are trying to customize our APCHK02 checks by added the information entered into the PO Number field on the A/P invoice entry screen. I am having difficulties locating and linking that field. Could someone please advise which table I can locate this…

Hi everyone: I have a macro that prints invoices to preview destination ; in past versions I was selecting what invoices are printed by changing the @Selection_criteria parameter and was able to print a particular invoice, group of invoices not in a…

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,

Our inventory Items have a structure "Style" (8 char)-"Colour" (5 Char)-"Size"-(3 Char) We want to separately show the segment description in a field on the invoice for the style and the colour. I have tried a little sub report for style connected…

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…

I have a macro that contains the GL2100 OCX (journal entry screen) When run on site on a particular computer the form pops up , there is no error message but the ocx does not show at all On the same computer, al macros that contain OCX have the…

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, Can I add the user name who is printing the form on the form? Thank you!

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…

Hello, I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) Each field is currently showing…