Recent content by vbdbcoder

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

Thanks DjangMan for your pointer. I have my 20 years in this place... LOL...

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

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