SysFeatureAreaLogging - Add Reference

Probably should be a separate idea, but it would also be really useful to have the SessionInfoID (as per the config DB)

We see data inconsistency problems usually related to uses doing an action and reversing it multiple times (e.g. PO receipt) - I would like to be able to tell whether these actions are all within the one client session and which PC they were using

I have just noticed that you have already implemented a similar thing for tblAudit in the config database

The tblAudit table has two additional fields - AuditObjectID and AuditObjectDescription

You use this for e.g. add new company (AuditEventType "Company created") where the fields store 20 and company name respectively

Thanks Jo - The more I think about this, the less likely it seems that anything could be done

Generally the Sage form is blank when it is closed and the record written to SysFeatureAreaLogging - the form being closed could have been used to create several orders, order lines or assign multiple batch identification numbers

When entering traceable data, the order no and item code are fixed and would be the type of information I would want to see, when entering an order line, the order no is fixed .... so in general there is a parent reference that could be picked up and stored

thanks for clarifying that, it helps with us understanding the ask

Hi Jo

I have a customer where the TraceableItem / TraceableBinItem allocated quantity is out of balance and the TraceableBinItem also has a phantom QuantityReserve against the record

I am trying to piece together how these errors occur and one option is to try to follow thier actions via the SysFeatureAreaLogging data

This works to an extend as I can tell which forms they opened but I feel that it would provide me with so much more information if there were also some sort of indicators giving clues as to which document number, which product or which traceable ID No were being used

In many instances it would be possible to store suitable additional information in an additional text field

I don't expect any perfect solution, or anything that links to other records - just some additional information to give me additional clues, maybe multiple values could be stored in the one field, and it would be up to the consultant to work out what those values refer to

Thanks

Andrew

thanks for the idea, can i just check that what you're looking for here is more around an audit trail of activity?

I can see that there are problems, what reference is expect on a new form when multiple orders can be added etc.

I also view the records in DateTimeOfOpen, (This is the only way to see the child forms after the parent form)

Though new order is opened first, it is the last form to be closed and logged.

There is still an unique record for each Sage.MMS.SOP.SalesOrderConfirmationForm

Note that I mean a new generic text field ... not specifically SO NO