Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

dynamics gp fifo inventory layers

Posted on 2013-06-19
4
Medium Priority
?
150 Views
Last Modified: 2015-03-28
i have an issue where I am willing to let my qty on hand go negative on certain items.  The problem i'm seeing in my fifo perp valuation is I invoice the item and then receive it in, that cost layer just hangs there, and seems to be used the next time the item is sold.
That won't work for me as they will perpetually be one off.  It seems it would create an outflow for that item to avoid this issue.
Anyone know if this is how it's supposed to work?
0
Comment
Question by:goss912
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 97

Accepted Solution

by:
John Hurst earned 2000 total points
ID: 39262094
I invoice the item and then receive it in, that cost layer just hangs there

That is the way it is supposed to work (new cost input after inventory zeroed out).

You cannot really sell negative inventory - only bookkeep it. So the way to avoid the issue is to make sure purchases have been put in first. Commonly, you would invoice at the point of shipping - otherwise there is a danger that the customer will see an invoice before they see the product.

Is this retail or manufacturing?  If retail, you can consider using the average inventory cost method which would alleviate this issue.

.... Thinkpads_User
0
 
LVL 11

Expert Comment

by:sparab
ID: 40684376
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 
LVL 97

Expert Comment

by:John Hurst
ID: 40684377
My answer (http:#a39262094) was the correct answer for this. Purchase first and do not have negative inventory.
0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question