Forum Stats

  • 3,679,583 Users
  • 57,524 Discussions
  • 190,820 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
NetSuite Maintenance - September 25
Please note that on Saturday, September 25, 2021, at 10:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 180 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Cheers to 1️⃣0️⃣ years of #SuiteWorld! 🎉 We’re celebrating by extending the Super Saver Pass AND launching the digital On Air experience TODAY! Whether you join us in-person or digitally, we can’t wait to make even more memories with you. https://lnkd.in/dGpPpmUV
Webinar | COSTING 101: Learning the Basics of Inventory Costing webinar was a success! Please take a minute to fill out this short survey. For those who missed it - Don't worry! Here's the link to the recorded session!
NetSuite Support Assistant: A quicker way to get answers to your basic NetSuite questions
The NetSuite Support Assistant is a convenient chatbot SuiteApp that provides quick responses to your basic questions directly from your NetSuite Account.
Click NetSuite Support Assistant Now Available for more details.
Release Preview 2021.2

If you would like to receive a 2021.2 Release Preview account, please opt -in to take advantage of the Release Preview access period to prepare and become familiar with the new NetSuite capabilities. For details, see Requesting a Release Preview Account.

If you receive a Release Preview account in 2021.2, you can access it several weeks before your production account is scheduled for an upgrade to the new release of NetSuite. Notifications with details about Release Preview availability are sent to the account administrators as described in Release Preview Notifications. Release Preview availability information is also posted on the New Release portlet.

how to map csv to update landed costs on inbound shipment

Mat O2F
Mat O2F Member, forum_userscommunity_users Posts: 27 Red Ribbon

Dear all,

i try to update vis csv import the landed cost on on inbound shipment, in order to save time and to avoid to have to go on eache line of the inbound shipment manually

i have the mapping below, where i put the PO internatl,

regarding the items/associated items, i put the ID i can read on the inbound shipment :

i don't succeed to update it, get the error message "an unexpected error has occured"

have somebody an example of template to update via csv the landed on a inbound shipment ?

thanks in advance for your support

regards

MAtthieu E

Best Answers

  • Joy Noreen Magoling-Oracle
    Joy Noreen Magoling-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 479 Bronze Trophy
    edited Jul 10, 2021 10:21AM 192.188.170.87 Accepted Answer

    Hello @Mat O2F,

    I tried to perform a CSV Import to update the Landed Cost in my existing Inbound Shipment using this CSV format below:

    I was able to successfully perform the import without any error. Can you try using this format if this will work on your end? Just make sure that the values for Associated Items must be exactly the same as how it appears in the UI to avoid errors.

    Let us know how it goes. 😊

    Thank you!

    -Joy

    ===============

    If you find the reply to your question helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies.

  • Joy Noreen Magoling-Oracle
    Joy Noreen Magoling-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 479 Bronze Trophy

    You're welcome, @Mat O2F!

    Glad that it seems to work now.

    It would be great too if you can mark "Yes" in the "Did this answer the question?" for the comment which helped you so that other members who might have the same concern can easily refer to it for the solution. 😊

    Thanks and regards,

    Joy

Answers

  • Mikko De La Fuente-Oracle
    Mikko De La Fuente-Oracle forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 1,147 Silver Trophy

    Hi Matthieu @Mat O2F ,

    It's nice to have you again and thank you for posting!

    Our gurus/members will look into your concern and update this thread for any findings.

    Hi @Joy Noreen Magoling-Oracle /@Ivy Lopez-Oracle , any thoughts for this one? 🙂

    To everyone, feel free to share your ideas that can help.

    -Mikko

  • Joy Noreen Magoling-Oracle
    Joy Noreen Magoling-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 479 Bronze Trophy
    edited Jul 10, 2021 10:21AM 192.188.170.87 Accepted Answer

    Hello @Mat O2F,

    I tried to perform a CSV Import to update the Landed Cost in my existing Inbound Shipment using this CSV format below:

    I was able to successfully perform the import without any error. Can you try using this format if this will work on your end? Just make sure that the values for Associated Items must be exactly the same as how it appears in the UI to avoid errors.

    Let us know how it goes. 😊

    Thank you!

    -Joy

    ===============

    If you find the reply to your question helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies.

  • Mat O2F
    Mat O2F Member, forum_userscommunity_users Posts: 27 Red Ribbon

    Hello Joy

    thank you for your feedback. we have a try and it looks to work. thanks !!

    it seems i had too many fields in my file to map.

    thanks a lot

    regards

    Matthieu E

  • Joy Noreen Magoling-Oracle
    Joy Noreen Magoling-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 479 Bronze Trophy

    You're welcome, @Mat O2F!

    Glad that it seems to work now.

    It would be great too if you can mark "Yes" in the "Did this answer the question?" for the comment which helped you so that other members who might have the same concern can easily refer to it for the solution. 😊

    Thanks and regards,

    Joy

  • Mat O2F
    Mat O2F Member, forum_userscommunity_users Posts: 27 Red Ribbon

    Hello Joy

    we face an issue on this topic, indeed during the import, the system group the landed cost per model,

    you can see above the example, the expected result and what we have.

    do you have an idea on how to improve the import file to handle it ?

    thanks in advance

    regards

    Matthieu E

  • Joy Noreen Magoling-Oracle
    Joy Noreen Magoling-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 479 Bronze Trophy

    Hello @Mat O2F ,

    Apologies for getting back to you on this only at this moment. Allow me to look into this further. But if you could also share the actual CSV format and field mapping you used, it will be really helpful. Just make sure to keep confidential information hidden.

    Thanks and regards,

    Joy

  • Mat O2F
    Mat O2F Member, forum_userscommunity_users Posts: 27 Red Ribbon

    hello Joy

    thank you for your feedback. please find below the csv file i use, the mapping.

    it still doesn't work

    and the mapping i use

    i have a mistake with the item, i get the error message : "Invalid shipmentitem reference key POP N8 E5000.GRIS-PERLE.26T43 for purchaseorder <NULL>."

    i'm not sure i'm in the right way in the mapping, as i told before we have several location for one model, and we need to have taxes/transportations cost for each line

    thanks in advance for your help

    regards

    Matthieu E

  • Mat O2F
    Mat O2F Member, forum_userscommunity_users Posts: 27 Red Ribbon

    Hello @Joy Noreen Magoling-Oracle

    i wonder if you have been able to have a look to my import issue,

    it would be very helpful !

    thanks in advance

    Matthieu E

  • Joy Noreen Magoling-Oracle
    Joy Noreen Magoling-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 479 Bronze Trophy

    Hello @Mat O2F,

    I'm currently performing tests on this and hopefully I'll be able to come up with an improved import file that can handle this issue. Will update you immediately once the results are available.

    Apologies for getting back to you on this only at this moment.


    Thanks and regards,

    Joy