Sage 300

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…

We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…

I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?

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, We noticed just yesterday that some of users were in the Other tab instead of the LanPak tab in the Current Users window. Although the system still works and the users can still access Sage when they were logged in oni the Other tab, what is the…

Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…

How do I suppress inactive accounts in FR I have tried ACTIVESW=1 in column B but it does not suppress the account # in column A

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…

how to retrieve vendor number values ​​on the PO Order screen using macros Thanks,

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 have a custom OE1100 screen User will ship some lines and make an invoice and of the course the question to print forms will pop up. After views settle I want to set qtyordered=0 for any open lines I know the standard _onrecordchanged events;…

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 ?

When the user is login and the Task Scheduler fired up, the posting in SAGE is successful. But when the user is Signed Out and Task Scheduler fire up. We received an error: Error: External component has thrown an exception.. Inner: . Full: System…

I have a client wanting to use the free BI reports provided by Sage called the Customer Aged Trial Balance S300-SQL(C4-0-5) or the Detailed AR Aged Trial Balance S300-SQL(C133-0-4) Unfortunately, both aging reports cut off by Doc Date and for…

Deleted AP "Cannot post to a future year" error batch generated by the system (though a new fiscal year was already open). The entry was generated when cheque payment was posted. Now, AP subledger doesn't balance with GL. What is the best solution…

Hi I need to modify the Purchase Order Invoice Entry to allow to input many Receipt at once from a copy paste The user would open the form, input Invoice Number and VendorNumber manually Then he would click on a new button to be added to the form…

Sage 300 2019 For modules where the user has no authorization for can the empty module folder be removed from their desktop?

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…

Have an RDS situation where FR interactively is very slow starting Excel but fast as usual executing FR report But if you record a macro and run the macro it is fast by a factor of 5 to 10 literally macro runs in 8 seconds and Sage screen runs in…

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…