sbt pro 5.0i question on AR

[ernestop]

Hi,
I have this problem about 3 or 4 days ago, when the user go to AR for an specific company cuase we have about 4 diff companies (ie 04 is the company named APEX) to enter a shipment, and she enter all the sale orders that have been shipped then she will go and print all the invoices, so far she have been able to print a batch wich as you know will print all the sale orders that have been shipped, you can also print individual but for that you need to know the invoice while the batch process of printing will print all the invoices, ok what happen is that now we are getting this particular error message just when the printer has been selected to print: message "error 5 Record is out of range called from ARPSTM LINE NUMBER : 1506 PROGARM CODE CAUSING EROR : .not. delete() then i have this buttons Ignore retry or quit "
Ok one of the things i did was taking every one out of SBT and run from the menu the reindex application files and reindex system files but not luck at all, i have been checking the tables involved in these process and can not find any data missing (tables are somast, sotran, armast and artran), i can not find or solve the problem cause each time the user needs to print a batch it is the same problem, however if i that personn runs the same process but for a diff company exmaple company 03 wich is capex, she can print the batch w/o a problem, we can stil print each individual invoice but we have to run another report tht will show the sales order number and the invno then this person has to type each individual invno in order to print each invoice form, that is ok when they are couples of them, any help please, will be appreciated, if you need more info let me know
Ernest

 

[fitedgar]

One or more of your invoices do not contain any detail lines.
Check each invoice for line items.
Either delete that invoice( later re-create it) or mark it as printed.

Edgar
Integrated Bar Code Systems, Inc.

 

[ernestop]

Hi Edgar,
Thanks so much for your post, i tried to check somast and sotran, also armast and artran, and don't see anything at all missing there in fact i renamed the cdx files fro these tables and created a new one and still got that same error ""error 5 Record is out of range called from ARPSTM LINE NUMBER : 1506 PROGARM CODE CAUSING EROR : .not. delete() then i have this buttons Ignore retry or quit ", it since like a cdx file is corrupted but i don't see how, any other suggestion anyhting else, can print batch after shipments is done
Thanks
Ernesto

 

[fitedgar]

Try reindexing the files , if this does not work :

Try this: assuming company 01 and path

USE d:\pro65\arfitdta\armast01.dbf in 0 alias a_armast
USE d:\pro65\arfitdta\artran01.dbf IN 0 alias a_artran
SELECT a_artran
set order to invno
brows nowait
SELECT a_armast
SET RELATION TO invno INTO Artran01 ADDITIVE
browse nowait

Now:
Start from the bottom in a_armast. Scroll up, if you see records in a_artran, record is ok. Move up the next record in a_armast. This is the easiest method. Once you find the a_armast record with no a_artran records, replace a_armast.prtid with "P" ( this marks the invoice as printed)

This method works the same in sales Orders.

Edgar
IBS

 

[fitedgar]

The above should find your problem. But here 's another way:
At the command window:

USE d:\pro65\arfitdta\armast01.dbf in 0 alias a_armast

REPLACE all prtid with "P"

Caution:
This will mark ALL invoices as printed, and you will have to reprint them one by one INDIVIDUAL if needed. After this you should be able to print BATCH again.

Edgar
IBS

 

[SBTBILL]

Do you have the source code? There may be some corruption.

Bill Couture

 

[ernestop]

Edgar
I did what you told me on both ways, and still i got the sdame problem when tring to print a batch however it does not happen with toher companies, here is an SBTREPT.OUT WICH IS A LOG FILE ERROR. I DON'T understand what i am getting this, i am going to paste it here:

Page: 1
Date: 09/20/2007 at 3:01 PM
SBT Pro - System Manager
Summary Error Log Report
Company = 04
Application = ARError date = 09/20/2007 Order by User


Error Number: 5 (Record is out of range)
Error Message: Record is out of range.
Date & Time: 09/20/2007 at2:39 PM User: ARIC Workstation: 523100 Application:R Company: 04
Process: SOSHIP01 Program: ARPSTM Line Number: 1506


Error Number: 5 (Record is out of range)
Error Message: Record is out of range.
Date & Time: 09/20/2007 at2:39 PM User: ARIC Workstation: 523100 Application:R Company: 04
Process: SOSHIP01 Program: ARPSTM Line Number: 1771


Error Number: 13 (ALIAS not found)
Error Message: Alias 'A_ARMAST' is not found.
Date & Time: 09/20/2007 at2:40 PM User: ARIC Workstation: 523100 Application:R Company: 04
Process: SOSHIP01 Program: ARPSTM Line Number: 1779


Error Number: 13 (ALIAS not found)
Error Message: Alias 'A_TMPLOGO' is not found.
Date & Time: 09/20/2007 at2:40 PM User: ARIC Workstation: 523100 Application:R Company: 04
Process: SOSHIP01 Program: ARPSTM Line Number: 1837


Error Number: 5 (Record is out of range)
Error Message: Record is out of range.
Date & Time: 09/20/2007 at12:47 User: EPAE Workstation: 453156 Application:R Company: 04
Process: SOSHIP01 Program: ARPSTM Line Number: 1506

Any help is very apreciated, i am a frustration and stress out man
Thanks a lot
Ernesto

 

[ernestop]

I did it again
USE d:\pro65\arfitdta\armast01.dbf in 0 alias a_armast

REPLACE all prtid with "P"
and now id fixed
Thanks a lot Edgar
Ernesto

 

[fitedgar]

I did it again
USE d:\pro65\arfitdta\armast01.dbf in 0 alias a_armast "

??? Were you using the correct path ? The above path is from my sample data.
I was an SBT\AccPAc reseller. I am still using AccPAc/SBT 6.5 ( Now is called Accpac Pro 6.5)

I do still have many clients using SBT 3.2i, 5.0, 6.5, 7.1 and I still support them.

If you want to upgrade, you will need through an AccPac reseller since I no longer sell it.

We programmers work very hard on providing a good service and discourage anyone from copying copyrighted software.

Edgar
IBS

 

[SBTBILL]

Record out of range is usually an index issue or as someone pointed out a partially saved order. Sometimes the problem can be fixed by backing up and then physically deleting all the indexes. SBT is supposed to delete them but sometimes it doesn't.

Now that Sage owns PRO it is call PRO ERP and is at version 7.4 or 7.5. I'd have to check with an associate who is the actual dealer. I function as a broker for this product. E-mail me if you want more info

Bill Couture
http:\\

http://www.sbtbill.com