Solved

dynamics gp fifo inventory layers

Posted on 2013-06-19
4
135 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 95

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 95

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

Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

737 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