Table Import or Mail Merge Macro?

I need to set up (item card, assign site, assign creditor) about 250 new 
items. I've been testing the table import process in the test company, but 
keep getting handling exception errors when testing the item after the 
"successful" import because of an obscure (for me) blank field. 

All the items have the same Class ID, creditor, site, etc. They only differ 
in item code, desc, curr cost, list price, gen desc, and creditor item code. 
So would I have better luck recording a macro setting up the first one and 
mail merging the necessary fields?

If you believe table import is still the way to go, do you know where I can 
find a list of required fields for IV00101,2 and 3?  (Have searched this 
forum and KB, but maybe I missed something?)

Thanks for any suggestions. 
0
Sean9204 (159)
9/14/2009 2:23:01 AM
greatplains 29623 articles. 3 followers. Follow

2 Replies
431 Views

Similar Articles

[PageSpeed] 8

I would advise using Integration Manager first of all, after that try the 
Mail Merge/Macro route.  The down-side with Table Import, you need to know 
all the Business Logic (ie. which fields required, which values in which 
fields) and it's hard to get right.

-- 
Japheth Nolt
MCP
Microsoft GP/SBF Specialist
Landis Computer
http://landiscomputer.com



"Sean" <Sean@discussions.microsoft.com> wrote in message 
news:67B06925-F2F0-4DA4-A7B4-222B7AFB7FB8@microsoft.com...
> I need to set up (item card, assign site, assign creditor) about 250 new
> items. I've been testing the table import process in the test company, but
> keep getting handling exception errors when testing the item after the
> "successful" import because of an obscure (for me) blank field.
>
> All the items have the same Class ID, creditor, site, etc. They only 
> differ
> in item code, desc, curr cost, list price, gen desc, and creditor item 
> code.
> So would I have better luck recording a macro setting up the first one and
> mail merging the necessary fields?
>
> If you believe table import is still the way to go, do you know where I 
> can
> find a list of required fields for IV00101,2 and 3?  (Have searched this
> forum and KB, but maybe I missed something?)
>
> Thanks for any suggestions. 

0
japheth (84)
9/14/2009 1:37:44 PM
Take a look at my article "The often overlooked, yet powerful Table Import" 
at 
http://dynamicsgpblogster.blogspot.com/2008/10/often-overlooked-yet-powerful-table.html. It contains resources on where to find table columns information.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"Japheth Nolt" wrote:

> I would advise using Integration Manager first of all, after that try the 
> Mail Merge/Macro route.  The down-side with Table Import, you need to know 
> all the Business Logic (ie. which fields required, which values in which 
> fields) and it's hard to get right.
> 
> -- 
> Japheth Nolt
> MCP
> Microsoft GP/SBF Specialist
> Landis Computer
> http://landiscomputer.com
> 
> 
> 
> "Sean" <Sean@discussions.microsoft.com> wrote in message 
> news:67B06925-F2F0-4DA4-A7B4-222B7AFB7FB8@microsoft.com...
> > I need to set up (item card, assign site, assign creditor) about 250 new
> > items. I've been testing the table import process in the test company, but
> > keep getting handling exception errors when testing the item after the
> > "successful" import because of an obscure (for me) blank field.
> >
> > All the items have the same Class ID, creditor, site, etc. They only 
> > differ
> > in item code, desc, curr cost, list price, gen desc, and creditor item 
> > code.
> > So would I have better luck recording a macro setting up the first one and
> > mail merging the necessary fields?
> >
> > If you believe table import is still the way to go, do you know where I 
> > can
> > find a list of required fields for IV00101,2 and 3?  (Have searched this
> > forum and KB, but maybe I missed something?)
> >
> > Thanks for any suggestions. 
> 
0
MarianoGomez (3440)
9/14/2009 6:06:01 PM
Reply:

Similar Artilces:

Data table in chart?
This is a multi-part message in MIME format. ------=_NextPart_000_01A9_01C69782.28506D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have some line chart portraying responses to 20 items. I would like to put a table under each chart the shows the value of not = only the responses that are charted but also the percentage difference = between the two. My problem and the question is that if I use the 'data table' option in = creating the chart the row with the difference is not there. Then if I = try to paste a table under ...

Combobox for Table, From Table
Hi, The online help function tells me I cant make a combobox which finds its entries from a table and stores its entries in the same table. I want users to be able to enter areas where clients live. The combobox needs to fill the Area column in the appropriate table. But I want the combobox to be filled with previous entries from the same column, with the provision that a new entry can be made. The project is expanding thats why I need this. Or do I need to make an extra table with areas that can be filled with a separate command, which is then used as a source for the com...

How do I add and then rename a worksheet using a macro?
When I try to rename a new worksheet in a macro, it will make the worksheet but will not rename it.............. and gives an error because the new worksheet has a different sheet number than the one the macro just made.... All I want to do is compile a macro that makes a new worksheet and will rename that sheet a different name. . . . . . . . Jerry, The inserted worksheet will be the active sheet after the insert, so after inserting it, you can write: ActiveSheet.Name = "New Sheet" -- Earl Kiosterud mvpearl omitthisword at verizon period net ----------------------------...

