This browser may not honor CSS 2.1 and hence may not be capable to display this FMDiff Comparison Report correctly. Please upgrade to a more recent browser version. Recommended browsers are: FireFox, Safari, or equivalent.

FMDiff™ Report: “bps_Sales_Orders.fp7”
Tool
FMDiff (v2.0.1)
Date
2011-01-23 08:13:07
Elapsed Time
00:00:00.267
Tester
Winfried Huslik
Files
Old: bps_Sales_Orders.fp7
 
New: bps_Sales_Orders.fp7
Path
Users/
winfried/
Desktop/
BPS/
1.0/
bps_Sales_Orders.fp7
 
Users/
winfried/
Desktop/
BPS/
3.0/
bps_Sales_Orders.fp7
Creation Time
2003-11-07 07:24:34
 
2003-11-07 07:24:34
Modified
2010-06-02 22:54:02
 
2010-02-26 20:51:16
Size
996 KB (1019904 Byte)
 
824 KB (843776 Byte)
Used with
FileMaker Version
Count
 
FileMaker Version
Count
 
Developer 7.0v1
25
 
Developer 7.0v1
25
 
Pro 7.0v1
2
 
Pro 7.0v1
2
 
Developer 7.0v3
36
 
Developer 7.0v3
36
 
ProAdvanced 8.0v1
80
 
ProAdvanced 8.0v1
80
 
Server 7.0
4
 
Server 7.0
4
 
ProAdvanced 11.0v1
1
 
ProAdvanced 8.5v1
9
 
 
 
 
ProAdvanced 9.0v1
11
 
 
 
 
ProAdvanced 10.0v1
36
 
 
 
 
ProAdvanced 11.0v1
8
Used with
OS Version
Count
 
OS Version
Count
 
Windows
5
 
Windows
5
 
Windows 2000
24
 
Windows 2000
24
 
Mac PPC 10.2.8
2
 
Mac PPC 10.2.8
2
 
Mac PPC
12
 
Mac PPC
12
 
Mac PPC 10.3.9
75
 
Mac PPC 10.3.9
75
 
Mac PPC 10.3.8
36
 
Mac PPC 10.3.8
36
 
Windows Server 2003
1
 
Windows Server 2003
1
 
Mac PPC 10.4.2
4
 
Mac PPC 10.4.2
4
 
Mac Intel 10.6.3
1
 
Mac PPC 10.4.6
8
 
 
 
Mac Intel 10.4.9
12
 
 
 
Mac Intel 10.5.4
25
 
 
 
Mac Intel 10.4.11
10
 
 
 
Mac Intel 10.5.5
1
 
 
 
Mac Intel 10.5.8
8
No apparent errors or warnings.
Differences Overview
Removed
Modified
Added
 
2
 
 
1
1
 
7
2
2
13
11
 
1
4
 
 
2
 
6
1
5
 
1
 
3
 
 
2
1
 
1
 
2
1
3
Global Settings
 Window Settings
ID #"06" 
 
currBounds
{top: 0, left: 0, bottom: 690, right: 911}
 
{top: 1, left: 1, bottom: 690, right: 912}
prevBounds
{top: 0, left: 0, bottom: 752, right: 958}
 
{top: 1, left: 1, bottom: 675, right: 912}
 File Options
ID #"18" 
 
onOpenLayout
Form View
 
List View
 Base Table “Sales Orders”
ID #"8001" 
 
RecordsChangeCount
498
 
617
 Field “Invoice ID”
ID #"01" 
nextAutoEnterValue
2
 
31
modifications
22
 
24
 Field “Bill To Name”
ID #"02" 
indexLanguage
Not assigned
 
English
autoEnterOptions
 
 
useAutoEnterCalculation, replaceExistingValue
calculation
--
 
Contacts Bill To::Full Name
modifications
14
 
15
 Field “Bill To Street”
ID #"07" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::Street 1; 1; "" )
 
Contacts Bill To::Street 1
modifications
14
 
15
 Field “Bill To State”
ID #"08" 
indexLanguage
Not assigned
 
English
indexOptions
 
 
valueIndex, wordIndex
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::State 1; 1; "" )
 
Contacts Bill To::State 1
modifications
15
 
16
 Field “Bill To Postal Code”
ID #"0A" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::Postal Code 1; 1; "" )
 
Contacts Bill To::Postal Code 1
modifications
14
 
15
 Field “Ship To Name”
ID #"1F" 
indexLanguage
Not assigned
 
English
autoEnterOptions
 
 
useAutoEnterCalculation, replaceExistingValue
calculation
--
 
Contacts Ship To::Full Name
modifications
14
 
16
 Field “Bill To City”
ID #"20" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::City 1; 1; "" )
 
Contacts Bill To::City 1
modifications
14
 
15
 Field “Bill To Company”
ID #"21" 
indexLanguage
Not assigned
 
English
indexOptions
 
 
wordIndex
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::Company; 1; "" )
 
Contacts Bill To::Company
modifications
14
 
15
 Field “Ship To Company”
ID #"22" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Ship To Name = Contacts Ship To::Full Name; Contacts Ship To::Company; 1; "" )
 
Contacts Ship To::Company
modifications
17
 
19
 Field “Ship To Street”
ID #"23" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Ship To Name = Contacts Ship To::Full Name; Contacts Ship To::Street 1; 1; "" )
 
Contacts Ship To::Street 1
modifications
15
 
