Versions Compared

Old Version 2

changes.mady.by.user Tom Williams

Saved on

compared with

New Version Current

changes.mady.by.user Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

The purpose of this page 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
typeflat

Page Header

...

  • GL Date: A date picker that defaults to "(No Change)". Assigns the selected GL Date to selected/filtered transaction(s) when 'Apply' is clicked. 
  • Site: A single-select standard lookup that defaults to "(No Change)", but also contains a list of all active Sites configured on the Sites List View that assigns the selected Site to selected/filtered transaction(s) when 'Apply' is clicked; and an option "(Clear Value)" that when selected and 'Apply' is clicked will remove the Site assigned to the selected transaction(s). 
  • Status: A single-select standard lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transaction(s) when 'Apply' is clicked. 

...

  • 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.CreatedDate

...

Database Field: ERPx_APTransactionHeader.CreatedBy

...

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.LastUpdated

...

Database Field: ERPx_APTransactionHeader.LastUser

...

Insert excerpt
Def - Trans - Fisherman Sale
Def - Trans - Fisherman Sale
nopaneltrue

Insert excerpt
Def - Trans - Tender Resale
Def - Trans - Tender Resale
nopaneltrue
 


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.09.15 and newer

Table of Contents
typeflat

Page Header

Site Name FieldsMFSite.SiteName, ERPx_SiteSKStatusStatusStatus   Status Status The Statuses that apply to transactions in this List View include:Def - Status - Approved Status - Ready to Post Status - Ready to PostAPTransactionStatusStatusName, ERPx_APTransactionHeader.TransactionStatusSK

Toolbar IconsDescription
Edit

Insert excerpt
Edit - LV
Edit - LV
nopaneltrue

Excel

Insert excerpt
Excel - LV
Excel - LV
nopaneltrue

Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout

Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue

Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
More Actions

Insert excerpt
More Actions - Global
More Actions - Global
nopaneltrue

  • 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.
New

Insert excerpt
New - Multi-Select Trans Class - Global
New - Multi-Select Trans Class - Global
nopaneltrue
 

  • Fisherman Sale: 
    Insert excerpt
    Def - Trans - Fisherman Sale
    Def - Trans - Fisherman Sale
    nopaneltrue
  • Tender Resale:
    Insert excerpt
    Def - Trans - Tender Resale
    Def - Trans - Tender Resale
    nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Credit Account

Insert excerpt
GL Account - Sale Account - Item
GL Account - Sale Account - Item
nopaneltrue

Database Field: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK 

Credit Account Description

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

Database Field: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK 

Debit Account

Insert excerpt
Def - GL Account - Settlement Accural
Def - GL Account - Settlement Accural
nopaneltrue

Database Field: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctref, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.TransactionHeaderSK 

Debit Account Description

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

Database Field: ERPx_GLAccount.Description,  ERPx_APVendor.SAGLAcctref, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.TransactionHeaderSK 

Doc Date

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

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc Description

Insert excerpt
Comment - Header
Comment - Header
nopaneltrue
This is a text box to assign a description to the Fisherman Sale transaction. 

Database Field: ERPx_APTransactionHeader.Description

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
 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 Extended amount of the line item. This is calculated as [Quantity] * [Price] for each transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line. Positive lines represent a purchase (Credit entry) and negative lines represent a return (Debit entry).

Database Field: ERPx_APTransactionLine.ExtendedAmount for Items and ERPx_APTransactionTax.TaxAmount for Tax Lines

Fisherman

Insert excerpt
Fisherman ID
Fisherman ID
nopaneltrue
 

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Fisherman Name

Insert excerpt
Fisherman, Fisherman & Tender and Tender
Fisherman, Fisherman & Tender and Tender
nopaneltrue
 

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

GL Period

Insert excerpt
GL Period
GL Period
nopaneltrue
 This field is not stored in the database.

Database Field: ERPx_APTransactionHeader.GLDate

GL Year

Insert excerpt
GL Year
GL Year
nopaneltrue
 This field is not stored in the database.

Database Field: ERPx_APTransactionHeader.GLDate

Item

Insert excerpt
Item ID
Item ID
nopaneltrue

Database Field: ERPx_IMItem.ItemID, ERPx_APTransactionLine.ItemSK

Item Class

Insert excerpt
Item Class
Item Class
nopaneltrue

Insert excerpt
Def - Item Class
Def - Item Class
nopaneltrue

