Search results for query: *

Importing a Cash Receipts Batch would normally Debit Cash for the amount of the Check and Credit an A/R account for the same amount which is also the total of the invoices being paid (Entries in the RRM20201 Open Transactions Apply table). However US Bank when depositing money in our  KeyBank...

I imported a Cash Receipts Batch. I can open the Batch in Receivables Batches. But when I go to click on the PRINT icon to review the batch before I post it, nothing happens when I click on the Print Icon. I ran queries on several tables that were inserted into and compared to a manually...

I have a CSV File with 17 columns, where one column [CustName) has various customer names and some of them have commas. Example "ABC Company, Inc" I want to Bulk Insert the CSV file into a table. The command is: BULK INSERT [dbo].vPTInsert FROM...

I'm using Visual Studio Pro 2017 v15.9.11 to create a basic SSIS Package to read data from a CSV File. In my SQL Table (I am importing INTO) I have a column - [InvAmt] as decimal(19,2) In my Flat File Connection Manager, (for th eCSV Import file) the column is set : DataPrecision = 0...

I have a form [Containers] with a combo Box for [cboCustID] The Row Source is: SELECT dbo_tblCustomers.CustID, dbo_tblCustomers.CustName FROM dbo_tblCustomers ORDER BY dbo_tblCustomers.CustName; There are < 100 Customers in the dbo_tblCustomers and when adding a new record in [Containers] the...

Running Dynamics GP 2015 with SQL Server 2012 SP2 Users connect with VMware Remote Desktop Servers. 2 A/P groups: 1 is local to here the server is hosted. The other is at a remote office with a 10MBs Internet connection that is not being over used. A/P checks are Laser Checks using Mekorma for...

In Excel 2010 I pasted data from another source that was Comma separated values (not a CSV FILE) I then did the DATA / Text to Columns function; using Delimited, on Commas that worked fine. I then inserted a column and pasted a simple formula =IF(G2>0,LEFT(G2,6),"") <-- Note this has 3...

There may be a better way to solve the problem and I am open to any ideas. In short the problem: I have a form that tracks "Containers" when they come to our yard. A container may come and go many times or the course of time. My user would like to enter the Container Number and have the form...

I have Cisco switches with POE. 2 VLans (The phones are on VLAN2 (10.10.x.x.) VLAN1 is for the PCs, etc. (192.168.x.x) I plug the ShoreTel 230 Phone set into the Wall Jack and a PC into the PC Port and it all works fine. However I have 4 workstations that have small 4-port netgear switches, to...

Looking for guidance on how best to do the following: I have frmServiceHeader and a sub form sfrmServiceDetail. frmSeriveHeader has various information including the TaxRate and LaborRate for the particular customer. When I add a Row to the sfrmServiceDetail, I want to enter thing like Labor...

I'm running MS Access 2010. I have a Switchboard that calls a report in Print Preview. This works OK. However, if I click options on the Access Quick Access Toolbar for Print, or Email, what actually prints (or emails) is the Switchboard Form, not the report. If I run the report directly from...

I have a table - tblCustomers with CustID and CustName On a Form I put a 2 column combo Box - cboCustID and it works fine. The Drop down is set to show both columns from the table. I have an Unbound Text Box - txtCustName I want to populate from the 2nd value in the combo box. In the...

I have a multi-site private network using MPLS. We have a Private IP scheme using 192.168/24 addresses where the 3rd octet identifies my sites. Users ate one site, have 2 bonded T1's for a 3MB port to the MPLS cloud. They tell me that during the middle part of the day, their access to the...

I have a To-Do List in Excel, that I am constant reviewing and manually re-sorting items (rows). As priorities change, I may want to move rows around. What I do now: Highlight the row, hit [Ctrl]-[X], Right-Click on the Row I want to move the cut row to, and select "Insert Cut Cells" Which...

We have Windows Server 2003 with active direcotry and most all users are setup that "Password Never Expires". We've recently had a security issue, and I want to set all of the User accounts to force them to change their Password on next login. Is there a way to do that with a script or query...

I have a report, "Winning Bidders" for a silent auction. The table "Baskets" has Basket#, Name, Winning Bidder, Amount Bid. the report groups on [Winning Bidder] and shows each basket they won, and prints a Total Due in the Group footer. the total number of won baskets for any bidder will be...

I have a form - frmProducts The Table is tblProducts with a field prd_Value prd_Value is defined as Decimal, currency, 18 ,2 The field on the form is a Textbox, bound to the prd_Value field,Format= Currency, 2 decimal places. The user is entering data and hits the Tab key to move through the...

I have several MS Access databases created in prior versions of Access (i.e. 2003) that have reports that get exported to Excel. A Macro runs various queries, and the final step is using the Output To macro command to create a new Excel Spreadsheet. It works fine using Access 2003 but now some...

I have an Access application that outputs data to an existing Excel Spreadsheet. I have code that writes a recordset with varying number of rows to the spreadsheet starting at Cell A25. My existing code is below and works great. What I need to do is: 1. Find the next blank row on the...

I was given an ASP.NET application that connects to a SQL Server Database. The Database was backed up off the old server and we installed it on our servers just fine. The ASP.NET application attempts to make a database connection but that function is in a DLL file and it seems to be hardcoded...