16
 Field “Ship To City”
ID #"24" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Ship To Name = Contacts Ship To::Full Name; Contacts Ship To::City 1; 1; "" )
 
Contacts Ship To::City 1
modifications
18
 
20
 Field “Ship To State”
ID #"25" 
indexLanguage
Not assigned
 
English
indexOptions
 
 
valueIndex, wordIndex
calculation
Case( Sales Orders::Ship To Name = Contacts Ship To::Full Name; Contacts Ship To::State 1; 1; "" )
 
Contacts Ship To::State 1
modifications
15
 
16
 Field “Ship To Postal Code”
ID #"26" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Ship To Name = Contacts Ship To::Full Name; Contacts Ship To::Postal Code 1; 1; "" )
 
Contacts Ship To::Postal Code 1
modifications
16
 
18
 Field “Product Serial Number”
ID #"27" 
 Field “Product Name”
ID #"28" 
 Field “Product Quantity”
ID #"29" 
 Field “Product Unit Price”
ID #"2A" 
 Field “Product Extended Amount”
ID #"2B" 
 Field “Subtotal”
ID #"2C" 
storageOptions
 
 
doNotStoreResults
calculation
Sum( Sales Orders::Product Extended Amount )
 
Sum( Line Items::Amount )
calcModifications
3
 
4
modifications
13
 
14
 Field “Sales Tax Rate”
ID #"2D" 
autoEnterOptions
 
 
useAutoEnterCalculation
calculation
--
 
Contacts Bill To::Tax Rate
nextAutoEnterValue
--
 
1
modifications
12
 
13
 Field “Sales Tax”
ID #"2E" 
indexLanguage
Not assigned
 
English
storageOptions
 
 
doNotStoreResults
calculation
Round( ( Sales Orders::Subtotal - Sales Orders::Discount ) * Sales Orders::Sales Tax Rate; 2 )
 
Round( Sales Orders::Sales Tax Rate * ( Sum( Line Items::Taxable Amount ) - Sales Orders::Discount ); 2 )
calcModifications
3
 
11
modifications
13
 
21
 Field “Invoice Total”
ID #"32" 
storageOptions
 
 
doNotStoreResults
 Field “Discount Rate”
ID #"33" 
autoEnterOptions
 
 
useAutoEnterCalculation
calculation
--
 
Contacts Bill To::Discount Rate
nextAutoEnterValue
--
 
1
modifications
12
 
13
 Field “Discount”
ID #"34" 
storageOptions
 
 
doNotStoreResults
calcModifications
3
 
5
modifications
13
 
15
 Field “Terms”
ID #"38" 
indexLanguage
Not assigned
 
English
indexOptions
 
 
wordIndex
 Field “Ship Via”
ID #"3A" 
indexLanguage
Not assigned
 
English
modifications
13
 
14
 Field “Weight”
ID #"3B" 
storageOptions
 
 
doNotStoreResults
calculation
Sum( Sales Orders::Product Weight; Sales Orders::Product Weight[2]; Sales Orders::Product Weight[3]; Sales Orders::Product Weight[4]; Sales Orders::Product Weight[5]; Sales Orders::Product Weight[6]; Sales Orders::Product Weight[7]; Sales Orders::Product Weight[8] )
 
Sum( Line Items::Product Weight )
calcModifications
2
 
3
modifications
14
 
15
 Field “Bill To Contact ID”
ID #"54" 
indexLanguage
Not assigned
 
English
autoEnterOptions
useAutoEnterCalculation, replaceExistingValue
 
replaceExistingValue
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::Contact ID; 1; "" )
 
--
modifications
2
 
3
 Field “Bill To Email”
ID #"56" 
indexLanguage
Not assigned
 
English
indexOptions
 
 
valueIndex, wordIndex
calculation
Case( Sales Orders::Bill To Name = Contacts Bill To::Full Name; Contacts Bill To::Email; 1; "" )
 
Contacts Bill To::Email
modifications
16
 
17
 Field “Ship To Email”
ID #"57" 
indexLanguage
Not assigned
 
English
calculation
Case( Sales Orders::Ship To Name = Contacts Ship To::Full Name; Contacts Ship To::Email; 1; "" )
 
Contacts Ship To::Email
modifications
18
 
20
 Field “Packing Slip X”
ID #"65" 
 Field “Flag Stock Checked”
ID #"6A" 
 Field “Product ID”
ID #"6D" 
 Field “Product Weight”
ID #"75" 
 Field “Ship To Contact ID”
ID #"76" 
 Field “ShipDateLabel”
ID #"78" 
 Table Occurrence “Sales Orders”
ID #"D00001" 
Occurrence.Bounds
{top: 20.0, left: 20.0, width: 131.0, height: 142.0}
 
{top: 20.0, left: 14.0, width: 131.0, height: 310.0}
modifications
36
 
58
Relation 1
R1: ​Sales Orders Inventory ​
 
R11: ​Sales Orders Contacts ​Bill To ​
2
R2: Sales Orders ↔ Contacts Bill To
 
 
3
R3: Sales Orders ↔ Contacts Ship To
 
R3: Sales Orders ↔ Contacts Ship To
4
R4: Sales Orders ↔ Sales One Record
 
R4: Sales Orders ↔ Sales One Record
5
R5: Sales Orders ↔ Contacts One
 
R5: Sales Orders ↔ Contacts One
6
R6: Sales Orders ↔ Sales Inventory ID
 
