Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


SBT - Iciqty

SBT - Iciqty

SBT - Iciqty

i'm a new user in SBT, can i just ask what's the use of Qtmaloc in Iciqty table?

RE: SBT - Iciqty

Hey ellah24bry,
What version of SBT are you using?

RE: SBT - Iciqty

Hello Sir,
I'm still using the old sbt, 5.0. I was just wondering, why it has a value even after the transaction is made.

RE: SBT - Iciqty

i mean, this should return to Zero after every transaction, why it has more than 1 quantity?

RE: SBT - Iciqty

Qtmaloc is a temporary field used to hold temporary transactions based on the stock units. It has no use for report purposes. Not completed transactions, lock ups or SBT programming ( forgot to clear it) may leave data. It should be cleared after a transaction.

RE: SBT - Iciqty

so, should i change it back to zero? manually?

i really appreciate it


RE: SBT - Iciqty

You can, however you will wasting your time. It gets overwritten.

RE: SBT - Iciqty

how about making a program that validates it? if is has more than 1 quantity, it changes back to zero?

RE: SBT - Iciqty

It is a temporary file that shows sales order allocations of items while a sales order is being written but before it is saved. As someone wrote above, it should be zero most of the time. If no one is writing a sales order and it is non-zero, this is wrong. It usually indicates a crash by someone while writing a sales order or a poorly-written modification.

The Recalc Application Balances program in System Manager knocks this number down when it is erroneously non-zero. But you have to kick everyone out of SBT to run this utility program. Best to fix once and trace the problem to its source.

Matthew Lefkowitz
Lefkowitz Systems, Inc.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close