Hi All,
I am using the manufacturing module.
My QC Staff need to create 500 new production BOM and we are thinking if it is possible to import the data from excel to navision?
Seek for advice… thanks.
Yes, you can use XMLports to import data into Production BOM header and Production BOM line and please make sure you validate all fields while importing to make sure the data you are importing is valid.
Hi, how to do that, any guide?
it can be done through DMS universal XML port , you need to copy all the data into notepad and then import it to navision. it is a faster and a reliable option.
Hi Yuneek Singh, how to do that? any guide / tutorial regarding this?
Look at the existing xmlport and you will have to build on your own.
Looks like the customer’s license does not have access to XMLPorts, if you have a developers license then definitely it should allow you to get to the design of the XMLport.
Hi Sbhatbng,
here is my license detail:
Name Amount
1010 Foundation Layer Professional 1
1100 Company 10,000,001
1200 Additional Professional Users 31
1400 User IDs & Passwords 1
1410 Permissions 1
1520 Windows NT (Intel) 1
1750 C/OCX 1
1800 C/FRONT 1
2010 Microsoft SQL Server Option 1
2110 - Attain Version 3.00 & 3.01 1
2120: Navision 4.xx 1
3010 Basic General Ledger Professional 1
3030 Budgets 1
3040 Account Schedules 1
3050 Consolidations 1
3060 Responsibility Centers 1
3080 Change Log 1
3260 Basic Receivables 1
3270 Sales Invoicing 1
3280 Sales Order Management 1
3290 Sales Invoice Discounts 1
3300 Customer / Item Discounts 1
3310 Alternative Ship-To Addresses 1
3350 Sales Return Order Management 1
3360 Calendars 1
3370 Sales Line Discounting 1
3380 Sales Line Pricing 1
3510 Basic Payables 1
3520 Purchase Invoicing 1
3530 Purchase Orders Management 1
3540 Purchase Invoice Discount 1
3550 Requisition Management 1
3570 Purchase Return Order Management 1
3580 Purchase Line Discounting 1
3590 Purchase Line Pricing 1
3760 Multiple Currencies 1
3780 Salespeople/Purchasers 1
3800 Extended Text 1
4010 Basic Inventory 1
4030 Multiple Sales Prices 1
4040 Multiple Locations 1
4045 Stockkeeping Units 1
4050 Alternative Vendors 1
4080 Sales Quantity Discounts 1
4090 Purchase Quantity Discounts 1
4100 Location Transfers 1
4120 Item Cross Reference 1
4140 Item Tracking 1
4150 Item Charges 1
4170 Bin 1
4180 Put Away 1
4190 Warehouse Receipt 1
4200 Pick 1
4210 Warehouse Shipment 1
4260 Basic Resources 1
4270 Capacity Management 1
4280 Multiple Sales Prices 1
4610 Warehouse Management 1
4620 Warehouse Management Systems 1
4760 Basic Dimensions 1
4770 Reason Codes 1
4780 Advanced Dimensions 1
5010 Bank Account Management 1
5030 Reconciliation 1
5200 Smart Tag Integration Toolkit 1
5260 Basic Fixed Assets 1
5280 Fixed Assets Maintenance 1
5290 Fixed Assets Allocations 1
5300 Fixed Assets Reclassifications 1
5410 Production Orders 1
5420 Production Bill of Materials 1
5430 Version Management 1
5760 Basic Human Resources 1
5805 Agile Manfacturing 1
5810 Basic Supply Planning 1
5910 Service Order Management 1
5911 Service Order Management 1
5912 Service Price Management 1
5921 Service Item Management 1
5930 Service Contract Management 1
5931 Service Contract Management 1
5941 Planning and Dispatching 1
5950 Job Scheduling 1
7110 Report and Dataport Designer 1
7120 Form and Page Designer (includes 100 Pages & Forms) 1
7130 Table Designer 1
7140 XML Port Designer 1
7200 Application Builder 1
8200 Tables (10) 100
8300 Forms and Pages (100) 100
8400 Reports (100) 200
8500 Dataport (100) 100
8600 Codeunits (100) 100
99000770 Manufacturing Basic 1
99000780 Manufacturing Supply Planning 1
99001905 Advanced Distribution Common 1
99001910 Advanced Distribution Customers Returns Authoriza 1
99001950 Advanced Distribution Contract Pricing 1
99001970 Advanced Distribution Location Transfers 1
99004710 Euro Conversion Tool 1
Country Code: 1
I did see XML Port Designer in my license info…
You will then have to check and see if you have permission to read the Prod. bom header and Prod. bom line table. Go to Tables and try to run the table prod. bom header and prod. bom line from object designer and see if you can open the table, if you cannot run the table then you don’t have permission to run the table. If yours or your customers license has access to the object then it would be the table data.
i can run the table and see all the data inside.
What is the object no. you are giving to create your xmlport?
Hi sbhatbng,
I not yet create xmlport, i just want to view the design for xml port but the error shows up.
I am now figure another way round, using “Dataport”… still research on how to do it
As you have Dataports you can use dataports to import the data. You just line up your fields and bring them in, as simple as that for both Prod. bom header and Prod. bom line.
yeap… another thing for me to research is if,
when they create a new production BOM no, did it link to ITEM card as well… or anything need to do in ITEM card as well.
Another thing is if i import from dataport, will it affect the current Production BOM table’s data or not…
not a easy job for me… T_T