R6: Sales Orders ↔ Sales Inventory ID
7
 
 
R7: Line Items ↔ Sales Orders
 Table Occurrence “Sales One Record”
ID #"D00006" 
Occurrence.Bounds
{top: 236.0, left: 273.0, width: 162.0, height: 36.0}
 
{top: 265.0, left: 88.0, width: 179.0, height: 36.0}
modifications
12
 
17
 Base Table “Line Items”
ID #"8002" 
 
 Field “Product Item Number”
ID #"01" 
 Field “Description”
ID #"02" 
 Field “Quantity”
ID #"03" 
 Field “Price”
ID #"04" 
 Field “Taxable”
ID #"05" 
 Field “Amount”
ID #"06" 
 Field “Invoice ID”
ID #"07" 
 Field “Product Weight”
ID #"08" 
 Field “Packing Slip X”
ID #"09" 
 Field “Flag Stock Checked”
ID #"0A" 
 Field “Taxable Amount”
ID #"0D" 
 Table Occurrence “Line Items”
ID #"D00009" 
 Layout “List View”
ID #"02" 
 
modifications
126
 
148
 Layout “Sales Invoice”
ID #"03" 
 
modifications
62
 
91
 Layout “Form View”
ID #"0D" 
 
modifications
229
 
300
 Layout “Sales Report”
ID #"16" 
 
modifications
57
 
59
 Layout “Shipping Label, Avery 5164”
ID #"19" 
 
modifications
8
 
10
 Layout “Packing Slip”
ID #"1B" 
 
modifications
76
 
92
 Layout “Shipments Report”
ID #"1C" 
 
modifications
62
 
64
 Layout “Line Items”
ID #"1D" 
 
 Layout “Sales Chart”
ID #"1F" 
 
 Script “-”
ID #"08" 
 
modifications
1
 
2
 Script “- ”
ID #"17" 
 
modifications
1
 
2
 Script “-”
ID #"20" 
 
 Script “-”
ID #"21" 
 
modifications
1
 
2
 Script “-”
ID #"22" 
 
modifications
2
 
3
 Script “Copy Bill to Ship”
ID #"26" 
 
modifications
4
 
5
1
 
 
Set Field[ Sales Orders::Ship To Contact ID; Sales Orders::Bill To Contact ID ]
2
Set Field[ Sales Orders::Ship To Name; Sales Orders::Bill To Name ]
 
Set Field[ Sales Orders::Ship To Name; Sales Orders::Bill To Name ]
3
Set Field[ Sales Orders::Ship To Company; Sales Orders::Bill To Company ]
 
Set Field[ Sales Orders::Ship To Company; Sales Orders::Bill To Company ]
4
Set Field[ Sales Orders::Ship To Street; Sales Orders::Bill To Street ]
 
Set Field[ Sales Orders::Ship To Street; Sales Orders::Bill To Street ]
5
Set Field[ Sales Orders::Ship To City; Sales Orders::Bill To City ]
 
Set Field[ Sales Orders::Ship To City; Sales Orders::Bill To City ]
6
Set Field[ Sales Orders::Ship To State; Sales Orders::Bill To State ]
 
Set Field[ Sales Orders::Ship To State; Sales Orders::Bill To State ]
7
Set Field[ Sales Orders::Ship To Postal Code; Sales Orders::Bill To Postal Code ]
 
Set Field[ Sales Orders::Ship To Postal Code; Sales Orders::Bill To Postal Code ]
 Script “Open Script”
ID #"29" 
 
modifications
15
 
17
1
Allow User Abort[ Off ]
 
Allow User Abort[ Off ]
2
Set Error Capture[ On ]
 
Set Error Capture[ On ]
3
#
 
#
4
Set Window Title[ New Title: "Business Productivity Solution - Sales Orders" ]
 
Set Window Title[ New Title: "Business Productivity Solution - Sales Orders" ]
5
Perform Script[ “Open All Files” from file “Menu” ]
 
Perform Script[ “Open All Files” from file “Menu” ]
6
#
 
#
7
Show/Hide Status Area[ Show ]
 
Show/Hide Status Area[ Show ]
8
Go to Layout[ “Form View” ]
 
Go to Layout[ “Form View” ]
9
Enter Browse Mode[ ]
 
Enter Browse Mode[ ]
10
If[ not( fnIsWebConnection( ) ) ]
 
If[ not( fnIsWebConnection( ) ) ]
11
 
 
Move/Resize Window[ Current window; Top: 1; Left: 1 ]
12
Adjust Window[ Resize To Fit ]
 
Adjust Window[ Resize To Fit ]
13
End If
 
End If
14
#
 
#
15
#
 
#
16
Select Window[ ]
 
Select Window[ ]
17
#
 
#
 Script “Create New Sale from Contacts”
ID #"30" 
 
modifications
6
 
8
1
Allow User Abort[ Off ]
 
Allow User Abort[ Off ]
2
Select Window[ Current window ]
 
Select Window[ Current window ]
3
Go to Layout[ “Form View” ]
 
Go to Layout[ “Form View” ]
4
Show All Records
 
Show All Records
5
New Record/Request
 
New Record/Request
6
Set Field[ Sales Orders::Bill To Name; ​Contacts One::Temp Data ]
 
Set Field[ Sales Orders::Bill To Contact ​ID; ​Contacts One::Temp Data ]
7
Commit Records/Requests[ ] [ No dialog ]
 
