We did promise more added value to Pegasus Opera users, here’s a start …
Did you ever want to recalculate In Stock quantities across your Pegasus Opera data? Well now you can, simple!
The ever-popular Data Manager for Pegasus Opera, which offers a broad range of tools for manipulating & updating your data from standard Microsoft Excel worksheets now has a new tool added – its simply called “Recalculate”
The utility requires licensing for both the XL Reports framework and Data Manager and allows warehouse managers to force the recalculation of in-stock quantities from the stock transaction file.
Things must add up!
Just like any Debtors or Creditors Ledger card, the quantity of goods recorded as being “in stock” should be a function of the total Receipts less the total Issues (write-off’s etc.) – on a per warehouse basis. However, the reality for a lot of Pegasus users is that, for many reasons, the stock figures are inaccurate and can often produce different results for quantity depending on how valuations/counts are conducted, e.g. FIFO, non-FIFO etc.
The open-design of Pegasus Opera has both advantages & disadvantages.
We are not for one minute suggesting the Pegasus Opera doesn’t count stocks correctly, of course it does. However, as Pegasus Opera uses an ‘open design’ database many end users have had custom or ‘back door’ updates of their stock, maybe during initial setup or during some upgrade. It is also the case that many updates carried out on end user data have not been completed properly, maybe due to lack of knowledge, maybe due to too much haste etc. On the other hand, it is this ‘open design’ that is one of the more popular aspects of the Pegasus Opera suite of accounting, distribution and inventory applications. Approximately 50% of Pegasus users are in wholesale, distribution and/or need good warehouse management.
Whatever the reason for inconsistency in the stock data, it can now be fixed and very quickly and simply.
This same Recalculate Utility also includes a routine for the recalculation of Sales and Purchase Order balances across both the stock data and the Sales and Purchase Order processing systems.
