Search results for query: *

ENVIRONMENT: Sage 300 2019 Premium | Server 2019 SQL 2012 RECREATE ISSUE: [ol 1] Create a Transit Transfer with a couple of detail lines and make the transit QTY requested say 10 (so you can try this a few times!) Start recording a Macro Create a Transit Receipt and receipt a QTY of 1 for...

Hi, I've tried to search for a script to count any users logged in via RDP and if the count is zero, to shut down the server. This is for a W2KR2 TS. Anyone know how to do this? Thanks, Rodney

Hi, I'm wondering if anybody has any success with Using OCX controls in VS2013 vb.NET Forms and could outline the steps to do so. I have tried the usual process of adding the OCX to the TOOLBOX, dropping on the form but always get the Failed to Import OCX message. I know, I know... some of...

Environment: Sage 300 2012 Premium Edition - PU2 on MS SQL 2012 ISSUE: When client is in the OE screen and clicks the drill down button next to the LAST INVOICE No. field it correctly displays the OE Inquiry screen. Then when user presses PRINT button to print an invoice the following error...

In Sage 300 2012 is there a way, programatticaly to determine how many LanPak's are in use? Rodney

I have had to restore my installation of Sage 300 PU2 (SQL) but now the licenses including the LANPAK says UNAUTHORISED and when I try to reenter the activation codes is says invalid code. I go live on MONDAY! what to do?

I've just completed an install of SAGE 300 2012 and just discovered that when I create an OE order, the QTY on SO remains zero and it also does not show up in IC LOCATION DETAILS. Any ideas what is wrong. (Approaching GOLIVE next week!) Thanks in advance. Rodney

Recently I wanted to make an automation application that would run by scheduled task to regularly print unprinted invoices. I wanted more control than just a VBA Macro so wrote it in vb.NET with the ACCPAC.ADVANTAGE DLL reference. There is more code around this project, like marking the...

Environment: Sage 300 2102 PU2 | SQL 2012 I have a installation with 3 companies. Two (Company A and B) are live production db's and one (Company T) a test. Users have a range of User Authorisations in Company A and B. (For the purpose of this post, I will only talk about company A and T...

Hi, I know that this is possibly not a real issue, however I am trying to write a vb.NET application using LINQ to XML and match an existing applications (for which I don't have the source code) output. The XML output I am trying to match is: <sh:StandardBusinessDocument...

Invitation To Comment I'd like to get your thoughts on the following. What design layout would work best as to regard to performance and limiting any MultiUser Conflicts. I've reviewed the Tech Documentation about design considerations, but wanted some more light on specifics. For the...

Can anyone help with the following code? I am trying to return the current pricing for a customer (to allow for sale pricing etc). The code below does not return the correct values. I have put a few MsgBox's to show values. When the code runs, the BILNAME is always correct. (In SAMINC 1200...

Hi, I have an install of Sage 300 2012 on Windows Server 2012. The normal company and system databases are working fine, connection to MS SQL no problem. But now trying to install the PORTAL db (have created it in SQL Management Studio) but keep getting an error as shown below. Error. An...

Environment Sage 300 PU1 MS SQL 2012 Windows Server 2012 Has anyone come across this error and found a solution? When trying to print an AR invoice to the CUSTOMER delivery location, which is via email, the above error occurs. (Crystal Reports Error: Invalid export options.) I have tried...

ENVIRONMENT Sage 300 - Advanced - PU1 Windows Server 2012 MS SQL 2012 Can anyone help with the following. I have a new installation as shown above. The module tree on the left displays fine, the icons on the right display fine, but above the icons, where normally you would see the 'Licensed...

Accpac 5.6 PU1 (SQL) I have a user that only remits via EFT. No remittance advice is required. Is there a way to prevent the prompt to print a remittance advice? Thanks, Rodney

Environment: Accpac 5.6 PU1 SQL 2005 Accpac Installed on SBS 2003 Users connect via Terminal Server 2003 that has WSSetup Installed This installation has been working for over two (or is it three) years now without issue. Now users are getting the error Error occurred when activating Sage...

Ideas Anyone? I would like to set up a new price list, load it into Accpac and then have it come into action at a given date WITHOUT using Sale Price and any third-party application and without user intervention. For example: I have ITEM A on LIST pricelist at 1.05. Pricelist LIST is default...

Hi, Can anyone tell me what the difference is between the following two fields in the OEORDD table. QTYORDERED Quantity Ordered ORIGQTY Original Quantity Ordered My thinking is that the very first QTY ordered into into OE is the ORIGQTY, but what is the QTYORDERED? Thanks in advance...

In the OEORDD Table, COMPLETE field, one of the possible values is 1 = Completed/Not In Database What exactly is the meaning of this? Would records like this be purged with a Clear Transaction History? Thanks, Rodney