Skip to main content
Answer

BoM Time Format Imports

  • December 6, 2022
  • 2 replies
  • 114 views
Michaelh
Pro I
Forum|alt.badge.img+2

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 I
Forum|alt.badge.img+2
  • Michaelh
  • Author
  • Pro I
  • 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
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 & ConditionsCookie settingsAccessibility 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