Skip to main content

changes for stf


  • 1. stf transactions (data entry) over the intranet had problems when solomon tries to do a "release now" action.

  • 2. further analysis by LPE shows that the intranet module hasn't completely emulated the "transfers" transaction of solomon, in that the items transferred did not have corresponding serialized entries in LotSerT

  • 3. relations: Batch 1:1 TrnsfrDoc, Batch 1:n INTran, INTran 1:n LotSerT

  • 4. look up for LotSerT.LotSerNbr will come from LotSerMst (where all serialized items are built up)

  • 5. SELECT LotSerNbr FROM LotSerMst WHERE InvtId='1002122' AND SiteId='LOG-MCS' AND Status = 'A' AND WhseLoc='MAIN' AND QtyOnHand > 0 ORDER BY LotSerNbr ASC

Comments

Post a Comment

Popular posts from this blog

Uncle Bong in SG

It's been over two decades since I last saw Uncle Bong. He would usually drop by Diamond Village in Novaliches, Quezon City to visit Lola Magding and my mother's side of the family there. Back then, I was still in college, and I think he had also just started working, in the automotive industry. He has since worked in cruise ships and it was a good stroke of fortune when he told me that they would be dry-docking in Singapore. Mama's side has always been close-knit and could see the fondness in his eyes as he recalled his dealings with Lola Magding and her children, Mama included. He would then share stories of how many of our relatives emigrated off the "isla" to find better opportunities in Manila. Given the brief opportunity, I'm still blessed to have seen him again after all these years. I am also happy that he was able to meet Mae and his "apos". Until we next see each other, Uncle Bong!
Post a Comment
Read more

Valentine Surprise

Each year, on Valentine's day, I usually surprise my darling wife with a letter/card, or a bouquet of roses. As it was a yearly thing, I knew she sort of expected these surprises; she'd look surprised, but I knew she wasn't really. Occasionally, she does get surprised. Like that time back in Cebu when I bought her a rather intricate bouquet of flowers. Her head spun when she found out how much I paid for it. Surprise! This year, however, is different. I was not able to prepare anything for her. I didn't get her anything, thinking that I'd just make up for it with dinner, or something. Yes, I didn't plan for this and I feel lousy actually. Last night, after my daughter gave me and my wife her home-made Valentine greeting cards, my wife started chiding me about what I was going to give her the next day. I gave her my usual "I'm not telling" smile and silently kicked myself. I wished I already had something ready, and I found myself already longing fo...
4 comments
Read more