• Customization: How to get Sage User Id based on username provided

    Hi all,

    May I know is there any ways to get Sage User Id based on username provided?

    Many thanks.

  • Error "The customer or item tax class is not valid for this order." during OE Invoice Entry

    Hi All,

    I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…

  • My budget macro has been over written and I need to refresh it. I am using sage 300 2020.

    I need to replace my budget macro because it has been overwritten by an excel worksheet.  How do I do this?

  • Crystal Report Error

    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

  • class not registered C62A69F0-160C11CE-9E98-00AA00574A4F

    Good Day, our client upgraded there office from 32bit to 64bit.

    But now we are getting a class not registered error when trying to open macro to display user form.

    We have tried to reg edit the fm20.dll file and that also gave us an error.

    How else…

  • Financial Reporter - Legal Name


    We have difference details input in "Doing Business As" and "Legal Name" in the Company Profile.

    And we wanted to add these 2 field in our FR. 

    But the field name "CoName" from FR Paste is linked to "Doing Business As".…

  • custom report for web screens

    Hi, we have a customized order confirmation form. i added to the webscreens reports. it prints fine but the parameter prompt does not allow you to search or select options such as check delivery method.  values must be entered. any help resolving this would…

  • forcibly sign out users after 3 hours inactivity macro

    A sage 300 company with 15 users runs into the commonly seen problem where users forget to logout at the end of the day. There is a nice feature where you can sign out users from the lanpaks licenses screens manually, but has anybody written a macro to…

  • GL Transaction Listing Table Details

    GL Transaction Listing Report looks like a dll type report. Can someone tell me from which tables it takes the data, we require this to make  our own customized report. 

  • Exceptions with Empty Messages

    Note the is a .NET application written in C#.

    I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…

  • Item Line Numbers in Orders/Purchase Orders

    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…

  • FR Income Statement in comparison by Segment (Branches)

    We have a database for Company A with 10 branches and another database for Company B with 6 branches. 

    Both using the same COA with Segment-1 as GL Code and Segment-2 as Branches.

    We need an Income Statement to show the comparison of branches in one report…

  • I/C Transfer Suppress Print Transfer Slip Confirmation Dialog box


    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…

  • AccpacPrintSetup crashing after upgrading to SAGE 2020 PU2

    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…

  • Report Designer - custom date formula

    Hi there,

    This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters.

    I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year".

    Example would be that…

  • Formula to Suppress the footer option

    I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing.

    Footer A for Standing Billing
    Footer B for Tenant Billing

    Below is the formula from the existing sage invoice…

  • AR Aging Report with Description in Crystal Reports


    I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports.

    But there is no description field found from it existing table in this report.

    The field that I want to add is in table AROBL…

  • Customise Crystal Reports Forms

    I want to customise the Crystal reports to indicate which user keyed and/or posted batches in AR and AP.  Which tables should i be looking at?

  • How to create customer aging report in custom crystal report?

    I am new in crystal report. I want to create a crystal report of customer aging report.

    I want in column only (docdate,docnum, balance due, but not incoming payment of customer, days in the form of (duedate to getdate shows in days e.g. 90 days)

  • Order Entry Macro, how to get the order number once posted?

    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.

  • SAGE 300 ERP crash when running User created reports

    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?

  • Multiple Logo for Invoice Printing


    I have a standard invoice format that use among few database but now it need to add the company logo for each database. Any suggestion to addin for each databse and still share the same standard invoice ?

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

    [sage300erp 2018]

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

  • Crystal Reports that output to Printboss

    I took over a client who created a number of crystal reports that output to printboss. Very nice, but they do something strange with the crystal variable that evaluates to the trigger string


    'PB#INFO '+Chr (247)+{@PrintBossForm}+Chr (247)+', '+…

  • Crystal Reports - Additional selective info when printing Invoice


    I have added few parameter in the Invoice footer for Users to select the relevant info when printing. example : Email Address, Bank Details, Online Banking Details. which these additional info is not from Sage fields. With this method I find that User…