Insert excerptDef - Trans - Fisherman SaleDef - Trans - Fisherman Salenopaneltrue Insert excerptDef - Trans - Tender ResaleDef - Trans - Tender Resalenopaneltrue

The purpose of this inquiry is to view, add, edit, delete, void or correct Fisherman Sale and Tender Resale transactions. Additionally, users may void or correct transactions. From this list view, users may also mass update values for several fields, print available reports or export the contents of the grid to Excel.

Image Removed This list view also contains columns for each Attribute that is set up for the 'Fisherman Accounting - Transactions' attribute type. However, because these attributes are user defined, they are not included in the help documentation.

Software Version: 2021.10.15 and newer

Table of Contents

type	flat

Page Header

...

Data From
Date To
Status

...

Void/Correct: Opens the Void/Correct Fish Ticket utility to allow users to void or correct one or more posted Fisherman Sale or Tender Resale transactions.

...

Database Field: ERPx_APTransactionHeader.TransactionDate

...

Database Field: ERPx_APTransactionHeader.Description

...

Database Field: ERPx_APTransactionHeader.DocNumber

...

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

...

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

...

Database Field: ERPx_APTransactionHeader.GLDate

...

Database Fields: ERPx_MFPriceListHeader.PriceListID, ERPx_APTransactionHeader.PriceListHeaderSK

...

Database Fields: ERPx_MFSite.SiteName, ERPx_APTransactionHeader.SiteSK

...

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

...

Identifies the sum of all the sale line items on the transaction.

Database Field: ERPx_APTransactionHeader.TaxableAmount

...

Identifies the applicable sales tax for the transaction.

Database Field: ERPx_APTransactionHeader.TaxedAmount

...

Database Field: ERPx_APTransactionHeader.TaxClassSK

...

Adjustments provide a way to make changes to Fishermen, Tender, and/or Loan account balances. This is most often used to load initial Fishermen, Tender, and/or Loan account balances on go live but can also be used for other reasons. Positive adjustments create a fisherman receivable and negative adjustments create a fisherman payable. The purpose of this inquiry is to view Fisherman Adjustment lines.

Image Added This list view also contains columns for each Attribute that is set up for the 'Fisherman Accounting - Transactions' attribute type. However, because these attributes are user defined, they are not included in the help documentation.

Software Version: 2023.08.31 and newer

Table of Contents

type	flat

Page Header

Tender Tender

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.FromVendorSK

Tender Name Tender Tender

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK

Identifies the total amount of the transaction.

[Total Amount] = [Sub Total] + [Tax]

Database Field: ExtendedAmount

Toolbar Icons

Description

Excel

Insert excerpt

	Excel - LV
	Excel - LV
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Grid Layout

Insert excerpt

	Grid Layout - Global
	Grid Layout - Global
nopanel	true

Help

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

Inquiry Criteria

Insert excerpt

	Inquiry Criteria - Global
	Inquiry Criteria - Global
nopanel	true

Date From
Date To
Status

Journal Details

Opens the Journal Detail for all the rows selected.

Refresh

Insert excerpt

	Refresh - Global
	Refresh - Global
nopanel	true

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Accrual Account

Insert excerpt

	Def - GL Account - Settlement Accural
	Def - GL Account - Settlement Accural
nopanel	true

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK

Accrual Account Description

The GL Account Description of the Payable Account.

Insert excerpt

	Def - GL Account - Settlement Accural
	Def - GL Account - Settlement Accural
nopanel	true

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK

Doc Date

Insert excerpt

	Doc Date
	Doc Date
nopanel	true

This can be edited from the 'Doc Date' on the 'Home' tab of the Record View.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

Insert excerpt

	Doc No
	Doc No
nopanel	true

This can be edited from the 'Doc No' on the 'Home' tab of the Record View and is used to enter a unique identifier from a pre-printed book of receipts. The Doc No value must be unique by transaction type. No two Fisherman Sale or Tender Resale Doc No values may be the same.

Database Field: ERPx_APTransactionHeader.DocNumber

Extended

Identifies the total amount of the transaction.

[Extended] = [Quantity] * [Price]

Database Field: ERPx_APTransactionHeader.ExtendedAmount

Fisherman

Insert excerpt

	Fisherman ID
	Fisherman ID
nopanel	true

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Fisherman Name

Insert excerpt

	Fisherman, Fisherman & Tender and Tender
	Fisherman, Fisherman & Tender and Tender
nopanel	true

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

GL Period

Insert excerpt

	GL Period
	GL Period
nopanel	true

This field is not stored in the database.

GL Year

Insert excerpt

	GL Year
	GL Year
nopanel	true

This field is not stored in the database.

Item Description

Insert excerpt

	Description - Item
	Description - Item
nopanel	true

Database Field: ERPx_APTransactionLine.LineDescription

Line Type

A textbox to identify whether the line item is 'Owed to Account' or 'Due from Account'. This is required and not editable.

Line items with a positive Extended amount are set to 'Due from Account'.
Line items with a negative Extended amount are set to 'Owed to Account'.

Price

A textbox to enter the price of the adjustment line.

Database Field: ERPx_APTransactionLine.Price

Purchase Account

Identifies the GL Account number of the GL Account that is used for the Adjustment line item. This will be the GL Account that is credited when the 'Extended' amount is positive and debited when it is negative.

This lookup contains a blank value, the current assigned value, and all active GL Accounts where 'Use in AP' = "Yes".

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Purchase Account Description

Identifies the GL Account description of the GL Account that is used for the Adjustment line item. This will be the GL Account that is credited when the 'Extended' amount is positive and debited when it is negative.

Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK

Quantity

Identifies the quantity of the adjustment line.

Database Field: ERPx_APTransactionLine.Quantity

Status

Insert excerpt

	Status
	Status
nopanel	true

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

The Statuses that apply to transactions in this List View include:

Insert excerpt

	Def - Status - New
	Def - Status - New
nopanel	true

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

Insert excerpt

	Def - Status - Ready to Post
	Def - Status - Ready to Post
nopanel	true

Insert excerpt

	Def -

Status - Posted
	Def - Status -

Posted
nopanel	true

Tender Name

Insert excerpt

Tender Name

Insert excerpt

	Def - Status - Void
	Def - Status - Void
nopanel	true

Insert excerpt

	Def - Status -

Deleted
	Def - Status -

Deleted
nopanel	true

Total Amount

Insert excerpt

	Def - Status - Replaced
	Def - Status - Replaced
nopanel	true

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.

TransactionStatusSK

Transaction

Insert excerpt

	Def - Transaction ID
	Def - Transaction ID
nopanel	true

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Type

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

This will always be "Adjustment".

Database FieldFields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK

UOM

Insert excerpt

	UOM - Price
	UOM - Price
nopanel	true

Database Field: ERPx_APTransactionLine.QuantityUOMSK

Versions Compared

Old Version 1

New Version Current

Key

Page Header

Page Header

Related Topics

Page Comparison

Versions Compared

Old Version 1

New Version Current

Key

Page Header

Page Header

Related Topics