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.

What do you want to do next?

See a list of Crystal Reports data (.DAT) files