Solved

BoM Time Format Imports

  • 6 December 2022
  • 2 replies
  • 66 views
Michaelh
Rank
Userlevel 5
Badge

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?

icon

Best answer by Michaelh 6 December 2022, 19:06

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

2 replies

Chris Hackett
Rank
Userlevel 7
Badge

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*.
Michaelh
Rank
Userlevel 5
Badge

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.

Reply


Terms & ConditionsCookie settings
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