We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?
I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab?
am I able to put a custom view in here somehow as a shortcut?
We are attempting to copy over all of our customized to fields from a test company to a brand new company. Is there an easy way to copy over the customized fields and panels while creating the company?
I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail.
The Code field appears from the table but i cannot select it.
what needs to be changed?
UDT
AP Invoice Detail
UDF in AP
Thanks for your assistance…
As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all!
I am working with the Open Sales Order Report now and stuck on suppressing some items in the report.
The end goal…
Hi alll,
I am trying to compile my module ID but having this error:
makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found
- Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…
I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed.
I am now receiving an error 88 type mismatch (error window below). Any thoughts?
START OF CODE
Dim retVal Dim cpwgt Dim cpwgtstr Dim…
I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order…
When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…
on OE/CN screen you fill in OE/Invoice number and Sage loads details
I have certain customers where all OE/CN are on account, trouble is once you erase the OE Invoice# the screen details erase (can we stop this from happening?)
I did not want to manually…
Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
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…
Hi everyone, I'm using Sage 2013
I've added a new tab to the Sales Order module in Main > Invoice Data Entry
I've added fields/UDFs (some are already ones that existed), but I'm unable to add to anything in this tab or figure out how to get some of…
I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…
Hello,
We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'.
Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
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.
We just hired a remote team member to process orders that drop ship either entirely or partially or are fulfilled electronically. Our current work flow revolves around paper and that doesn't work any more.
Have you built or found an Order Manager…
Updated from Sage 100 Standard to Sage 100 Premium. Need to supply vendor name on job cost invoice. for customer. JC_InvoivoWrk only supplies Vendor id and Division id. How best to link JC_InvoiceWrk to Vendor File to get Vendor name in database
Hello,
I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…