Search results for query: *

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

Would like to share my fix: After trying a few things, I fixed the Data in SQL to get Day End to work. Below are the 2 SQL statements to delete from the 2 tables. delete from POLINEZ where RCPLSEQ in (25199636, 25199638) delete from POCOSTZ WHERE RCPNUMBER = 'RCP0039064' RvSpy can provide...

Thanks Djangman. I could identify the PO # and the Receipt #. It is completed. Its Receipt and Invoice are created. But Receipt lines are not in PORCPN table, and they are in POLINEZ table. Seems that the only option is to insert the missing receipt lines in PORCPN table and try. Looking...

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

Thanks DjangMan! I confirmed that the customer is only using text in the NOTE. I could do a CAST to get the text out. I figured I should share it. SELECT [NOTEUNIQ] ,[PARTNUM] ,[AUDTDATE] ,[AUDTTIME] ,[AUDTUSER] ,[AUDTORG] ,CAST([BLOBDAT] AS...

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.

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