Solved

dynamics gp fifo inventory layers

Posted on 2013-06-19
4
132 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 94

Accepted Solution

by:
John Hurst earned 500 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 94

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

749 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