Copy data from on table to another ?
I have lost a lot of data in my backend, but it is only data from a few columns, in one tabel, that I have lost. My tabel is called taCustemor, and the columns in that table is called fakFirm, fakAdress. I have use a custemornumber as a primarykey. So now I want to copy only these columns from my backup of the backend to my backend in use. I'm sure that I can do this buy using SQL, but I'm not sure how to make this querie. Can some one out there help me ? You want to use an append query. See Help file for info. In the database where you want the data to be when you're done, ...

pivot table again
i have a range of fields in a pivot table some are qty others are value how can i split the table into two seperate sections one showing qty and the other showing values (if that makes sense) If your quantities and values are in the same column, you'd need to use a "helper column" that differetiates them (Qty vs Amt) Then you can include that field in the pivot table before tha field containing the quantities and amounts. Does that help? *********** Regards, Ron XL2002, WinXP "max power" wrote: > i have a range of fields in a pivot table some are qty other...

Landscape Table on Portrait Page
Is it possible to create a landscape table on a portrait page, i.e. a page with a normal portrait header and footer? I am aware that one can change the text direction of each cell in the table to simulate a landscape table, but I would like to know if there is not an easier way. See http://word.mvps.org/FAQs/Formatting/LandscapeSection.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Johann Swart" <JohannSwart@discussions.microsoft.com> wrote in message news:1119FBC3-2001-48C7-B02E-07D85C7F444E@mic...

Where is tables in reports
Is there anyway to get tables into reports? If there is none then is there a work around. The forms I have to make use many block cells. In word tables makes things easy. ...

