August 29, 2008 09:22pm pdt

1. Biffster007 60,020
2. WilyGuy 54,255
3. jd_wight 50,875
4. bmosoftw... 28,000
5. Agrippine 14,200
6. Maxi84 7,500
6. gregowens 7,500
8. rfgkev 5,450
9. whoajack 5,000
9. AndersHe... 5,000
11. preitmeyer 4,000
12. opster 3,850
13. croberds 3,200
14. jgv 3,000
14. victoria_y 3,000
16. dtodd 2,800
17. hulitk 2,600
18. Robbie_L... 2,500
18. EngSiong 2,500
20. TheCleaner 2,000
20. ChiefIT 2,000
20. mattbcs 2,000
20. JMorsch 2,000
20. 50centos 2,000
20. Merete 2,000
20. aneeshatti... 2,000
20. boag2000 2,000
20. Snarf0001 2,000
20. TechSoEasy 2,000
20. wjester 2,000
20. AtiaSoluti... 2,000
20. pboulos 2,000
20. cj_1969 2,000
20. JimboEfx 2,000
20. imateyele... 2,000
20. cmorffew 2,000
20. cuziyq 2,000

1. Biffster007 61,520
2. WilyGuy 54,255
3. jd_wight 50,875
4. rfgkev 34,975
5. bmosoftw... 28,000
6. Agrippine 14,200
7. bloodymal... 13,650
8. whoajack 12,500
9. preitmeyer 12,250
10. TechSoEasy 9,000
11. Maxi84 7,500
11. gregowens 7,500
13. opster 6,350
14. Robbie_L... 5,500
15. Dodgster 5,400
16. AndersHe... 5,000
17. Chinmay... 4,400
18. DennisL 4,000
18. pmittal 4,000
20. JMorsch 3,500
20. Pioneermfg 3,500
22. croberds 3,200
23. jgv 3,000
23. victoria_y 3,000
25. dtodd 2,800

06.06.2007 at 11:54AM PDT, ID: 22617253

	[x] Attachment Details

Bill of Materials Import tool for Dynamics GP 9.0 using Excel 2007

Asked by msas1994 in Microsoft Dynamics, Extensible Markup Language (XML), Microsoft Excel Spreadsheet Software

Tags: bill, materials, dynamics, gp, excel

Hello Experts. I am working on project where I am importing data from Microsoft Dynamics GP 9.0 into Excel. Then making changes to the Excel data. I want to validate a list of part numbers against the Item master in the SQL 2005 DB then import all the rows of Excel data into the Bill of Materials tables in Dynamics GP 9.0. I think the best approach is to use VB to select the column with the part numbers and run a if exsists statement against the item master table. Then throuw an error message if the part doesn't exsist. But I also need suggestions on how to import this data back into the DB with some sort of validation. I was thinking of exporting the data from Excel using an XML template to format the data and import it into the DB via a SSIS package. Your thoughts experts?Start Free Trial

Keywords: Bill of Materials Import tool for Dynamic…

	Title
1	Materialized View
2	Parasing a GPS String in C#
3	CCAI Books & Materials
4	What is the most accurate (distance…
5	Materials for creating a training program
6	.NET training materials

Loading Advertisement...

20080716-EE-VQP-32

Bill of Materials Import tool for Dynamics GP 9.0 using Excel 2007

Asked by msas1994 in Microsoft Dynamics, Extensible Markup Language (XML), Microsoft Excel Spreadsheet Software

Tags: bill, materials, dynamics, gp, excel

About this solution