webERP Forum
Units in GL Transactions - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Units in GL Transactions (/showthread.php?tid=8202)



Units in GL Transactions - VortecCPI - 09-04-2018

Just an idea... I think it would be nice to have Units in the GLTrans table...

For example this:

"Issue 5.0 of GW50855 to department Marketing Promotion from ENG"

Might be a little nicer as:

"Issue 5.0 GA of GW50855 to department Marketing Promotion from ENG"

In this way if the Units for an Item changes we have record in the GLTrans table.

Thoughts? Problems?
Also...

StockMoves table does not include Units. Might be nice to add it there as well as Units could change...


RE: Units in GL Transactions - TimSchofield - 09-05-2018

I am not sure that units should change once there are stock movements for an item, this leads to all sorts of issues elsewhere.

That said including the units in the GL transaction description would be a good idea. However the field should probably be expanded in size as some hosting companies have the sqlmode for mysql set to reject any transaction where the string being input is greater than the field size, rather than truncating it.

Tim