import data from excel to navision production BOM

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.
  • In reply to sbhatbng:

    Hi, how to do that, any guide?
  • In reply to jliang84:

    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.
  • In reply to Yuneek Singh:

    Hi Yuneek Singh, how to do that? any guide / tutorial regarding this?
  • In reply to jliang84:

    Look at the existing xmlport and you will have to build on your own.
  • In reply to sbhatbng:

    Hi sbhatbng,

    i tried to access xmlport but i am facing this error when want to see the "design"

  • In reply to jliang84:

    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.
  • In reply to sbhatbng:

    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....
  • In reply to jliang84:

    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.
  • In reply to sbhatbng:

    i can run the table and see all the data inside.
  • In reply to jliang84:

    What is the object no. you are giving to create your xmlport?
  • In reply to sbhatbng:

    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
  • In reply to jliang84:

    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.
  • In reply to sbhatbng:

    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
Related