Versions Compared

Version Old Version 7 New Version Current
Changes made by

Tom Williams

Tom Williams

Saved on

Key

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

Insert excerpt
Def - Report - Sales Confirmation
Def - Report - Sales Confirmation
nopaneltrue
 

...

Table of Contents
typeflat

This report is designed to page break per unique sales transaction.

Report Header

This section only prints at the top of the first page of each new transaction.

CancelCancel - LV

FieldsToolbar IconsDescription
BILL TO

Insert excerpt

Cancel - LV

Rpt - Bill To Block (SO)
Rpt - Bill To Block (SO)
nopaneltrue

Delete

 

This is formatted as:

  1. Customer Name
  2. Address Line 1, 2, 3
  3. City, State, Zip
  4. Country

This can only be edited by changing the Customers bill to address on the Custome Record View.

DELIVER ON
Insert excerpt
Delete - LVDelete - LVRpt - Deliver On Date
Rpt - Deliver On Date
nopaneltrue
ORDER DATE
Insert excerpt
Doc Date
Doc Date
nopaneltrue
ORDER #
Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
EditPO #
Insert excerpt
Edit - LV (Multi Line)Edit - LV (Multi Line)Rpt - PO #
Rpt - PO #
nopaneltrue
ExcelREMIT TO

Insert excerpt

Excel

Rpt -

Global

Remit To Block (

old

SO)

Excel

Rpt -

Global

Remit To Block (

old

SO)
nopaneltrue

Favorites

This is formatted as:

  1. Company Name
  2. Address Line 1, 2, 3
  3. City, State, Zip
  4. Phone # 
SHIP BY
Insert excerpt
Favorites Add/Remove - GlobalFavorites Add/Remove - GlobalRpt - Ship By Date
Rpt - Ship By Date
nopaneltrue
Grid LayoutSHIP TOGrid Layout - Global

Insert excerpt

Grid Layout - Global

Rpt - Ship To Block (SO)
Rpt - Ship To Block (SO)
nopaneltrue

Help

This is formatted as:

  1. Address Name
  2. Address Line 1, 2, 3
  3. City, State, Zip
  4. Country

Page Header

This report does not contain a page header.

Body - Order Header

FieldsDescription
CARRIER

Insert excerpt

Help

Rpt -

Global

Carrier Name

Help

Rpt -

Global

Carrier Name
nopaneltrue

NewNew - In line add

If the entire order is being shipped from a single Site, and there is a Carrier assigned, or from multiple Sites but all with the same Carrier, this will be the Carrier Name. If the order is shipping from multiple sites, and there are more than one Carriers assigned, this will display as "Multiple Carriers".

DUE DATE

Insert excerpt

New - In line add

Rpt - Due Date
Rpt - Due Date
nopaneltrue

Save

This can only be edited by changing the Payment Terms or the 'Ship By' date on the transaction.

PAAYMENT TERMS
Insert excerpt
Save
Rpt -
Global
Payment Terms
Save
Rpt -
Global
Payment Terms
nopaneltrue
SALESPERSON
FieldsDescriptionCheckboxUsed to select one or more records.Carrier Code

A text box to assign a short name or SCAC code for the Carrier. This defaults to blank for new records and is not required. This field is always editable and duplicate values are allowed. This field must be <= 50 characters. 

The SCAC is the Standard Carrier Alpha Code (SCAC) which is a privately controlled US code used to identify vessel operating common carriers (VOCC). It is typically two to four letters long. It was developed to help road transport companies computerize data and records. This is just used for reference and is not visible in look ups on transactions and other master files.

Linked Database Field: ERPx_SOCarrier.CarrierCode 

Carrier Name

A text box to add or edit the unique identifier of the Carrier. This defaults to blank but is required for all records. If missing, the message "Blank Carriers are not allowed." will be displayed on Save. This value must be unique, otherwise the message "Duplicate Carriers are not allowed." will be displayed on Save. This field must be <= 50 characters.

Linked Database Field: ERPx_SOCarrier.CarrierName

Currency ID

Identifies the 'Currency' that is assigned to the 'Linked AP Vendor'. This is not editable and is only populated for Carriers that have a 'Linked AP Vendor' defined. This will be blank for Carriers without a 'Linked AP Vendor' assigned.

Linked Database Field: ERPx_APVendor.CurrencySK

Description

A text box to add/edit a long description for the Carrier record. This defaults to blank for new records and is not required. This field is always editable and duplicate values are allowed. This field must be <= 200 characters. 

This is informational only and is is not visible in look ups on transactions and other master files.

Linked Database Field: ERPx_SOCarrier.Description

Email