Commit Records/Requests[ ] [ No dialog ]
8
Adjust Window[ Resize To Fit ]
 
Adjust Window[ Resize To Fit ]
 Script “-”
ID #"32" 
 
 Script “Sales Report”
ID #"33" 
 
modifications
14
 
15
1
Allow User Abort[ Off ]
 
Allow User Abort[ Off ]
2
If[ not( fnIsWebConnection( ) ) ]
 
If[ not( fnIsWebConnection( ) ) ]
3
New Window[ Name: "Sales Report"; Width: 700; Top: 0; Left: 0 ]
 
New Window[ Name: "Sales Report"; Width: 700; Top: 0; Left: 0 ]
4
Go to Layout[ “Sales Report” ]
 
Go to Layout[ “Sales Report” ]
5
Show Custom Dialog[ Title: "Report Choice"; Message: "Please choose whether you would like to see sales by Quarter, Week or Month"; Buttons: “Week”, “Month”, “Quarter” ]
 
Show Custom Dialog[ Title: "Report Choice"; Message: "Please choose whether you would like to see sales by Quarter, Week or Month"; Buttons: “Week”, “Month”, “Quarter” ]
6
If[ Get( LastMessageChoice ) = 1 ]
 
If[ Get( LastMessageChoice ) = 1 ]
7
Sort Records[ Specified Sort Order: Sales Orders::Report Sale Week ascending, Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
 
Sort Records[ Specified Sort Order: Sales Orders::Report Sale Week ascending, Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
8
Else If[ Get( LastMessageChoice ) = 2 ]
 
Else If[ Get( LastMessageChoice ) = 2 ]
9
Sort Records[ Specified Sort Order: Sales Orders::Report Sale Month ascending, Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
 
Sort Records[ Specified Sort Order: Sales Orders::Report Sale Month ascending, Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
10
Else
 
Else
11
Sort Records[ Specified Sort Order: Sales Orders::Report Sale Quarter ascending, Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
 
Sort Records[ Specified Sort Order: Sales Orders::Report Sale Quarter ascending, Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
12
End If
 
End If
13
Print Setup[ Comm: type; 1464880449: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -36.0, bottom: 594.0, right: 756.0}: Margin; 576.: PrintableWidth; 720.: PrintableHeight ] [ No dialog; Restore ]
 
Print Setup[ Comm: type; 1464880449: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -36.0, bottom: 594.0, right: 756.0}: Margin; 576.: PrintableWidth; 720.: PrintableHeight ] [ No dialog; Restore ]
14
Enter Preview Mode[ ]
 
Enter Preview Mode[ ]
15
Adjust Window[ Resize To Fit ]
 
Adjust Window[ Resize To Fit ]
16
Pause/Resume Script[ Indefinitely ]
 
Pause/Resume Script[ Indefinitely ]
17
Close Window[ Current Window ]
 
Close Window[ Current Window ]
18
Else
 
Else
19
Go to Layout[ “Sales Report” ]
 
Go to Layout[ “Sales Report” ]
20
Sort Records[ Specified Sort Order: Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
 
Sort Records[ Specified Sort Order: Sales Orders::Sale Date ascending ] [ No dialog; Restore ]
21
Pause/Resume Script[ Indefinitely ]
 
Pause/Resume Script[ Indefinitely ]
22
Go to Layout[ original layout ]
 
Go to Layout[ original layout ]
23
End If
 
End If
24
 
 
Unsort Records
 Script “Email Sales Invoice”
ID #"35" 
 
modifications
28
 
31
1
#
 
#
2
Commit Records/Requests[ ] [ No dialog ]
 
Commit Records/Requests[ ] [ No dialog ]
3
Allow User Abort[ Off ]
 
Allow User Abort[ Off ]
4
If[ not( fnIsWebConnection( ) ) ]
 
If[ not( fnIsWebConnection( ) ) ]
5
Set Variable[ $Invoice; Value: Let( [var0 = "filemac:" & Get( DesktopPath ); var1 = "filewin:" & Get( DesktopPath )]; Case( Abs( Get( SystemPlatform ) ) = 1; p_0; Abs( Get( SystemPlatform ) ) = 2; p_1 ) & "SalesInvoice" & Sales Orders::Invoice ID & ".pdf" ) ]
 
Set Variable[ $Invoice; Value: Let( [var0 = "filemac:" & Get( DesktopPath ); var1 = "filewin:" & Get( DesktopPath )]; Case( Abs( Get( SystemPlatform ) ) = 1; p_0; Abs( Get( SystemPlatform ) ) = 2; p_1 ) & "SalesInvoice" & Sales Orders::Invoice ID & ".pdf" ) ]
6
If[ IsEmpty( Sales Orders::Bill To Email ) ]
 
If[ IsEmpty( Sales Orders::Bill To Email ) ]
7
#
 
#
8
Show Custom Dialog[ Title: "Message"; Message: "There is no email address for this record. Please try again after entering an address."; Buttons: “OK” ]
 
Show Custom Dialog[ Title: "Message"; Message: "There is no email address for this record. Please try again after entering an address."; Buttons: “OK” ]
9
Go to Field[ Sales Orders::Bill To Email ]
 
Go to Field[ Sales Orders::Bill To Email ]
10
Halt Script
 
Halt Script
11
Else
 
Else
12
If[ IsValidExpression( Sales ​One Record::Invoice ​ID ) ​]
 
If[ Line Items::Invoice ​ID ]
13
Go to Related Record[ From table: Sales One ​Record ​; Using layout: Sales Invoice ; New window: "Sales Invoice"; Width: 700 ] [ Show only related records ]
 
Go to Related Record[ From table: Line Items ​; Using layout: Sales Invoice ; New window: "Sales Invoice"; Width: 700 ] [ Show only related records ]
14
Else
 
Else
15
Halt Script ​
 
Show Custom ​Dialog[ Title: "Alert"; Message: "There are no line items to display."; Buttons: OK ] ​
16
 
 
Exit Script[ ]
17
End If
 
End If
18
Print Setup[ Comm: type; 1464880449: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -36.0, bottom: 594.0, right: 756.0}: Margin; 576.: PrintableWidth; 720.: PrintableHeight ] [ No dialog; Restore ]
 
Print Setup[ Comm: type; 1464880449: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -36.0, bottom: 594.0, right: 756.0}: Margin; 576.: PrintableWidth; 720.: PrintableHeight ] [ No dialog; Restore ]
19
Save Records as PDF[ File Name: “$Invoice”; Records being browsed ] [ Document - Title: "Invoice #" & Sales Orders::Invoice ID; Compatibility: Acrobat 5 and later ] [ Pages - Number Pages From: 1; Include: All pages ] [ Security - Printing: High Resolution; Editing: Any except extracting pages; Enable Copying; Enable Screen Reader ] [ Initial View - Show: Pages Panel and Page; Page Layout: Single Page; Magnification: 100% ] [ No dialog; Restore ]
 
Save Records as PDF[ File Name: “$Invoice”; Records being browsed ] [ Document - Title: "Invoice #" & Sales Orders::Invoice ID; Compatibility: Acrobat 5 and later ] [ Pages - Number Pages From: 1; Include: All pages ] [ Security - Printing: High Resolution; Editing: Any except extracting pages; Enable Copying; Enable Screen Reader ] [ Initial View - Show: Pages Panel and Page; Page Layout: Single Page; Magnification: 100% ] [ No dialog; Restore ]
20
If[ Sales Orders::Ship To Email = Sales Orders::Bill To Email ]
 
If[ Sales Orders::Ship To Email = Sales Orders::Bill To Email ]
21
Send Mail[ Send via E-mail Client; To: Sales Orders::Bill To Name & " <" & Sales Orders::Bill To Email & ">"; Subject: "Invoice #" & Sales Orders::Invoice ID; Attachment: “$Invoice” ]
 
Send Mail[ Send via E-mail Client; To: Sales Orders::Bill To Name & " <" & Sales Orders::Bill To Email & ">"; Subject: "Invoice #" & Sales Orders::Invoice ID; Attachment: “$Invoice” ]
22
Else If[ IsEmpty( Sales Orders::Ship To Email ) ]
 
Else If[ IsEmpty( Sales Orders::Ship To Email ) ]
23
Send Mail[ Send via E-mail Client; To: Sales Orders::Bill To Name & " <" & Sales Orders::Bill To Email & ">"; Subject: "Invoice #" & Sales Orders::Invoice ID; Attachment: “$Invoice” ]
 
Send Mail[ Send via E-mail Client; To: Sales Orders::Bill To Name & " <" & Sales Orders::Bill To Email & ">"; Subject: "Invoice #" & Sales Orders::Invoice ID; Attachment: “$Invoice” ]
24
Else
 
Else
25
Send Mail[ Send via E-mail Client; To: Sales Orders::Bill To Name & " <" & Sales Orders::Bill To Email & ">" & ";" & Sales Orders::Ship To Name & " <" & Sales Orders::Ship To Email & ">"; Subject: "Invoice #" & Sales Orders::Invoice ID; Attachment: “$Invoice” ]
 
Send Mail[ Send via E-mail Client; To: Sales Orders::Bill To Name & " <" & Sales Orders::Bill To Email & ">" & ";" & Sales Orders::Ship To Name & " <" & Sales Orders::Ship To Email & ">"; Subject: "Invoice #" & Sales Orders::Invoice ID; Attachment: “$Invoice” ]
26
End If
 
End If
27
Close Window[ Current Window ]
 
Close Window[ Current Window ]
28
End If
 
End If
29
#
 
#
30
If[ Get( LastError ) ]
 
If[ Get( LastError ) ]
31
Show Custom Dialog[ Title: "Message"; Message: "There was an error addressing the email. Please check that your email software is installed correctly."; Buttons: “OK” ]
 
Show Custom Dialog[ Title: "Message"; Message: "There was an error addressing the email. Please check that your email software is installed correctly."; Buttons: “OK” ]
32
End If
 
End If
33
End If
 
End If
 Script “Print Packing Slip”
ID #"36" 
 
modifications
13
 
18
1
Allow User ​Abort[ Off ​]
 
New Window[ ​]
2
If[ not( fnIsWebConnection( ) ) ​]
 
Go to Related Record[ From ​table: Line Items ; Using layout: Packing Slip ​] [ Show only related records ] ​
3
Go to Related Record[ From table: Sales One Record ; Using layout: Packing ​Slip ; New window: "Packing Slip"; Width: 700; From top: 0; From ​left: 0 ​] [ Show only related ​records ​]
 
Print Setup[ Comm: type; Mac OS: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, ​left: -18.0, ​bottom: 594.0, right: 774.0}: Margin; 576.: PrintableWidth; 734.: PrintableHeight ​] [ No dialog; Restore ​]
4
Print Setup[ Comm: ​type; Mac OS: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -18.0, bottom: 594.0, right: 774.0}: Margin; 576.: PrintableWidth; 734.: PrintableHeight ​] [ No dialog; Restore ] ​
 
Enter Preview Mode[ ​]
5
Adjust Window[ Resize To Fit ]
 
Adjust Window[ Resize To Fit ]
6
Pause/Resume Script[ Indefinitely ]
 
Pause/Resume Script[ Indefinitely ]
7
Close Window[ Current Window ]
 
Close Window[ Current Window ]
8
Else
 
 
9
Go to Related Record[ From table: “Sales One Record”; Using layout: “Packing Slip” ] [ Show only related records ]
 
 
10
Pause/Resume Script[ Indefinitely ]
 
 
11
Go to Layout[ original layout ]
 
 
12
End If
 
 
 Script “-”
ID #"38" 
 
modifications
1
 
2
 Script “Check Stock”
ID #"39" 
 
modifications
38
 
43
1
 
 
Freeze Window
2
Allow User Abort[ Off ]
 
Allow User Abort[ Off ]
3
Set Variable[ $tempCounter; Value: ​1 ​]
 
Set Error Capture[ On ​]
4
Loop ​
 
If[ ​Line Items::Invoice ID ] ​
5
 
 
Go to Related Record[ From table: “Line Items”; Using layout: “Line Items” ] [ Show only related records ]
6
 
 
Go to Record/Request/Page[ First ]
7
Loop
 
Loop
8
If[ Sales Orders::Flag ​Stock Checked[$tempCounter] = ​1 ​]
 
If[ not( Line ​Items::Flag ​Stock Checked ) ​]
9
Set Variable[ $tempCounter; Value: $tempCounter + 1 ​]
 
Set Field[ Inventory::Amount in Stock; Inventory::Amount in ​Stock - Line Items::Quantity ​]
10
 
 
If[ Inventory::Amount in Stock < 0 ]
11
 
 
Set Field[ Line Items::Quantity; TextColor( Line Items::Quantity; RGB( 255; 0; 0 ) ) ]
12
 
 
Else
13
 
 
Set Field[ Line Items::Quantity; TextColor( Line Items::Quantity; RGB( 0; 102; 0 ) ) ]
14
 
 
End If
15
End If
 
End If
16
Exit Loop If[ ​IsEmpty( Sales Orders::Flag Stock Checked[$tempCounter] ) or $tempCounter = 8 ​]
 
Go to Record/Request/Page[ Next; ​Exit after last ​]
17
End Loop
 
End Loop
18
Set Field[ Sales Orders::Temp Data; ​Sales Orders::Product ID[$tempCounter] ​]
 
Go to Layout[ original layout ​]
19
Go ​to Related Record[ From table: Sales Inventory ID ; External; Using layout: Form View ] ​
 
Else ​
20
Set Field[ Sales Inventory ID::Amount ​in Stock; Sales Inventory ID::Amount in Stock - Sales Orders::Product Quantity[$tempCounter] ​]
 
If[ not( fnIsWebConnection( ) ) ​]
21
If[ Sales Inventory ID::Amount in Stock < 0 ​]
 
Show Custom Dialog[ Title: "Alert"; Message: "There are ​no line items to check."; Buttons: OK ​]
22
Set Field[ Sales Orders::Product Quantity[$tempCounter]; TextColor( Sales Orders::Product Quantity[$tempCounter]; RGB( 255; 0; 0 ) ) ]
 
 
23
Else
 
 
24
Set Field[ Sales Orders::Product Quantity[$tempCounter]; TextColor( Sales Orders::Product Quantity[$tempCounter]; RGB( 0; 102; 0 ) ) ]
 
 
25
End If
 
End If
26
Set Field[ ​Sales Orders::Flag Stock Checked[$tempCounter]; 1 ] ​
 
End If ​
27
Set Variable[ $tempCounter; Value: $tempCounter + 1 ]
 
 
28
Exit Loop If[ $tempCounter = 9 ]
 
 
29
End Loop
 
 
 Script “Sales Invoice”
ID #"3B" 
 
modifications
22
 
26
1
Allow User Abort[ Off ]
 
Allow User Abort[ Off ]
2
 
 
Set Error Capture[ On ]
3
If[ not( fnIsWebConnection( ) ) ]
 
If[ not( fnIsWebConnection( ) ) ]
4
Go to Related Record[ ​From table: Sales One Record ; Using layout: Sales Invoice ; New window: "Sales Invoice"; Width: 700; From top: 0; From left: 0 ​] [ Show only related records ] ​
 
If[ Line Items::Invoice ID ​]
5
Print Setup[ Comm: type; Mac OS: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, ​left: -18.0, ​bottom: 594.0, right: 774.0}: Margin; 576.: PrintableWidth; 734.: PrintableHeight ​] [ No dialog; Restore ​]
 
