Skip to main content
Solved

BoM Time Format Imports

  • December 6, 2022
  • 2 replies
  • 178 views
Michaelh
Pro III
Forum|alt.badge.img+3

What format is needed to import time into a BoM? The format it exports out as, does not match up with the import. For example if you export a BoM you would get something like: 1 d 09 h 07 m

If you attempt to import that, you won’t get the same result. Anyone know how we should be importing these?

Best answer by Michaelh

I found the answer: The system will take an integer value in MINUTES, so clever use of find() and/or left() and right() in Excel can get you where you need to be. If there is an easier method, please let me know!

Permanent Newb, don't let the posts fool you.

2 replies

Michaelh
Pro III
Forum|alt.badge.img+3
  • Michaelh
  • Author
  • Pro III
  • Answer
  • December 6, 2022

I found the answer: The system will take an integer value in MINUTES, so clever use of find() and/or left() and right() in Excel can get you where you need to be. If there is an easier method, please let me know!

Permanent Newb, don't let the posts fool you.
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • December 6, 2022

    Thank you for sharing your solution with the community @Michael Hansen !

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved