Financial - Export Data to General Ledger - Reference Content

When exporting data to the general ledger, each document can have up to 4 reference numbers that refer to different types of information. This information is also included when exporting the data to Excel or Hashavshevet. These fields contain different information when viewed through the system, and when exported as a TSV file.

Reference content in the system

The following table details the reference content for each document type:

Document	Ref1	Ref2	Ref3	Ref4
VCH, STK, PRQ	Document number		CoverIndex1	CoverIndex2
REF	Document number	VCH number	CoverIndex1	CoverIndex2
INV, STT	Document number	User reference	CoverIndex1	CoverIndex2
RCT, TRC	Document number	User reference	CoverIndex1	CoverIndex2
RMT	Document number	User reference	CoverIndex1	CoverIndex2
TXI	Document number		CoverIndex1	CoverIndex2
ACI	Document number	User reference	CoverIndex1	CoverIndex2
DEP, WDR	Document number	User reference	CoverIndex1	CoverIndex2
C/D, D/C	Document number		CoverIndex1	CoverIndex2

CoverIndex1 and CoverIndex2

These fields contain the document number of the covering document.

CoverIndex1:

PRQ covers VCH/REF
STT covers INV
DEP/WDR covers RCT
ACI bind to INV

CoverIndex2: RCT/TRC/RMT covers PRQ/INV/CD/DC/ACI

When a document covers another document, the relevant CoverIndex of the covered document contains the document number of the covering document.

For example:

Voucher #500 is covered by PRQ #455.

PRQ #455 is covered by RMT #732

Exceptions

RMT

If there is no coverindex2, the Ref4 field contains the document number
If the form of payment is check, the Ref1 field contains the check number, and the Ref2 field contains the document number.

VCH

With Sales and Purchases, the Ref1 field contains the supplier invoice reference number and the Ref4 field contains the document number.
In all other cases, the Ref1 field contains the document number, and the Ref4 field contains the supplier invoice reference number.

VCH, STK, REF

If the PRQ which covers the VCH, STK or REF document is covered by an RCT, TRC or RMT document, the Ref4 field contains the document number of the covering RCT, TRC, or RMT.

This overrides the previous logic of the VCH document.

If a document is cancelled, the Ref2 field contains the cancellation number (not including RMTs for which the form of payment is a check).