Recent content by appelq

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

That Proc was perfect! It addresses all of the issues I was having with Bulk Insert. Thanks for your help. Chuck

OK. I'll research the powershell option. My main goal is to allow the user to drop files into a folder and have a Stored Proc import the data with minimal effort by the end user. Thanks, Chuck

So when I open the CSV file in Textpad 8.0 the data looks like this: invnum,invtype,bolnum,ponum,invdate,batchnumb,custnumb,company,terminal,invamt,gldate,header_detail,chargecode,glaccount,debitamt,creditamt,memo...

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 believe you were right, that the property change, did not propagate. I double clicked on the Data Flow Path between my Flat File Source and the OLE DB Destination. Then Selected "Data Viewer" and enabled it. I then ran the Package and it it worked fine. Then the Disabled the data viewer...

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

MajP, You are correct. I noticed that as an aside and changed the ! to . on both lines. Thanks, Chuck

Thanks! That did the trick. Chuck

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

Solved. Turns out the Cisco Switches had "Port Security" enabled and was limiting the number of MAC addresses per port to 2 We raised the max number of MAC Addresses and that solved our problem. Thanks, Chuck