Menu Code: BSI Accounting/Finance - Accounts Receivable

A searchable list of Sales Invoices (headers).

Actions

Action	Description
Attachments	View attachments for the selected invoice.  The icon will appear with a check mark if the selected invoice has attachments.
Edit/View	Opens the Sales Invoices (SIV) form for the selected invoice.

Zoom Links

Column	Zoom Link
SINo	Sales Invoices (SIV), for the specified invoice
CustCode	Customers (CUS), for the specified customer
OrdNo	Sales Orders (ORD), for the specified sales order
AddrCode	Addresses (ADD), for the specified ship to address
TermCode	Payment Terms (TER), for the specified terms
PickNo	Pick Tickets (PTK), for the specified pick ticket
DefProjCode	Projects (PRJ), for the specified project

Columns

Index	Visible	Field Name	Caption	Usage / Description
0	Yes	SINo	ID	Sales Invoice Number
1	Yes	PickNo	Pick	Pick Ticket Number
2	Yes	SIType	Type	Sales Invoice Type: (CI) Customer Invoice, (CC) Customer Credit, (IV) Order Manual Invoice, (CR) Order Credit Memo, (PT) Pick Ticket
3	No	SITypeDes	Type Des	Sales Invoice Type Description
4	Yes	SIDate	Date	Sales Invoice Date
5	Yes	SentDate	Sent	Date the Sales Invoice was Emailed
6	Yes	SIStat	S	Sales Invoice Status: (D) Draft, (R) Released, (V) Revised, (X) Cancelled
7	Yes	BUnit	BUnit	Business Unit Code
8	No	BUnitName	BUnitName	Business Unit Name
9	Yes	CustCode	Cust	Customer Code (AAANNN)
10	Yes	CustPO	Cust PO	Customer Purchase Order Number
11	Yes	OrdNo	Order	Customer Order Number
12	Yes	OrdType	OrdType	Order Type Code: May Be Different than Lead Type [Edit via Order Type in Support Menu]
13	No	OTDes	OTDes	Order Type Description
14	Yes	DefProjCode	Proj	Default Project Code
15	No	DefProjName	Proj Name	Default Project Name
16	Yes	TermCode	Terms	Payment Terms Code [Edit via Payment Terms in Support Menu]
17	Yes	ShipToTag	Ship Tag	Ship To Address Code\Tag (Note: One customer may have many ship to locations = unique ship code\tag)
18	Yes	AddrCode	Addr	Address Code
19	No	TotAmt	GrossCury	Total Net Sale Amount
20	No	TotTax	TaxCury	Sales Invoice Tax Amount
21	No	TotShip	ShipCury	Sales Invoice Shipping Costs
22	No	AddWho	Add Who	Record Added by Who (FOURA User ID)
23	Yes	AddDate	Added	Add Date
24	No	CurCode	Cur	Currency Code
25	No	ExchRate	Exch	Foreign Currency Exchange Rate [Edit via Currencies in Accounting\Finance Support Menu]
26	Yes	CustName	Customer Name	Customer Name
27	No	InvcAmt	TotalCury	Sales Invoice Amount minus Taxes and Freight
28	No	AllocAmt	AllocCury	Allocated Amount
29	Yes	USDAmt	GrossUSD	Total Amount USD
30	Yes	USDShip	FrtUSD	Total Freight Amount
31	Yes	USDTax	TaxUSD	Total Tax Amount
32	Yes	USDTot	TotalUSD	Total Amount minus Taxes and Freight UD
33	Yes	AllocUSD	PaidUSD	Allocated Amount USD
34	Yes	DueUSD	DueUSD	Due Amount in USD
35	No	SalesRep	Acct Mgr	Account Manager (FOURA User ID)
36	Yes	SalesRepName	Acct Mgr Name	Account Manager Name
37	Yes	CustState	ST	Customer State (2 Digit Code)
38	Yes	ShipToCity	To City	Ship To City
39	Yes	ShipToState	To ST	Ship To State (2 Digit Code)
40	No	UseCoordsForTax	Coords	Use latitude/longitude instead of address to determine tax jurisdiction/rate? (Green Check = Yes)
41	Yes	SOYear	Year	Sales Invoice Year
42	Yes	IsPaid	Paid	Paid Checkbox (Green Check = True)
43	Yes	LastDeposit	Last Dep	Last Deposit Date
44	Yes	PmtDays	Pmt Days	Days Until Payment is Due
45	Yes	AgedDays	Aged Days	Aged Days = Days from invoice date to now, only for invoices not fully paid
46	Yes	PastDueDays	Late Days	Days between the term due date and today, only for invoices not fully paid
47	Yes	TermDueDays	Term Days	Term Payment Days
48	No	CompCode	Comp	Company Code
49	Yes	LastJrnlID	Jrnl	Most recently posted Journal Identification Number (Systemic)
50	Yes	JrnlPeriod	Period	Financial Posting Period (YYYYMM) [Edit via Accounting/Finance/General Ledger/Posting Periods]
51	Yes	HasAttach	Att	Has Attachment Indicator (Green Check = True)
52	Yes	PickCost	Pick Cost	Total cost of picked items
53	Yes	GrossProfit	Gross Profit	Total Profit Amount = Revenue-COGS
54	Yes	GrossMargin	Gross Margin	Percent left over after paying all related direct expenses = (Revenue-COGS)/Revenue
55	No	TaxExempt	TaxE	Is sale tax exempt? (Green Check = Yes)
56	No	TaxEntityUseCode	Use Code	Tax Entity Use Code used to group similar customers for tax exemption purposes and link them to tax rules (Avalara)
57	No	EntityUseName	Use Name	Name of the tax entity use code used to group similar customers for tax exemption purposes and link them to tax rules (Avalara)
58	No	Whse	Whse	Warehouse Code [Edit via Inventory/Control/Warehouses]

Security

The following default roles can use this form:

Role	Allowed Actions
rl_Accounting	View
rl_AREntry	View
rl_ARManager	View
rl_FinRead	View
rl_ARRead	View