Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
Currently the stock transaction reports are lacking in that they do not provide monetary information, nor do they provide negative values for goods out transactions or subtotal or grand totals.
Any customer wishing to investigate their stock ledger, for example as part of reconciliation between stock and nominal ledger, have to rely on having the standard reports amended or have bespoke reporting set up to be able to get something as simple as a list of transactions for a date range with a value that can then be compared to an equivalent report in the nominal ledger.
In essence we need to be able to mirror the transactions that make up the nominal with the stock. So for example we need to be able to generate a transaction report that provides us with the equivalent of a nominal report filtered on source 6. This way the end user should be able to reconcile their own accounts (with the exception of POP type entries).
Given that Sage200 was based on the (good old) Line100/Sovreign where we did have such reports, end users were trained in reporting each month and reconciling to the various sources or types of transctions, for example cost of sales used to be a sales report where we would check the total cost column in stock control versus nominal cost of sales.
The lack of quality reporting within the software has resulted in many companies not being able to verify the totals their stock should be.
This should be a basic accounting practice, which seems sadly lost.
Idea Benefit | Improved reportability across stock control. |
How do you solve for this problem today? | Amend existing reports or set up bespoke reporting |
Product Variant | Sage 200 Professional (SPC), Sage 200 Professional |
Just a note - I recently tried to create a sales report based on transaction type 15 and 16 in stock history - the problem is that the sales value is stock history is unreliable and can be a random figure
I also tried to link stock history to SOP data but this is impossible (unless your customer can guarantee that any one stock item will only appear once on any dispatch)
After many hours of data investigation, I scrapped the reports and rebuilt them based on SOP data
The stock history really could do with the ID of the related SOP or POP record (e.g. SOP Despatch Line ID or SOP Invoice Line ID)