Solved

dynamics gp fifo inventory layers

Posted on 2013-06-19
4
124 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 91

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 91

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Outlook 2010 toolbar 5 47
MS Office for new laptops 9 27
Office 2013 User error 4 43
When trying to export from Arena the file is not opening in Excel 6 92
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 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 edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now