Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
09-05-2018, 12:56 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)