Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

dynamics gp fifo inventory layers

Posted on 2013-06-19
4
Medium Priority
?
157 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
  • 2
4 Comments
 
LVL 99

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 99

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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
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.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

963 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