A text box to add/edit an email address associated with the Carrier record. This defaults to blank for new records and is not required. This field is always editable and duplicate values are allowed. This field supports multiple email addresses if they are separated by a " ; ". This field must be <= 1,000 characters. 

This is informational only and is is not visible in look ups on transactions and other master files. There are no validations on this page to ensure this data is a properly formatted email address or that the email address is valid.

Linked Database Field: ERPx_SOCarrier.Email

Fax

A text box to add/edit a Fax Number associated with the Carrier record. This defaults to blank for new records and is not required. This field is always editable and duplicate values are allowed. This field must be <= 30 characters. 

This is informational only and is is not visible in look ups on transactions and other master files. There are no validations on this page to ensure this data is a properly formatted or that it is a valid number.

Linked Database Field: ERPx_SOCarrier.Fax

Inactive

A Yes/No field used to identify if the Carrier is Inactive. If set to 'Yes' then the record is "Inactive" and will not be included in look-ups. Setting this to Inactive only prevents the record from being manually assigned to new transactions or master files, it does not prevent transactions containing this value to be posted. 'No' values display as blank in the grid. This value is always editable.  

Linked Database Field: ERPx_SOCarrier.IsInactive

Linked AP Vendor

A single select load on demand lookup to assign the AP Vendor that is paid for deliveries made by the Carrier.This defaults to blank for new records, is not required, and duplicates are okay. This field is always editable. Once selected, the Vendor Name will be displayed.

The lookup contains a blank value and a list of all AP Vendors.

Linked Database Field: ERPx_SOCarrier.LinkedToVendorSK

Phone

A text box to add/edit a Phone Number associated with the Carrier record. This defaults to blank for new records and is not required. This field is always editable and duplicate values are allowed. This field must be <= 30 characters. 

This is informational only and is is not visible in look ups on transactions and other master files. There are no validations on this page to ensure this data is a properly formatted or that it is a valid number.

Linked Database Field: ERPx_SOCarrier.Phone
Insert excerpt
Rpt - Salesperson - Outside
Rpt - Salesperson - Outside
nopaneltrue
SHIPPED FROM

Insert excerpt
Rpt - Shipped From Name
Rpt - Shipped From Name
nopaneltrue

If the entire order is being shipped from a single Site, this will be the Site Name. If the order is shipping from multiple sites this will display as "Multiple Sites".

Body - Item Details

Line items are displayed as follows:

  1. Line items assigned an 'Item Type' of "Inventory" or "Misc." display individually in the detail section. The quantities and amounts displayed are based on the ORDERED values, not on the allocated values. These lines are ordered by the 'Seq' assigned on the items grid of the sales order record view.
  2. Line items assigned an 'Item Type' of "Tax" are summarized together, and the sum of their extended amounts display in the 'TAX' box. They are not shown individually in the detail section.
  3. Line items assigned an 'Item Type' of "Freight" are summarized together, and the sum of their extended amounts display in the 'FREIGHT' box. They are not shown individually in the detail section.
FieldsDescription
ITEM DESCRIPTION

Insert excerpt
Rpt - Item & Description (SO)
Rpt - Item & Description (SO)
nopaneltrue

EXT. AMOUNT

Insert excerpt
Rpt - Item & Description (SO)
Rpt - Item & Description (SO)
nopaneltrue

This column includes a subtotal formatted to two decimal places. 

ORD. UNITS

Insert excerpt
Rpt - Units - Ordered (SO)
Rpt - Units - Ordered (SO)
nopaneltrue

This column includes a subtotal when one or more of the items contains 'Units'. The subtotal is formatted to the decimal precision of the item with the largest Units decimal precision.

ORD. UNITS UOM
Insert excerpt
Rpt - Units - UOM (SO)
Rpt - Units - UOM (SO)
nopaneltrue
ORD. WEIGHT

Insert excerpt
Rpt - Weight - Ordered (SO)
Rpt - Weight - Ordered (SO)
nopaneltrue

This column includes a subtotal when one or more of the items contains 'Weight'. The subtotal is formatted to the decimal precision of the item with the largest Weight decimal precision.

ORD. WEIGHT UOM
Insert excerpt
Rpt - Weight - UOM (SO)
Rpt - Weight - UOM (SO)
nopaneltrue
PRICE
PRICE UOM
Insert excerpt
Rpt - Price - UOM (SO)
Rpt - Price - UOM (SO)
nopaneltrue


Item Detail Subtotals

FieldsDescription
SUB TOTAL
TAX
FREIGHT
INVOICE TOTAL

Notes

The notes only print at the bottom of the last page.

The following Note Types print if populated:

  1. Transaction - "Billing" note

Page Footer

This data prints on the bottom of every page.

  1. Page X of Y. This resets for every transaction

Related Topics



Expand
titlePage Definitions

Page Definitions


...