PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Collapse]Goods
     Stock reports
    [Expand]Issue
    [Expand]Receiving
    [Expand]SAD/Intrastat
    [Expand]Interwarehouse Transfer
    [Expand]Price Change
    [Collapse]Inventory
      Import prices
      Reconciling an Inventory
      Inventory when Switching to Tracking by Serial Numbers
      Inventory of Items Tracked by Serial Numbers
      Creating an Inventory Document
     Recurring Invoicing
    [Expand]Consignment
    [Expand]Value-Added Tax
    [Expand]Customs Warehouses
    [Expand]Issuing Retail Invoices
    [Expand]Stock Valuation
    [Expand]Monitoring Exchange Rates
    [Expand]Goods on Trial
    [Expand]Item Type Examples
    [Expand]Vnos dokumentov z uporabo EM2
    [Expand]Separate Sale Pricing by Warehouse
    [Expand]eSlog
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 374.9904 ms
"
  3145 | 3624 | 337422 | Updated
Label

Reconciling an Inventory

Reconciling an Inventory

Reconciling an Inventory

010379.gif010380.gif010381.gif010411.gif010382.gif010383.gif

With the Pantheon program package, you can take inventory at the end of the year or for shorter accounting periods.

 

The process for taking inventory will be described below.

1. Enter information

Differences between the actual, physical inventory as determined by an inventory count and warehouse records can be found using the Inventory Count module. There are two ways to enter information in the module:

a.) An inventory count sheet can be entered directly in the program (using portable scanners, by direct entry or by scanning).

b.) You can create an inventory  count sheet by taking an inventory count on paper and entering it in the program.

2. Compare Inventories

Once an inventory count has been taken and entered in the program, it must be compared with the program's records. You will be comparing the actual, physical inventory with the inventory recorded on warehouse cards.

 

This comparison will reveal any variances between the actual balance and the posted balance. Later, these will be appropriately posted.

3. Reconciling Inventory

The next step is reconciling the inventory. Variances revealed through the inventory count are carefully examined on the level of the entire company. Why?

 

3.1. Excess at One Warehouse, Shortage at Another

During the year you might have made mistakes when using the program. If you're dealing with more than one warehouse, it often happens that you create a receipt or transfer for the wrong warehouse. In this case, the inventory count will reveal an excess at one warehouse and a shortage at another. In order to fix this, you need to create a transfer from the warehouse where the excess was discovered to the warehouse with an inventory shortage.

First, let's take a look at the warehouse card for this item at the warehouse with the shortage. If a warehouse card reveals a negative inventory of the daily stock, you need to create a transfer for before the date the negative stock appears on the warehouse card. This will solve two problems at once: you'll repair the negative stock, and consequently the quantity, of the warehouse with the shortage and also fix the excess at the other warehouse. Of course, you must be careful that the warehouse card at the warehouse with the excess does not show a negative stock following the transfer. Because you can also create multiple transfers, warehouse cards can be balanced through suitable arrangement.

Example

 

At warehouse A there's a shortage of 30 pieces; at warehouse B, there's an excess of 21 pieces.

The warehouse card for article XXX at warehouse A reads:

Date
Document
Receipt
Issue
Stock
1.1.1999 Opened 10 10
12.6.1999 Invoice 993000170 7 3
18.7.1999 Invoice 993000195 5 -2
3.9.1999 Invoice 993000297 28 -30

 

The warehouse card for article XXX at warehouse B reads:

Date
Document
Receipt
Issue
Stock
1.1.1999 Opened 15 15
12.3.1999 Invoice 993000170 3 12
1.7.1999 Invoice 991000104 40 52
3.7.1999 Invoice 993000198 45 7
6.8.1999 Invoice 991000497 60 67

 

As you can see, the stock at warehouse A goes negative on 18.7.1999. You need to create a transfer from warehouse B to warehouse A for before this date. How much will you transfer? The warehouse card of warehouse B shows that there were seven pieces in stock on 18.7.1999, which means that up to seven pieces can be tranferred without creating a negative stock at warehouse B.

With the receipt on 6.8.1999, there's enough stock at warehouse B to create a new transfer with the quantity (21 - 7) pieces.

Let's take a look at the warehouse cards following a reconciliation:

 

The warehouse card for article XXX at warehouse A reads:

Date
Document
Receipt
Issue
Stock
1.1.1999 Opened 10 10
12.6.1999 Invoice 993000170 7 3
18.7.1999 Transfer from  B 7 10
18.7.1999 Invoice 993000195 5 5
6.8.1999 Transfer from B 14 19
3.9.1999 Invoice 993000297 28 -9
 

 

The warehouse card for article XXX at warehouse B reads:

Date
Document
Receipt
Issue
Stock
1.1.1999 Opened 15 15
12.3.1999 Invoice 993000170 3 12
1.7.1999 Invoice 991000104 40 52
3.7.1999 Invoice 993000198 45 7
18.7.1999 Transfer to A 7 0   
6.8.1999 Invoice 991000497 60    60   
6.8.1999 Transfer to A 0    14 46   

 

As you can see, the transfers have partially straightened out the warehouse cards. What do you do now?

3.2 Shortages at a Warehouse

Shortages at a warehouse are a reliable indicator that all necessary documents might not have been entered or that they were entered incorrectly. In this case, you should also start by printing out a warehouse card to see if a negative stock appeared at any time. If you see that it has, you have to clean up the warehouse card (following the instructions for cleaning up warehouse cards) before you can continue your work.

3.3. Excesses at a Warehouse

Excesses at a warehouse could indicate that an inventory count is incorrect, that some issues were not entered, or that some receipts were entered twice. We also recommend that you carefully examine excesses.  

000001.gif

After each change in materials management in the period before the inventory count, you must recalculate variances from the inventory!

 

4. Confirming an Inventory

Once you've reconciled an inventory, excesses and shortages must be appropriately recorded.

For all items with an inventory excess, appropriate excess documents (essentially documents for receipts at the warehouse) must be created. For all items with an inventory shortage, appropriate shortage documents must be created (essentially documents for issues from the warehouse).

 

Documents for excesses and shortages must be created separately for each warehouse used in the program.

Because excess and shortage documents will only balance the physical inventory with the book inventory, they must be appropriately posted in the general ledger.

 

 



 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!