x Want to participate? Join the group to interact

  • Sage Intelligence Reporting - Need currency conversion rate in Sales Master Report

    I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

  • BUDGET ON OPTIONAL FIELDS

    As per my understanding Sage 300 budget linked to Account code (on GL). How can I handle objective based budget? Objectives are like optional fields: Eg: Acccount 1010 : Allowances Objective 1: budget $100k Objective 2: budget $200k

  • 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

  • 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.

  • Unable to Print to a Custom Payment Voucher Form

    I have a crystal report which is run via Sage 300 desktop shortcut [Macro] which has stopped pulling data through for some batches. The Crystal Report only shows a blank Custom form for some A/P Payment batch entries and will pull the data for some batch…

  • Adding Invoice number to email template for subject line.

    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,

  • Adding optional fields to order confirmation form

    We have NOTES in the optional fields in Ship-to Locations, so they show up in order entry. I am trying to get the note tied to the ship-to location for that customer, to populate on the order confirmation form. My problem is that I can't find the field…

  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    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…

  • OCX does not show on the form at runtime

    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…

*Community Hub is the new name for Sage City