Go to Related Record[ From table: Line Items ; Using layout: Sales Invoice ​; New window: "Sales Invoice"; Width: 700; From top: 0; From ​left: 0 ​] [ Show only related ​records ​]
6
Enter Preview Mode[ ​]
 
Print Setup[ Comm: ​type; Mac OS: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -18.0, bottom: 594.0, right: 774.0}: Margin; 576.: PrintableWidth; 734.: PrintableHeight ​] [ No dialog; Restore ] ​
7
Adjust Window[ Resize ​To Fit ​]
 
Enter Preview Mode[ ​]
8
If[ Get( ScriptParameter ) = ​"Print" ​]
 
Adjust Window[ Resize To Fit ​]
9
Print[ Records being browsed; Comm: type; ​Mac OS: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -18.0, bottom: 594.0, right: 774.0}: Margin; 576.: PrintableWidth; 734.: PrintableHeight; Comm: type; Mac OS: Platform; 0: Offset; 1: From; 65535: To; 1: Copies ​]
 
If[ Get( ScriptParameter ) = "Print" ​]
10
 
 
Print[ Records being browsed; Comm: type; Mac OS: Platform; Portrait: Orientation; 100.%: Scale; {top: -18.0, left: -18.0, bottom: 594.0, right: 774.0}: Margin; 576.: PrintableWidth; 734.: PrintableHeight; Comm: type; Mac OS: Platform; 0: Offset; 1: From; 65535: To; 1: Copies ]
11
 
 
Else
12
 
 
Pause/Resume Script[ Indefinitely ]
13
 
 
End If
14
 
 
Close Window[ Current Window ]
15
Else
 
