Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vbdbcoder
  • Content: Threads
  • Order by date
  1. vbdbcoder

    Sharing: sage-300-to-sage-intact-transition

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

    Sage 300 Web screen login error message

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

    Automatically log out Sage session

    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!!
  4. vbdbcoder

    Day End Error (POLINEZ table)

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

    Can Sage NOTE be retrieved

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

    "Ship All" function does not work for 1 customer

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

    Is there a good way to complete an order line with qty backordered?

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

    Can VB6 screen with OCX look like Sage 300 native screen with color theme and flat text box ?

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

    OE invoice getting Miscellaneous charge code does not exist error message

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

    Macro editor can't be launched in Sage version 2023

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

    Create module custom applications in Sage 300 desktop and web screen

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

    Macro does not launch from workstation

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

    Update Account Set Code in ICITEM and Transactions

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

    I have a custom screen with PO OCX

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

    Where to find the screen being opened and used in Sage 300?

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

    What does the value BKTRAND.DDLINK mean?

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

    Launch a macro from a macro or a VB program

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

    Custom Crystal Report Error when launching from Sage 300 Desktop

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

    Crash when clicking AP Setup icon

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

    License Error Message Prompt Each Morning

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

Part and Inventory Search

Back
Top