Topic Options
#25552 - 12/28/10 08:13 AM Allow Negative Inventory in I/C?
Kristin Offline
Operations Manager

Registered: 09/08/08
Posts: 68
Loc: Madison, Virginia
Does anyone know of potential issues when the "allow negative inventory" feature is enabled in I/C? We want to use this feature to be able to ship before product can be received in PO, but are not sure how well this works regarding costing etc. Does it create accounting issues if the recent cost is different from the old stock to the new stock?
Any input is appreciated.

Thanks!

Top
#25566 - 12/29/10 09:38 AM Re: Allow Negative Inventory in I/C? [Re: Kristin]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
This method is used by the majority of OE users for the reason stated.

The accounting issues include using the most current price on record in IC, which may not be the new price not yet received in PO. Depending upon the setting in PO any cost adjustment will either go to the remaining stock or to COGS.

When setting up new items make sure you setup a most recent cost or $0.00 will be used if the item is sold before the receipt is posted.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#26017 - 02/01/11 08:39 AM Re: Allow Negative Inventory in I/C? [Re: Douglas Dickie]
Kristin Offline
Operations Manager

Registered: 09/08/08
Posts: 68
Loc: Madison, Virginia
Thanks!

Top
#26027 - 02/01/11 02:22 PM Re: Allow Negative Inventory in I/C? [Re: Kristin]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1738
Loc: Waterloo, Ontario, Canada
Hi,
Actually, if you are setting up a new item and you are using Purchase Orders for Adagio, you do not normally need to set up the recent price with a value.

When you create a PO for an item to order it (to sell or use), the PO price or Cost is updated to the recent cost as soon as you post the PO, if the recent cost value (previously on file) is zero for that item. We put that into Purchase Orders so that you can run the End of Day processing in Order Entry or POA in any order.

Doug was quite correct, that if the recent cost is zero when you process an invoice for an item, it will use $0 as the cost of sales if no items are on hand or the sale goes into negative numbers. However, the above change was implemented to minimize the likelihood of these types of costing errors. The only time it cannot help is if the PO is created with no cost details, and the costs don't get updated until the invoice arrives. Until this feature was available, we did the same as what Doug recommended.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#26031 - 02/01/11 03:02 PM Re: Allow Negative Inventory in I/C? [Re: Brian Stief]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
Brian:

Your theory assumes that a PO is issued prior to the first sale and is setup to update the cost upon posting. I don't always find this to be the case (and you even allude to this) so it's safer to add a cost when creating new items (not to say that I don't love the changes you have made to PO).
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 61 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14465 Topics
70658 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30