Stock - Closing a Stock

INTRODUCTION

When a company wants to manage the stock file it is important to understand how this works from deleting, suspending and closing.

Yes! Only if the following is true; there has been no movements against the code. No sales, credits, purchases etc.

A user would suspend a stock code if there is a positive quantity remaining.

By suspending this enables the code to be sold but no longer purchased.

The code can then be put on a promotion to clear the stock.

To close a stock code the following conditions need to be matched:

There cannot be a positive or negative qty. If, so then an adjustment will need to be done before closing.
There can be no stock assigned to a purchase order where goods are waiting to be received or goods have been received and an invoice needs be linked to the PO
If the above is true a message will appear in Agility.

Use the following query to identify the PO:

select d.PONUM

from ACOCMP1.ophdtran h,ACOCMP1.opittran d

where h.ponum = d.ponum and h.status <> 'C'

--Change the stock code below keeping inside the 'code'

and d.stkcode = 'R0048652'

Resolve the above and the code can be closed

Related Articles
Stock - Stock Requirements
INTRODUCTION Agility Professional has the feature that begins to calculate stock which is being sold and therefore provides information for ordering stock levels. Best practice is to start with a small supplier as there a number of things that need ...
Stock - Browse Stock
INTRODUCTION In Agility browse stock gives the user the ability to search for stock in many different ways: Stock Code, Description, Preferred supplier and preferred supplier code, barcode, Department, Category, Group, Type, Job/Project and Analysis ...
Stock - Stock Item Maintenance
INTRODUCTION There are different ways to create a stock codes in agility professional; create a code through POS, raising a Purchase Order, browse suppliers and select a button Stock Quick Set Up and by going to Stock\Ledger Maintenance\Stock Item ...
Stock - Stock Import
Stock Import Introduction In Agility there are features that enable the importing of new stock codes, updating current stock codes and changing prices. Here is a list of ALL items which can be imported but not ALL are required. Items highlighted are ...
Stock - Stock Item Maintenance - Buy Price Tab
INTRODUCTION Once a stock code has been created this can then be maintained by going to Stock\Ledger Maintenance\Stock Item Maintenance\Stock Items or by selecting the shortcut on the menu. From this screen a codes can also be created and there are ...