Available in Sage 50 Premium Accounting and higher.
Serial Number Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: JRNLSNO.DAT
JRNLSNO.DAT is the Serial Number file. This file relates serial numbers to their accounting transactions. It has one row for every serial number in each serialized distribution. The same serial number may appear in several rows, one for each distribution on which it appears. The serial number classifies each distribution affecting a serial number, and records the originating cost.
- To add Sage 50 Serial Number fields to your Crystal reports, select JRNLSNO.DAT.
Indexes and Their Uses
The JRNLSNO.DAT file has six keys, as follows:
0 = By RecordNumber.
1 = By ItemRecordNumber, then by SerialNumber and then by Date.
2 = By ItemRecordNumber, then by SerialNumber, then by TransactionClass, and then by Date.
3 = By PostOrder, and then by RowIndex. Use this index to link to the JrnlRow file.
4 = By WorkTicketRecordNumber. Use this index to link to the WorkTkt file.
5 = By Date, and then by RecordNumber.
6 = By SerialNumber, then by ItemRecordNumber, and then by Date. (Similar to Key 1.)
7 = By ItemRecordNumber and then by SerialNumber.
8= By SNGUID
Fields
The following table shows the fields available in the JRNLSNO.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
SerialRecordNumber |
Integer |
This is an internal record number for the serial number |
|
|
ItemRecordNumber |
Integer |
This is an internal record number for the item |
|
|
SerialNumber |
ZString |
30 |
The Serial Number field |
|
TransactionClass |
Integer |
This field describes the record type. Valid values are: 0=snReserved - appears on work ticket 1=snOrigination - brought into inventory 2=snIntermediate - returned to inventory after sale 3=snSale - sold to customer 4=snReturn - returned to vendor 5=snAdjustment - adjusted out of inventory |
|
|
TransactionCost |
Float |
The cost associated with the transaction |
|
|
TransactionDate |
Date |
Date of the transaction |
|
|
JrnlPostOrder |
Integer |
The transaction header reference; value = 0 if the transaction is a work ticket. |
|
|
JrnlRowIndex |
Integer |
The row index; value = 0 if the transaction is a work ticket. |
|
|
WorkTktRecordNo |
Integer |
The work ticket number associated with the serialized item; otherwise, value = 0. |
|
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the SerialNo. table. |
|
|
LastUpdateCounter |
Integer |
This increases incrementally when the record is changed. |