Else
16
Pause/Resume Script[ Indefinitely ​]
 
Show Custom Dialog[ ​Title: "Alert"; Message: "There are no line items to display."; Buttons: OK ​]
17
End If
 
End If
18
Close Window[ Current Window ]
 
 
19
Else
 
Else
20
Go to Related Record[ ​From table: Sales One Record ; Using layout: Sales Invoice ​] [ Show only related records ] ​
 
If[ Line Items::Invoice ID ​]
21
Pause/Resume Script[ Indefinitely ​]
 
Go to Related ​Record[ From table: Line Items ; Using layout: Sales Invoice ​] [ Show only related records ] ​
22
Go to Layout[ ​original layout ​]
 
Pause/Resume Script[ Indefinitely ​]
23
 
 
Go to Layout[ original layout ]
24
 
 
End If
25
End If
 
End If
26
#
 
#
27
#
 
#
 Script “-”
ID #"46" 
 
 Script “OnTrigger Capture Current Ship Date”
ID #"47" 
 
 Script “OnTrigger Shipping Delay ”
ID #"48" 
 
 Script “Print Packing Slip Copy”
ID #"49" 
 
 Script “Sorting”
ID #"4A" 
 
 Script “--”
ID #"4B" 
 
 Script “Navigation”
ID #"4C" 
 
 Script “--”
