Zero cost layers. Got ‘em? Know why? Me either....

We’re running on Visual 7.0, actual cost, FIFO by part location.  We changed from FIFO by part to FIFO by part location with our Infor Channel Partner over a year ago. 

Since that time, we’ve had some unexplained $0 cost layers with some of our parts.  When we find them, we verify that part maintenance has a cost, and that the end-user didn’t blank out the cost field on an adjust in to inventory.  Upon further research with Infor’s technical support, Infor believes some of these cost layers are related to driving locations negative with auto-issue, and then doing issue/returns of work orders to put the quantity on the location back to zero.  Since the adjust out drove the location negative, there is no cost with that transaction.  The issue/return makes the quantity in the location 0, but there is no cost with this transaction either, as there is no transactions in the location to use as a cost basis. 

Infor10 Visual ERP Express - Confused

Sound confusing?  (You may need to re-read that last paragraph more than once!!)

Infor recommends backdating an adjust in to the location, before the date of the first transaction that drove the location negative, and then an adjust out of the location after the issue/return date.  The adjust in and adjust out quantity have to be larger than the initial transaction that drove the location negative, but must match each other to keep our inventory count the same. 

Is this how you have handled similar situations?  If not, how would you fix them?


Peter Boers is our special guest author at visualnuggets.com and is an active participant in the VISUAL community.  Peter has recently taken on the responsibility for maintaining the web site for the newly formed Visual Enterprise Global User Group (VEGUG).

Connect with him online at LinkedIn 

 

TrackBack

TrackBack URL for this entry:
https://www.typepad.com/services/trackback/6a01053702bb53970c0177429b37a3970d

Listed below are links to weblogs that reference Zero cost layers. Got ‘em? Know why? Me either....:

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

The comments to this entry are closed.

WHO IS VISUALNUGGETS?

Rich Ferlatte
Results Driven VISUAL Specialist

CONSULTING SERVICES

Of course, I am available for hire!

ERP Implementations & Upgrades
Analytics & Reporting
Integrations & Macros
General VISUAL Support

ONLINE VISUAL WORKSHOPS

Taking it to the next level and designing a program around "Hands On VISUAL Training".

Check them out - there's sure to be one to interest you!

Operational Workshops
Reporting Workshops
Financial Workshops
Inventory Workshops
Quality Workshops

VISUAL EXTENSIONS

BOM Xploder
Drastically improve your BOM visibility and discover shortages at ANY level of your bill of material no matter how deep.
SmartViews
See, analyze, and track information that helps you better support individual, departmental, and your company’s performance metrics and goals.
eBoard - Financial Power App
Developed for accounting professionals looking for powerful and easy-to-use GL reporting software. Access live financial data, drill down to support details and export financial statements to Excel in one click.
Inventory App
This Inventory Reconciliation App provides a systematic approach to control and manage your Visual inventory effectively and efficiently
Credit Card Integration
Easily accept and process credit card payments right from within VISUAL.
ACH Document Processing
Leveraging VISUAL's payment scheduling and batch payment functions, with the added convenience, performance, and security of Electronic Funds Transfer payment processing.
Latitude Manifest & Shipping System
A seamless multi-carrier shipping solution that integrates to Infor VISUAL ERP. See how it can simplify your small parcel and LTL shipping and package tracking.
Sales Tax Automation with AvaTax
Easily automate sales and use tax in VISUAL with AvaTax. No more manually entering data or uploading rate tables and tax information.
Workforce Management with Kebrite Solutions
Streamlines the collection of Job, Labor, Payroll, Time & Attendance, and a vast array of HR related data-- with live VISUAL integration.