Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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
Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.
Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144
" Invoice Detail
Attempt to change read-only field 'Header Discount'. "
keep popping up and I am not able…
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…
Hi all, I would like to know if it is possible to create my own WEB API to get/post data with "GET/POST" method.
I am trying to do something like this:
- create a new table with roto ID using Orchid Extender
- create my own API using Sage Web SDK…
I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…
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…
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…
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…
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…
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. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
I am looking to maintain my price lists. Currently I have inherited 150 old ones. I want to delete them. How do I do it?
I am also looking at importing new price lists? Is there a template.
Is there a way to update base price changes and add new items…
Hi,
this is continuation from my question "Web SDK - generating multiple code type, and set fix Index.cshtml to be display" which is solved.
Below is my screen. After user sign the signature pad, I want to
1. Save the signature (DONE)
2. add new…
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.
Hi All,
I have a custom table/view that I create using Orchid Extender module
Table name: VIOEDEL
View ID: VI0704
Is is possible to add view composition to custom view linking them by ORDNUMBER. I want to add OE0520 (ORDDH).
The reason is…
Dear All,
I am developing a project using Sage 300 Solution Wizard from Web SDK.
When I am trying to generate code with ROTOID=OE0692 which is Shipment Header,
using Code Generation Wizard, I get the following error.
How to solve this? Thank…
Dear All,
I am creating a new tab on OE Shipment Entry. I achieve the UI that I want, and now I want send post request on a click of a button. Instead, I am getting an error:
Unexpected Error: Your request could not be completed within the time…
Dear All,
I am working on Solution Wizard with Web SDK. I successfully created 2 modules, CU and SG. But the only problem is the modules is not displayed correctly.
SG module is not showed in the navigation menu. But the content of SG modules is displayed…