Database Fields: ERPx_IMItemClass.ClassID, ERPx_IMItemClass.Description, ERPx_IMItem.ItemClassSk, ERPx_APTransactionLine.ItemSK

Item Description

Insert excerpt
Item Description
Item Description
nopaneltrue

Database Field: ERPx_APTransactionLine.LineDescription

Line Type

Insert excerpt
Line Type
Line Type
nopaneltrue
 This will either be:

  • Sale: The row is for an Inventory Item ID that was sold.
  • Tax: The row is for a total tax amount that was calculated for the transaction
Price

Identifies the Price for the line item. This defaults to '0.00' on New, but will be updated after Save to display the number of decimals that is set on the corresponding Item's master file record for Price Decimals.  This is editable while in status of New. 

Note: This will be blank if the Line Type = Tax

Database Fields: ERPx_APTransactionLine.Price 

Price List ID

Insert excerpt
Price List - ID
Price List - ID
nopaneltrue

Insert excerpt
Def - Price List
Def - Price List
nopaneltrue

Database Fields: ERPx_MFPriceListHeader.PriceListID, ERPx_APTransactionHeader.PriceListHeaderSK

Quantity

Identifies the Quantity for the line item. This defaults to '1.00' on New, but will be updated after Save to display the number of decimals that is set on the corresponding Item's master file record for Unit/Weight Decimals depending on the UOM selected.  This is editable while in status of New. 

Note: This will be blank if the Line Type = Tax

Database Fields: ERPx_APTransactionLine.Quantity

Site Name

Insert excerpt
Site Name
Site Name
nopaneltrue
 

Database Fields: ERPx_MFSite.SiteName, ERPx_APTransactionHeader.SiteSK

Status

Insert excerpt
Status
Status
nopaneltrue
  

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transactions in this List View include:

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Insert excerpt
Def

- Price List

- Status - Ready to Post
Def -

Price List

Status - Ready to Post
nopaneltrue

Database Fields: ERPx_MFPriceListHeaderAPTransactionStatus.PriceListIDStatusName, ERPx_APTransactionHeader.PriceListHeaderSKTransactionStatusSK

Site Name
Tax Class

Insert excerpt

Site Name

Def - Tax Class
Def - Tax Class
nopaneltrue
 

Database

Field:ERPx_

APTransactionHeader.

TaxClassSK

Tender

Insert excerpt

Tender ID

Tender ID
nopaneltrue

Insert excerpt
Def -

Tender
Def -

Tender
nopaneltrue

Insert excerpt
Def - Status - NewDef - Status - New
nopaneltrue
Insert excerpt
Def - Status - Approved

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.FromVendorSK 

Tender Name

Insert excerpt
Tender Name
Tender Name
nopaneltrue

Insert excerpt
Def -

Tender
Def -

Tender
nopaneltrue

Database Fields: ERPx_

APVendor.

Subtotal

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

Database Field: ERPx_APTransactionHeader.TaxableAmount 

Tax

Identifies the applicable sales tax for the transaction. 

Database Field: VendorName, ERPx_APTransactionHeader.TaxedAmountFromVendorSK 

Tax ClassTrans CreatedDef - Tax Class

Insert excerpt

Def - Tax Class

Created
Created
nopaneltrue

 

This is required and is not editable.

Database Field: ERPx_

APTransactionHeader

APTransactionHeader.

TaxClassSK

CreatedDate

TenderTrans Created By

Tender ID

Insert excerpt
Tender ID
Created By
Created By
nopaneltrue
 Insert excerptDef - TenderDef - Tendernopaneltrue

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.FromVendorSK 

Tender Name

This is required and is not editable.

Database Field: ERPx_APTransactionHeader.CreatedBy

Trans Last Updated

Insert excerpt
Tender NameTender NameLast Updated
Last Updated
nopaneltrue
This is required and is not editable.

Database Field: ERPx_APTransactionHeader.LastUpdated

Trans Last Updated By

Def - Tender

Insert excerpt
Def - Tender
Last Updated By
Last Updated By
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK 

Total Amount

Identifies the total amount of the transaction.

[Total Amount] = [Sub Total] + [Tax] This is required and is not editable.

Database Field: ERPx_APTransactionHeader.ExtendedAmountLastUser

Transaction

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

 

 Clicking on the hyperlink opens the transaction record view.

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Type

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue
 

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

UOM

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK


Related Topics

Correcting Fish Tickets (UG)

...