Inventory Processing

The following is a discussion of considerations pertinent to Inventory Processing within the Abacus 21 System-441.

The examples presented below represent a typical implementation (commenting of F/B and Retail and Other -- but focusing on Food/Beverage)... but may be different from what might be suitable for your particular Installation.

Consult your Abacus 21 Installation Manager for further information on the proper Setups for your Installation.

Inventory Processing Segments Illustrated:

• Beginning Positions

• Purchasing-Receiving (from Purveyor into Commissary)

• Requisition from Commissary to Raw Bar

• Transfer from Raw Bar to Burgee Bar

• Adjustment in Raw Bar for a Broken Bottle

• General Ledger Ramifications

• Physical Inventory at the Commissary

Beginning Positions -

Inventory Item:  13001 Veuve Champagne

Commissary Outlet:   Beginning situation -(there is only one Location in this Outlet where this Item can be – namely, the ‘Wine Storage’ room):

Note:  The ‘Sort’ field(in this case a Bin Number) is a tag-along field [not a discrete sub-location… which would be another Location] that is used for Physical Inventory sorting-organization purposes.  This field is 6-characters long.

The prevailing Last-Cost and Weighted-Average-Cost (per Bottle) is $42.00:

Raw Bar Outlet:  Beginning Situation -

Note:  This particular Champagne is also used in some of the Food Recipes (which are done in the Raw Bar’s “Food” Location.

• If the Champagne were ‘inventoried’ in the Food-preparation area, then it should be established as an alternative Location – perhaps treated as a ‘Food’ Inventory Account.

• However, it more than likely that any of this Wine that is transferred to the Food preparation area (the Kitchen of the Raw Bar), it is “expensed”.  In this case, it is not necessary to establish (ie, create) the Item in the “Raw Bar – Food” Location… as in can automatically be expensed upon Requisition Transfer to that Location.

• If an Item is transferred to an Outlet-Location where it does not exist, the system first tries to “match” the Item’s Distribution-Code for the target Outlet-Location.  If that Distribution-Code exists in the target Oultet-Location, it is used as the “default” for determining the “inventory” account to use – typically an Expense Account.  This default Distribution-Code can be overridden if desired.

• If it can’t find the Item’s originating Outlet-Location’s Distribution-Code in the target Outlet-Location, it prompts for the User to enter one.

Burgee Bar:   Beginning Situation –

Purchasing & Receiving (from Purveyor ‘Napa’ into the ‘Commissary’):

P/O Entry –

In the course of creating this Order, a Purveyor Contract was established:

Requisition from Commissary to Raw Bar –

Inventory Position in Commissary:

Transfer from Raw Bar to Burgee Bar -

Adjusting Inventory (for a Broken Bottle) – (ADJ-AE)

General Ledger Ramifications –

Physical Inventory at the Commissary –