ID #"4D" 
 
 Script “Reports & Actions”
ID #"4E" 
 
 Script “--”
ID #"4F" 
 
 Script “Sales Chart”
ID #"50" 
 
 Account “Admin”
ID #"03" 
 
modifications
2
 
5
 Account “Mary Manager”
ID #"04" 
 
 Account “Carla Closer”
ID #"05" 
 
 Account “Paula Profit”
ID #"06" 
 
 Account “Sam Salesguy”
ID #"07" 
 
 Privilege “Managers”
ID #"04" 
 
 Privilege “Salespeople”
ID #"05" 
 
 Extended Privilege “fmiwp”
ID #"01" 
 
ExtPrivilegeFlags
[2 bytes]
 
[2 bytes]
ExtPrivilegeHash
[16 bytes]
 
[16 bytes]
modifications
6
 
17
 Extended Privilege “fmxdbc”
ID #"02" 
 
ExtPrivilegeFlags
--
 
[2 bytes]
ExtPrivilegeHash
[16 bytes]
 
[16 bytes]
modifications
--
 
1
 Extended Privilege “fmapp”
ID #"03" 
 
ExtPrivilegeHash
[16 bytes]
 
[16 bytes]
modifications
8
 
28
 Extended Privilege “fmmobile”
ID #"04" 
 
ExtPrivilegeFlags
--
 
[2 bytes]
ExtPrivilegeHash
[16 bytes]
 
[16 bytes]
modifications
--
 
2
 Extended Privilege “fmxml”
ID #"05" 
 
ExtPrivilegeFlags
--
 
[2 bytes]
ExtPrivilegeHash
[16 bytes]
 
[16 bytes]
modifications
--
 
1
 Extended Privilege “fmxslt”
ID #"06" 
 
ExtPrivilegeFlags
--
 
[2 bytes]
ExtPrivilegeHash
[16 bytes]
 
[16 bytes]
modifications
--
 
1
 Extended Privilege “fmphp”
ID #"07" 
 
 Graphic “105: 23 ⨉ 24”
ID #"69" 
 
 Graphic “106: 23 ⨉ 24”
ID #"6A" 
 
 Graphic “107: 24 ⨉ 24”
ID #"6B" 
 
 Graphic “32772: 23 ⨉ 24”
ID #"8004" 
 
 Graphic “32773: 24 ⨉ 24”
ID #"8005" 
 
 Graphic “32777: 12 ⨉ 12”
ID #"8009" 
 
 External Data Source “Menu”
ID #"01" 
 
 Table Occurrence “Menu”
ID #"D00002" 
Occurrence.Bounds
{top: 25.0, left: 171.0, width: 131.0, height: 116.0}
 
{top: 27.0, left: 452.0, width: 131.0, height: 116.0}
modifications
6
 
7
 External Data Source “Inventory”
ID #"02" 
 
 Table Occurrence “Inventory”
