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?