Search results for query: *

Sharing an interesting, or maybe encouraging post... Richard Jang's response makes sense. https://communityhub.sage.com/us/sage300/f/general-discussion/245081/sage-300-to-sage-intact-transition

Hi Sage 300 version 2024 PU4. I can log on to Desktop without any problem. All modules can be accessed. I installed web screen today. When I launched web screen and tried to log in as ADMIN. I got an error message below: "A problem occurred when signing in to web screens. Try signing in to...

Hi, Is there anything to automatically close the opened Sage screens and log out Sage session of a Sage user, if the Sage user is inactive for N minutes? 3rd party tools? Thanks!!

Hi there, Day End stopped and said "Record has been modified by another program. Day End Processing could not process all transactions." I did an RVspy and could see the errors below: [3fb4.7ff.2ac8] PO0712: PORCPN [08:38:10.16].Put(view=0x1109276C, field=1, size=10, verify=0...

Hi there, Sage 300 v2023, Module is NOTE. Their SQL tables begins with "KN". I tried to get the contents of the NOTE. It seems that the data is encrypted in the table "KNNTBLOB". Would anyone confirm if this is the case, and we can't export the NOTE? Thanks in advance.

Hi, I have an integration app that creates OE shipment from OE order using "Ship All" on the OE shipment header field, and updates the OE shipment created by appending a MISC item of Freight, and then creates the OE invoice with the MISC line. This integration works 99% of the time and recently...

Hi, Running into an issue with a client in Order Entry in Sage 300 version 2023. The create OE order, sometimes they can't ship the order line completely and leave the order line with qty backordered. They then create the invoice and push to AR from Day End. Now the order has the incomplete...

Hello, I recently got a request from a client who would like to get our custom VB6 screen with OCX to look like Sage native screen, with the same color theme, flat text box, and modern look. I can't find a property in the OCX itself to change the OCX look and feel to match the Sage 300...

Hello All, We just upgraded Sage 300 to version 2023 PU1 at a client. When invoicing in OE, all of a sudden, we got an error message "Miscellaneous charge code MC0003 does not exist" when trying to create an OE invoice. The MISC charge code was used many years ago and now does not exist in OE...

Hello Friends, It has been a very long time since I asked any questions or checked on this forum. I ran into an issue with a couple customers. Sage 300 version 2023, macro VBA editor does not launch. I can record and save a macro in Sage, but can't launch the editor. Any help is highly...

Hello, It has been a very long time since I asked questions. I have a client that has quite a list of custom applications for Sage 300. Currently they are all over the places with shortcuts being in many module. Some apps are old VB.6 app or macro. I am looking at creating a module (like a...

This is for Sage v2019, on a user workstation with Windows 10. When I record a VBA macro logged in as the user in both Windows and Sage, the macro VBA script window does not prompt when I click on finish capturing. The macro file can be saved to the shared folder, but the screen does not...

My client want to update the Account Set Code in ICITEM after the items are sold in OE orders\shipments\invoices. Is there a tool to do that or this can only be done in SQL ? Many thanks.

I have a custom screen with PO OCX on a .NET form. I replaced the Post button with my own new Post button. I wanted to validate only the Items of the vendor can be posted. I could get to the point where the Post did not get fired even when the Items are valid. Below is my code. At the end of the...

A client is running Sage 300 2019.1 with AutoSimply MF, IB, SC and PP. IB shows "XZ" as it's module when it's logged into Sage. However, there is a module "XY" with screen ID "XY0001" showing in Current Users -> Other tab. It is logged in as "ADMIN". I can't figure out what is running to launch...

Hello, I remember seeing someone posted this question before. But I don't know where to find the answer. In BKTRAND table, the field DDLINK stores the value of the source transaction (maybe module + type + batch # + entry #). Is there any help on how it works ? E.g. 224651000000000001 means an...

Hello, What would be the best practice to launch a Sage 300 macro from another Sage 300 macro (or VB program)? The below code does not work. ******************************************* Private Sub CommandButton1_Click() Shell "C:\Sage\Sage300\Programs\Macros\TEST.AVB", vbNormalFocus End Sub...

Hello, I have a custom Crystal Report for Sage 300 v2018. It has been working in v2016. We just did an upgrade. The report works in Crystal Report Designer on the same App server as the Sage 300. Once I tried to launch the report directly within Sage desktop, I got an error message of...

Environment: Sage 300 v2018 on TS server. It just happened today at a client. When clicking "AP Setup" icon, Sage 300 crashed. Then I tried to run RegAcc, Sage 300 also crashed. The event log says it crashed at "C:\Windows\System32\MSVCR120.dll". I have never seen this. The full app on app...

Environments: Sage 300 v2018 full install on an App server. Workstation Set up on a RDS server. SQL on a SQL server. Every morning when the users log on to RDS server and launch Sage 300, the first user receives an error prompt "You do not have a license to use this product!" and can't get to...