ID #"D00003" 
Occurrence.Bounds
{top: 238.0, left: 149.0, width: 177.0, height: 36.0}
 
{top: 513.0, left: 144.0, width: 179.0, height: 36.0}
modifications
11
 
20
Relation 1
R1: Sales Orders ​Inventory
 
R8: Line Items ​Inventory
 Table Occurrence “Sales Inventory ID”
ID #"D00008" 
Occurrence.Bounds
{top: 244.0, left: 194.0, width: 167.0, height: 36.0}
 
{top: 265.0, left: 277.0, width: 179.0, height: 36.0}
modifications
8
 
12
 External Data Source “Contacts”
ID #"04" 
 
 Table Occurrence “Contacts Bill To”
ID #"D00004" 
Occurrence.Bounds
{top: 235.0, left: 14.0, width: 179.0, height: 36.0}
 
{top: 278.0, left: 14.0, width: 155.0, height: 36.0}
modifications
9
 
22
Relation 1
R2: ​Sales Orders Contacts Bill To
 
R11: ​Sales Orders Contacts Bill To
 Table Occurrence “Contacts Ship To”
ID #"D00005" 
Occurrence.Bounds
{top: 237.0, left: 91.0, width: 176.0, height: 36.0}
 
{top: 265.0, left: 233.0, width: 179.0, height: 36.0}
modifications
8
 
15
 Table Occurrence “Contacts One”
ID #"D00007" 
Occurrence.Bounds
{top: 235.0, left: 52.0, width: 131.0, height: 36.0}
 
{top: 265.0, left: 189.0, width: 179.0, height: 36.0}
modifications
9
 
15
 Value List “Status”
ID #"03" 
 
modifications
3
 
6
CustomValue 1
 
 
New
2
Pending
 
Pending
3
Enroute ​
 
Shipped ​
4
 
 
Delivered
5
 
 
Canceled
6
 
 
-
 Value List “Contact Full Names”
ID #"05" 
 
Settings.flags
 
 
sortOnFirstField, showFirstField
field1
Contacts Bill To::Full Name
 
Contacts Bill To::Contact ID
field2
--
 
Contacts Bill To::Full Name
resort.language
--
 
English
modifications
3
 
4
 Value List “One”
ID #"06" 
 
 Custom Menu “View - data entry”
ID #"04" 
 
modifications
2
 
3
MenuItem 1
"Browse Mode"; Platforms: Macintosh, Windows; Command: Browse Mode
 
"Browse Mode"; Platforms: Macintosh, Windows; Command: Browse Mode
2
"Find Mode"; Platforms: Macintosh, Windows; Command: Find Mode
 
"Find Mode"; Platforms: Macintosh, Windows; Command: Find Mode
3
"Layout Mode"; Platforms: Macintosh, Windows; Command: Layout Mode
 
"Layout Mode"; Platforms: Macintosh, Windows; Command: Layout Mode
4
"Preview Mode"; Platforms: Macintosh, Windows; Command: Preview Mode
 
"Preview Mode"; Platforms: Macintosh, Windows; Command: Preview Mode
5
 
6
Submenu
 
Submenu
7
 
8
"View As Form"; Platforms: Macintosh, Windows; Command: View As Form
 
"View As Form"; Platforms: Macintosh, Windows; Script: Go to Form Layout; ​Command: View As Form
9
"View As List"; Platforms: Macintosh, Windows; Command: View As List
 
"View As List"; Platforms: Macintosh, Windows; Script: Go to List Layout; ​Command: View As List
10
"View As Table"; Platforms: Macintosh, Windows; Command: View As Table
 
"View As Table"; Platforms: Macintosh, Windows; Command: View As Table
11
 
12
Submenu
 
Submenu
13
"Status Bar"; Platform: Windows; Command: Status Bar
 
"Status Bar"; Platform: Windows; Command: Status Bar
14
"Status Area"; Platforms: Macintosh, Windows; Command: Status Area
 
"Status Area"; Platforms: Macintosh, Windows; Command: Status Area
15
 
16
"Text Ruler"; Platforms: Macintosh, Windows; Command: Text Ruler
 
"Text Ruler"; Platforms: Macintosh, Windows; Command: Text Ruler
17
 
18
"Zoom In"; Platforms: Macintosh, Windows; Command: Zoom In
 
"Zoom In"; Platforms: Macintosh, Windows; Command: Zoom In
19
"Zoom Out"; Platforms: Macintosh, Windows; Command: Zoom Out
 
"Zoom Out"; Platforms: Macintosh, Windows; Command: Zoom Out
 Relationship “⨝1: Sales Orders ↔ Inventory”
ID #"01" 
 
 Relationship “⨝2: Sales Orders ↔ Contacts Bill To”
ID #"02" 
 
 Relationship “⨝3: Sales Orders ↔ Contacts Ship To”
ID #"03" 
 
modifications
1
 
2
Predicate 1
Sales Orders::Ship To Name ​= Contacts Ship To::Full Name ​
 
Sales Orders::Ship To Contact ​ID ​= Contacts Ship To::Contact ID ​
 Relationship “⨝7: Line Items ↔ Sales Orders”
ID #"07" 
 
 Relationship “⨝8: Line Items ↔ Inventory”
ID #"08" 
 
 Relationship “⨝11: Sales Orders ↔ Contacts Bill To”
ID #"0B" 
 
End of Report
 
Legend:
--
Element does not exist in this file.
Please see FMDiff.com for further details.