Fixed Asset Bar Code Scanning

  • 28 August 2020
  • 9 replies
  • 447 views

Userlevel 4
Badge

We have a customer with thousands of fixed assets across multiple locations. They have assets tags on all of the items and need a method to perform a phyisical on the assets by location that can be reconcilied to Acumatica Fixed Assets.

Has anyone come across a good third party solution, customization or method within Acumatica for performing a physical on fixed assets using bar code scanners for reconciliation/adjustment to the Acumatica Fixed Assets module?


9 replies

Userlevel 2
Badge

Hi Joel

Have you found a solution yet?

Userlevel 4
Badge

@apretorius62 I have not found an integrated solution.  I have come across several external applications for bar code scanning that capture data to a spreadsheet or Google Doc which can then be used to import into a custom table in Acumatica for comparison to Fixed Assets via GI. The customer has pushed pause on the project for now.

Let me know if you come across another solution. 

Userlevel 7
Badge +11

Hi @jgress 

Since physical count functionality and the option to manage stock is available with ‘Stock items’ at present, here is just a workaround that came to my mind. 

-Setup stock item ( easy to export asset code from Fixed asset screen, set up an asset class on item class, use an import scenario to import into Stock item screen) for each asset

-Set asset tags as alternate ID (if that is what is mentioned on the barcode which needs to be scanned)

-Setup exclusive locations (warehouse) for use of asset items only

-One can use a Physical count to bring initial quantity to various locations ( zero cost as the entire exercise is to keep track of quantity)

-Set a restriction group for all these stock items to ensure it's not visible to any user on any lookup screens.  Enable access only for the physical count and required user who needs to check the numbers

-Set restriction group to restrict access to the warehouse used for Assets

Hope this may help. 

Regards,

 

 

Badge

Long-overdue that Acumatica actually includes this in a release!!

 

Userlevel 4
Badge

@vkumar, Thank you for the suggestion.  I like that you are trying to use the existing Acumatica functionality.  It does seem like a lot of effort and additional transactions to validate Fixed Assets.  It also does not update the Fixed Asset for location or existence.  In addition, many customers running Fixed Assets do not have the Inventory module. 

I agree with @Jp89 that this functionality is something Acumatica is long overdue in providing.

Userlevel 7
Badge +8

Acumatica delivers features and enhancements according to their priority for the product and the popularity of the idea itself. You may encourage partners and customers who need this to vote for it so it would appear in our roadmap.

Badge

Voting is not the only way to go - compare our products to competing products that offer this functionality / feature as a standard already!

 

Has anyone found a solution for this?

Userlevel 4
Badge

@mikeranes44,  I spoke with Xtramile Soft about creating a solution.  The customer has not moved forward yet.  https://xtramilesoft.com/ They will be in the expo at Summit.

Reply


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