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

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

I tried that. The Phone plugged in by itself and it got it's DHCP IP address and settled down fine. I then plugged in the Small Switch (that has the PC and the Network Printer plugged into it). The PC got a connection and I could access the Internet and anything on the VLAN1 network like normal...

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

Yes, I was planning on storing the calculated values for Tax Amount and Labor Amount on the Estimate Detail Line record.

Thanks. So DLookup is the right way to go. And actually I really just need to pull in the Tax Rate to calculate the Tax Amount, and Labor Rate to calculate total Labor Amount, based on the other fields. I don't want to keep that data on the table, just pull into the Sub-form for the...

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