Search results for query: *

When the customer is not allowed backorder qty, and ship all in OE order screen, nothing changes. Qty shipped is not updated. Qty B/O stays zero and no Shipment is created. While when I create the Shipment in OE shipment screen using the OE order, a Shipment is created with all zero in...

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

Correct, they never ship the backorders and need to set qty backordered to zero to complete the order line, so the order does not show when creating the shipment, as they have many orders from the same customer. I will investigate the Calculate Backorder Quantities settings option. Thanks for...

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

Thank you so much, DjangMan! I used AccpacContainerObject per your instructions and it works. The customer is happy and I am very happy. And yes, I also notice the dropdown box on the OCX does not change and that is okay for what I need to accomplish. It doesn't hurt with 1 unchanged control...

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

Thanks for your response. 1) Added Misc Item MC0003 to OE setup works and stops the error message prompt. There is no impact on AR or GL since the item is not being used. That was something I did to fix it. But I still don't know what triggers the error message prompt. 2) Rvspy log can't point...

Create a macro to delete them.

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

Thanks for the help! Workstation level service caused the issue. A program from North49.

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

Thanks ! This is great tip!

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

DjangMan, Thanks it works. What do the 2 parameters (-r, -f) mean? Appreciate your help.

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