Software Business Logic Help
Hello there,
I have a frame which shows the users a list of products and the available qty in the warehouse of the main branch. now the user will can enter the qty it wants to send to another branch office. I need to then update the MBranchProductQty table accordingly. can somebody please help me to achieve this in the best way.see attachement for more details. I am using sql server 2008 as db and GWT for development.
cheers
Zolf
3-25-2014-12-09-03-PM.gif
3-25-2014-12-10-36-PM.gif
I have a frame which shows the users a list of products and the available qty in the warehouse of the main branch. now the user will can enter the qty it wants to send to another branch office. I need to then update the MBranchProductQty table accordingly. can somebody please help me to achieve this in the best way.see attachement for more details. I am using sql server 2008 as db and GWT for development.
cheers
Zolf
3-25-2014-12-09-03-PM.gif
3-25-2014-12-10-36-PM.gif
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
The thought is that something like this:
Create another location called - In Transit.
The transaction is in GL terms:
Credit source location
Debit In Transit.
When stock arrives,
Credit In Transit
Debit destination location.
HTH
David
The thought is that something like this:
Create another location called - In Transit.
The transaction is in GL terms:
Credit source location
Debit In Transit.
When stock arrives,
Credit In Transit
Debit destination location.
HTH
David
ASKER
David, thanks for your comments.
what do you mean by another location.do you mean table or column. can you please explain in more details with reference to the tables I have.
what do you mean by another location.do you mean table or column. can you please explain in more details with reference to the tables I have.
It all depends on the meanings of the columns in your table(s), and how they are used by your applications.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Another problem I have is how do I update that product in that MBranchProductQty table. I mean I need to reduce the qty once it is gone out of that warehouse. Do I create a new record in that table or some other method which you know of.