Column Formats & Merging to Word
Recently upgraded to v. 2003 and now have a problem with data that merges into MS Word 2003. The excel column has a basic formula in it, and is formatted to show only one decimal place. However, when it merges into word, there are many decimal places (8, 10, can't remember how many). How do I fix this? It was never an issue in v 2000. TIA Christina Christina There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx Gord Dibben Excel MVP On...

Ensuring only one commission per product in Access Table
Good afternoon, Please can someone help me. In my Access Database I have a table called tblCommission, with the fields: Commission_ID;Client_account; Product_code; Commission; Exchange (£ or $) I need a method to ensure that each client can have a commission set for every product - but that a client cant have to commission's for one product: eg: I need a method to prevent this: Comm_ID Client_account Product_code Commission Exchange 1 000001 Coke 3 $ 2 000001 Coke ...

unsend or retrieving e-mails?
Hello there! Here is a nut for the pros... Is it possible in any way to retrieve sent e-mails? Sometimes - like right now - I am a bit (read: very very) frustrated, because I have sent an e-mail to the wrong person. Once in a while I have sent mails from my draft folder, by mistake too. Are there any ways to unsend such messages or perhaps delete them before they are received on the other end of the line?? I am not alone on this, believe me. Only if you are using Exchange server and are trying to retrieve mail from the same organization that has not been opened. You can try using...

In macros, an instruction that returns the position of the Active Cell
In a macro, how can I make it return the position of the Active Cell Colum & Line. Or how can I set that position as a Condition; e.g. �If ActiveCell i B7 Then�.� Or �If ActiveCell belongs to Column G Then�.� Thanks in advance for any help. AC -- ac ----------------------------------------------------------------------- aca's Profile: http://www.msusenet.com/member.php?userid=385 View this thread: http://www.msusenet.com/t-187368645 Hi Sub test() Dim ws1 As Worksheet Set ws1 = Workbooks("Tester.xls").Sheets("Sheet2") With ws1 MsgBox ("Cell address is &qu...

Internet E-mail downloading
Hi folks. When I try to download e-mail from my hotmail internet inbox to my outlook inbox on my hard drive, it only stays in the inbox until the next send receive, at which time the entire outlook inbox contents is replaced by the entire Hotmail inbox contents. This means if I delete or move anything from the server inbox, it will be removed from my outlook inbox as well, whether I have saved it to another folder or not. This means I can not empty the inbox on the server or set automatic send receive options in outlook for fear of losing recently downloaded mail. This le...

Table Expert
When a case is resolved, there is a dropdown to select the amount of "Billable Time" for the case. I have searched tables but cannot find where this data is stored. Is there anyone that know the schema where this data is kept? Bryon, When you resolve a case, the resolution screen fields are added into the activity table as a resolution type of activity. The Billable Time value appears in the TimeSpent field. (While building my auditing application, VAST, I've had to become much more of a CRM schema expert that I ever wanted to be - by the way, you can see these reso...

Recreating HR tables
I've been having some problems with HR. I've had to create some tables so the program would run. I simply copied the tables from another compagnie where is was saying I had missing tables. I'm wondering if there is a list of Tables for HR and Canadian Payroll or if it were possible to recreate these missing tables another way? I currently have this error as well: Could not find stored procedure 'Compagnie.dbo.hrCompDoesHrCompExist' ...

How do you create a table with a shaded header in Word 2007 or 201
Hi.. Can anybody tell me, how you create a table, and then shade the first row in it to something like gray, then set the grid lines to gray or something, and maybe set the alignment in it to centered... This is 2007 or 2010, not 2003 in which it was possible to do so. Thanks. Select the first row of the table and then right click with the mouse and select Borders and shading. For the alignment, select and right click and select Cell alignment -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting ba...

New Import Utility for RMS Store Ops and HQ! #2
Just a post to advise RMS users and partners that we have just released a new import utility for RMS. It works with both HQ and SO and allows importing of items only, but does allow for changes and updates. Priced at US $495 or GBP £275 for end users. Reseller discounts are available If you are interested please email me at rod@rsgplc.com with the subject RSG Import Utility Rod Barlow Retail Systems Group PLC (Microsft RMS Reseller UK) We also have an Import Utility. The base option does items and related fix data. But it also does catalogue import. Additional module availa...

Pivot table subtotals 100% #2
This is what I am aiming for but how can I get 100% in subtotals for first year and the increase %age for the second and subsequent year please 2002 2003 Apples excellent 15 22.72% 16 24.23% good 21 31.82% 25 37.88% poor 30 46.46% 39 60.39% 66 100% 80 122.5% Greens excellent 12 17.65% 37 54.42% good 27 39.70% 51 74.98% poor 29 42.65% 47 69.12% ...

bulk mail code page
Hallo, when I try to bulk e-mail my customer, CRM 4 generate datas for MS word. But this data are in bad codepage (I use Czech version of CRM 4). I have info, that there is somu patch, but just in "some partners test phase". I need to send some newsletters... Anyone can help???? Thanks ¨ Michal Verner ...

Table info
In Vendor Maintenance window , there are multiple Address ID's. In which table i can find this information. Great Plains 7.5 Thanks in advance Deepwater, PM00300 holds all the address information for each address ID. -- Victoria Yudin Dynamics GP MVP Flexible Solutions - home of GP Reports http://www.flex-solutions.com/gpreports.html "Deepwater" <Deepwater@discussions.microsoft.com> wrote in message news:F9296B22-2B44-4D64-9E3C-DC5FE4B07028@microsoft.com... > In Vendor Maintenance window , there are multiple Address ID's. In which > table i can find this...

Extender tables #2
Hello! We are implementing an integration from Microsoft CRM into Microsoft Great Plains and this would include writing CRM fields to Extender Fields. Are there any available SDK's for Extender or maybe any table lists? Thanks, Andi Saldana There are but I think only partners can get them. Please send me a message and I'll send you what I have. "Andi Saldana" wrote: > Hello! > > We are implementing an integration from Microsoft CRM into Microsoft Great > Plains and this would include writing CRM fields to Extender Fields. Are > there any avai...

Pivot Table Axis format
Hi. I have a macro that creates a pivot-table and pivot chart. The X-axis is a date. In the raw data, the date is formated as month/day. This is the way I want it on the chart. However, the X-axis formats with month/day/year. How can I force this to display correctly? Thanks, Mike. Do you see a grey little dropdown under the X axis (where you can choose your dates to show)? If yes, then rightclick on it. Select the top option: "Format pivotchart field" then click on the Number button on the next dialog. There are a bunch of date formats that you can choose from. Maybe...

Inserting table to other table
I have a form which consists of a table. I want to insert some selected value into other table when i update and at the same time I want it to save into my own table too... May I know the way please..... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200704/1 I'm having trouble visualizing your situation. Could you provide an example of data? -- Regards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner http...

import snp file extension to MS Excel
I received a file with an extension snp, is there any way I can convert or import to MS Excel format? Thanks. Not to my knowledge, which is that SNP files can only be viewed with Access Snapshot Viewer. Ask the person that sent it to you to export it to Excel instead of SNP. ************ Anne Troy www.OfficeArticles.com "TSS" <TSS@discussions.microsoft.com> wrote in message news:A0B79D46-7545-4D30-9152-0D633590AF6E@microsoft.com... >I received a file with an extension snp, is there any way I can convert or > import to MS Excel format? > > Thanks. FWIW, De...

Importing eml files and Web Browsing in Outlook
How can I import ".eml" files into Outlook 2007, this is the format in which the Windows Live Mail client keeps mail messages. Can I get Outlook to bring up it's browser when I click on a link in a mail item. My default browser is Firefox, and that's not going to change. Ideally I'd like the built in browser (which I appreciate is in fact the IE engine) be used, with an option via the context menu to open the link in the default browser, or better yet a menu of the installed browsers - which in my case would be IE8, Firefox3, Opera9.5 and Maxthon2.1.2. -- TUT &...

Pivot Table not sorting correctly
In column A I have several of the same names listed more than once spelled exactly the same but when these line are pulled into a pivot table each is displayed seperately. I followed the same exact procedure for this table as I have for the others that I displayed correctly. What causes those lines to be displayed on separate lines? Perhaps some of the entries have space characters at the end, and others don't. Marian wrote: > In column A I have several of the same names listed more than once spelled > exactly the same but when these line are pulled into a pivot table each ...