Menu

Sales Transactions Input unreponsive

2017-06-17
2017-06-18
  • John Grillot

    John Grillot - 2017-06-17

    I'm using version ACAS (3.00.05). I trying to enter my first Sales
    Transactions Input. I had created one customer but no stock yet (yeah I
    should have created stock but I wanted to see if I could do a transaction
    without a stock # ). I started a transaction and picked the ProForma type.
    On the transaction lines I left the stock# empty and of course got a message
    about an invalid stock number. I entered a qty of 1 and entered 000001 for
    the price. After I hit tab on the price, a bunch of @@@@@@@@@@@@@@@@@@@@@@
    appeared on that line and I couldn't figure out how to exit the screen. I
    had to hit control C. When I relaunched ACAS and picked the Sales
    Transactions Input. The screen menu disappeared but the Sales Transactions
    Input screen did not appear just a blank screen. I'm thinking maybe a file
    was corrupted when I had to do control C the first time on the Sales
    Transactions Input. Is there a file check or rebuild utility. What do you
    suggest I do?

    Thanks,

    John

     
    • John Grillot

      John Grillot - 2017-06-18

      I found that the db_verify command


      $db_verify system.dat
      db_verify: BDB0522 Page 0: metadata page corrupted
      db_verify: BDB0523 Page 0: could not check metadata page
      db_verify: system.dat: BDB0090 DB_VERIFY_BAD: Database verification failed
      BDB5105 Verification of system.dat failed.


      So I tried db_recover command but can't figure out the syntax. Can you help?

      $db_recover system.dat
      usage: db_recover [-cefVv] [-h home] [-b blob_dir] [-P password] [-r region_dir] [-t [[CC]YY]MMDDhhmm[.SS]]

       
    • Vincent (Bryan) Coen

      Please update to v3.01.07 which you can find at :

      https://sourceforge.net/projects/acas/files/

      The only difference is the archiver used.

      As for the funny data well you did ctl/c so the record was not fully written out I guess.

      If you want to see if there is any data you could go into sales -> customer dump and see what you get but if it was me I would:

      Try and amend the record failing that just create a new record.

      NOW when you set up the param file for the 1st time and on the questions of what system you wished to use, I assume you selected Full Invoice and Stock control linking.

      So if you are doing invoices then you must use stock and create a few stock items and it will be useful to also create beforehand a supplier in Purchase to stop stock conplaining.

      Try going through the sales manual and yes I know it is no where near complete and some elements are for a very old version PCDOS & CPM days asIt was the only old manual I could find to use as a base model to update to the current version/s but I had to get back to the v3.02 update which is taken a bit longer to do as other things keep getting in the way.

       
      • John Grillot

        John Grillot - 2017-06-19

        OK I did that and got past that problem.Then I went into system setup. I got address error on line 1. I couldn't figure out how to exit that screen. So ended up having to control -C. Now I when ever I run ACAS I get forced into the setup screens. Can you advise? No rush. Hoping before the end of the day for a response.

         
        • John Grillot

          John Grillot - 2017-06-19

          I forgot to tell you. I fillout each of the setup screens but after I finish those it just puts me back to the setup screens when I run ACAS again.

           
          • Vincent (Bryan) Coen

            The only reason that I know of where you go back to the begging is if you have requested it . What did you enter for the last one on the Print ? question.

            If you have not done so then do it even if only for a hard copy of the data.

            Using ctl/C can create problems and you should work through the manual for set up - I trust that you have now install the later version of v3.01.

            I cannot help on v3.0 as it is too old eg., 7 - 10 years - forgotten.

             
        • Vincent (Bryan) Coen

          Have you updated to v3.01.07?

          Did you fill in the address information anlong with the other info?

          If not the only way it will come out of set up is if the screen is clear of data and that is going by memory.,

           
          • John Grillot

            John Grillot - 2017-06-20

            Just now, I removed my previous install and started off with a fresh install of 3.01.07. I went thru the 8 setup screens (no red messages anywhere) and it still keeps going back to the first screen. I cleared out every field on the first screen and it didn't exit to the menu.

             
  • Vincent (Bryan) Coen

    Just tried it on my data see below:

    [vince@applewood ACAS]$ ll *.dat

    -rwxr-xr-x 1 vince vince    8192 Jun  3  2013 analysis.dat*
    -rwxr-xr-x 1 vince vince    8192 May 18  2013 batch.dat*
    -rwxr-xr-x 1 vince vince    8192 Jun  3  2013 delivery.dat*
    -rwxr-xr-x 1 vince vince    8192 May 22  2013 invoice.dat*
    -rwxr-xr-x 1 vince vince   61440 Oct 12  2016 irsacnts.dat*
    -rwxr-xr-x 1 vince vince     258 Nov  5  2016 irsdflt.dat*
    -rwxr-xr-x 1 vince vince     608 Nov 21  2016 irsfinal.dat*
    -rwxr-xr-x 1 vince vince   40960 Nov 15  2016 irspost.dat*
    -rwxr-xr-x 1 vince vince    8192 Jan  8 17:49 ledger.dat*
    -rwxr-xr-x 1 vince vince       0 Jun  3  2013 openitm2.dat*
    -rwxr-xr-x 1 vince vince    8192 Jun  3  2013 openitm3.dat*
    -rw-r--r-- 1 vince vince   22160 Dec 29 23:05 postsort.dat
    -rwxr-xr-x 1 vince vince 1372160 Feb 19 16:40 purchled.dat*
    -rwxr-xr-x 1 vince vince 1617920 Feb 19 15:09 salesled.dat*
    -rw-r--r-- 1 vince vince       0 Jul 20  2016 staudit.dat
    -rwxr-xr-x 1 vince vince    8192 Jul 17  2016 stockctl.dat*
    -rwxr-xr-x 1 vince vince    4128 Feb 19 18:49 system.dat*
    -rwxr-xr-x 1 vince vince    8192 Jun  3  2013 value.dat*
    [vince@applewood ACAS]$ 
    [vince@applewood ACAS]$ 
    [vince@applewood ACAS]$ db53_verify *.dat**
    BDB5105 Verification of analysis.dat succeeded.
    BDB5105 Verification of batch.dat succeeded.
    BDB5105 Verification of delivery.dat succeeded.
    BDB5105 Verification of invoice.dat succeeded.
    BDB5105 Verification of irsacnts.dat succeeded.
    BDB5105 Verification of irsdflt.dat succeeded.
    BDB5105 Verification of irsfinal.dat succeeded.
    BDB5105 Verification of irspost.dat succeeded.
    BDB5105 Verification of ledger.dat succeeded.
    BDB5105 Verification of openitm2.dat succeeded.
    BDB5105 Verification of openitm3.dat succeeded.
    BDB5105 Verification of postsort.dat succeeded.
    BDB5105 Verification of purchled.dat succeeded.
    BDB5105 Verification of salesled.dat succeeded.
    BDB5105 Verification of staudit.dat succeeded.
    BDB5105 Verification of stockctl.dat succeeded.
    BDB5105 Verification of stockctl.dat.1 succeeded.
    BDB5105 Verification of stockctl.dat.2 succeeded.
    BDB5105 Verification of system.dat succeeded.
    BDB5105 Verification of value.dat succeeded.
    

    However that said when I did it directly for system.dat and irsdflt & irsfinal it also failed.

    These files have 4, 1 & 1 records and system is random data storage and NOT indexed so not really supprised except them passing when doing a group check.

    Should point out that I have never used the utils despite installing them as ACAS does NOT do any SQL only through using the normal Cobol verbs, so a bit pointless I think.

     
    • John Grillot

      John Grillot - 2017-06-21

      Just now, I removed my previous install and started off with a fresh install of 3.01.07. I went thru the 8 setup screens (no red messages anywhere) and it still keeps going back to the first screen. I cleared out every field on the first screen and it didn't exit to the menu.

       
  • John Grillot

    John Grillot - 2017-06-21

    Actually, I just discovered it didn't go back to the menu because I did not have values in Current Cycle Current Quarter,Cycle Period.

     

    Last edit: John Grillot 2017-06-22
  • Vincent (Bryan) Coen

    If fields are missing on any of the screens it should be issuing a msg for each ommision and go back to the start of 'that' screen waiting for you to fix the problem/s.

    That said some fields have a preset default but you should check that it is one you want - you can always go back and change any after using the system but be very carefull if you change from Cobol data files to RDBMS (NOT the other way round as there is no function to support data transfer - however it does exist for Cobol -> RDB). THIS applies only to v3.02 which is not yet released.

    Note that the above does not apply to the very first screen on first set up where you can specify what systems will be used as that is not offered again so you should select ALL regardless if you will use them. I must get around to change that as it is a bit redundant.

    Yet another for the TODO lists.

     

Log in to post a comment.