Sage 100

 View Only
  • 1.  Interrupted Physical Count Register

    Posted 12-21-2024 00:04

    I was hoping you can help with an issue we're having.  Does anybody know the proper way of clearing the Physical Inventory file when the Physical Count Variance Register posting was interrupted / froze?  The customer has Scanco Multi-Bin.  Thank you and much appreciated.   



    ------------------------------
    Jhiam Marasigan
    Stewart Technologies, Inc.
    ------------------------------


  • 2.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 05:56
    And just so everyone has the whole story - we are trying to post inventory physical count and it is taking forever - like 6 records in 90 minutes when they have almost 40k to post.

    We already tried rebuilding key files with integrity check and optimization on. We just aren’t sure where to go from here.

    Any thoughts or suggestions would be greatly appreciated!


    Sent from my iPhone




  • 3.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 06:06

    Hi!  I had this issue and scanco had to install a patch to fix it. It's actually stuck at the their mb tables. 



    ------------------------------
    Lanette Felsch
    Consultant
    Lanette Felsch Consulting
    ------------------------------



  • 4.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 06:10
    Thank you. That is exactly what we have. It is stuck on the IM_140_MB_Binlocationhistorty table.

    Thank you!

    --
    Tara Morgan Schinkel, CPA
    Stewart Technologies, Inc.
    CFO/ Team Lead for Apps 


    Get the Boomerang Email App on mobile



    ----------





  • 5.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 06:12
    Do you happen to know what version your patch was for and would you be able to share? Our customer is on Sage 2023 PU1. If your customer is on the same version, we might be able to use the patch. 

    --
    Tara Morgan Schinkel, CPA
    Stewart Technologies, Inc.
    CFO/ Team Lead for Apps 


    Get the Boomerang Email App on mobile



    ----------
    On Sat, Dec 21, 2024 at 6:09 AM, Tara Schinkel <tmm@stewarttechnologies.com> wrote:
    Thank you. That is exactly what we have. It is stuck on the IM_140_MB_Binlocationhistorty table.

    Thank you!

    --
    Tara Morgan Schinkel, CPA
    Stewart Technologies, Inc.
    CFO/ Team Lead for Apps 


    Get the Boomerang Email App on mobile



    ----------





  • 6.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 06:21
    It was 2023 premium,  I do not recall the exact  PU 1 or 2. 

    Lanette Felsch 





  • 7.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 06:23
    Shoot ok. I do think program fixes are the same but wouldn't want to gamble it with premium just in case I'm wrong. Thanks for answering on a holiday weekend. Truly appreciate it. 


    Tara Schinkel, CPA,   Accounting Systems Lead & CFO

     

    Stewart Technologies, Inc.

    Champions for your efficiency.

    main: 410.309.9550 x 1104   

    stewarttechnologies.com   |   Follow Stewart Tech on






  • 8.  RE: Interrupted Physical Count Register

    Posted 12-21-2024 06:25
    Of course! I wish I could help more! 

    Lanette Felsch 





  • 9.  RE: Interrupted Physical Count Register

    Posted 12-22-2024 07:55
    That was it - it ended up being a fix from Scanco and kudos to them, they helped us patch it yesterday (on a holiday weekend).

    Thanks for the help and the suggestions. 

    Have a wonderful holiday everyone. 

    Sent from my iPhone

    On Dec 21, 2024, at 6:23 AM, Tara Schinkel <tmm@stewarttechnologies.com> wrote:

    
    Shoot ok. I do think program fixes are the same but wouldn't want to gamble it with premium just in case I'm wrong. Thanks for answering on a holiday weekend. Truly appreciate it. 


    Outlook-qq3xlaeg.png

    Tara Schinkel, CPA,   Accounting Systems Lead & CFO

     

    Stewart Technologies, Inc.

    Champions for your efficiency.

    main: 410.309.9550 x 1104   

    stewarttechnologies.com   |   Follow Stewart Tech on Outlook-zqu11hsn.png






  • 10.  RE: Interrupted Physical Count Register

    Posted 12-22-2024 08:35
    That's fantastic!  I'm glad they jumped on it immediately!  Happy holidays! 
    Lanette Felsch