Welcome, Guest. Please Login.
11/05/24 at 09:18:18
News:
Home Help Search Login


Pages: 1
Send Topic Print
Serial number on Shipping Label (Read 1118 times)
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Serial number on Shipping Label
07/24/09 at 08:20:52
 
How would I go about adding the serial number to the shipping label detail?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Serial number on Shipping Label
Reply #1 - 07/24/09 at 11:46:27
 
Unfortunately, the sales table does not keep track of the serial numbers.
 
If you select "D" on "Print Header or Detail labels", the report will print the sales order Lines.
But there is not serial information.
 
This info comes from the serial table. And I dont see it anywhere on the report (T6SODD1.RTM)
 
Even if you add the MTSER.SERIAL. It does not work.
 
Ask ISTECH, maybe there is a way.
 
  Wink
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Serial number on Shipping Label
Reply #2 - 07/24/09 at 11:51:17
 
The info is in the INVTXN table once invoiced, but it is only linked to the released SO in the BKARTXN (lot) or BKARTXNS (serial) before then Sad
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: Serial number on Shipping Label
Reply #3 - 07/24/09 at 12:04:50
 
I did try the serial file field myself, confirm it did not work.
Is this shipping label linked to the released for shipment process? If so, can't I access the serial number that prints on the packing list?
 
This is often my problem with trying to add fields to a form--what tables are available?? That information doesn't seem to be available and the hit and miss technique is very frustrating.
 
In this form, it appears that all of the fields are custom (behind the scenes) and none of them come from a table that I can access.   Allen, could you let me know if there are any tables that I can use with these forms -- T6SODD and T6SODH?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Serial number on Shipping Label
Reply #4 - 07/24/09 at 12:05:50
 
if you add the BKAR.TXN.SERIAL
 
does not work either. I just copy it from the T6SOC3.RTM
 
 Tongue
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: Serial number on Shipping Label
Reply #5 - 07/24/09 at 13:42:42
 
I am looking at the BKARTXNS table and this has the information I am looking for.  Is this table available to pull from for the label rtm?
By the way I have some very old records in there that have been invoiced but must have had a problem with clearing out of this file- all dated 2002.  Would there be any harm in deleting these records?  I can see valid ones as well (released but not invoiced yet).
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Serial number on Shipping Label
Reply #6 - 07/24/09 at 13:57:16
 
you can kill the 2002 records... I look and see what I can do to add that link in the code so you can use this files data.
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: Serial number on Shipping Label
Reply #7 - 07/24/09 at 14:59:01
 
Thanks a bunch, Allen! Smiley
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print