Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Units in GL Transactions
09-04-2018, 10:02 PM, (This post was last modified: 09-04-2018, 10:11 PM by VortecCPI.)
#1
Units in GL Transactions
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...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
09-05-2018, 12:56 AM,
#2
RE: Units in GL Transactions
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)