web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Report Writer AP Check...
Microsoft Dynamics GP (Archived)

Report Writer AP Check Decimal Issue

(0) ShareShare
ReportReport
Posted on by Steve Connors 165

I have an issue with a modifed form in Report Writer.  The report name is Check with Two Stubs on Top.  The unmodified report shows only 2 decimal places for Cents and the modifed report is showing 5.  The calulated string for both forms is exactly the same.

 

Currently reads:  Six Hundred Seventeen Dollars and 50000 Cents

Required:  Six Hundred Seventeen Dollars and 50 Cents

 

Any help is appreciated.

 

Thank you,

 

Steve

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    This article might help.

    support.microsoft.com/.../872275

    Cheers!

    Sanjay

  • Steve Connors Profile Picture
    Steve Connors 165 on at

    Thank you, but this does not work.  The field is a string as shown in teh example above.

  • Community Member Profile Picture
    Community Member on at

    Export your modified report to a package file.  open the package file in notepad, copy and paste it here.

    Cheers!

    Sanjay

  • Steve Connors Profile Picture
    Steve Connors 165 on at

    Here you go:

    <Component Name="Check with Two Stubs on Top" ProductId="0" Object="Report" >

    Report "Check with Two Stubs on Top"

    {

    CalculatedFields

    {

    CalculatedField "Calc Address 2"

    {

    EvaluateAfter "DocumentNumberBottom"

    Expression "if 'PM_Payment_WORK'.'Address 2' <>  \"\" then 'PM_Payment_WORK'.'Address 2'else 'PM_Payment_WORK'.'City-State-Zip Code'"

    ResultType "String"

    }

    CalculatedField "Calc Check Comment"

    {

    EvaluateAfter ""

    Expression "'PM_Payment_WORK'.'Check Comment'"

    ResultType "String"

    }

    CalculatedField "Calc Check Comment2"

    {

    EvaluateAfter "Calc Date"

    Expression "'PM_Payment_WORK'.'Check Comment'"

    ResultType "String"

    }

    CalculatedField "Calc City-State-Zip"

    {

    EvaluateAfter "Calc Address 2"

    Expression "if 'PM_Payment_WORK'.'Address 2' <>  \"\" then 'PM_Payment_WORK'.'City-State-Zip Code'else \"\" "

    ResultType "String"

    }

    CalculatedField "Calc Date"

    {

    EvaluateAfter "Calc Check Comment"

    Expression "'PM_Payment_WORK'.'Document Date'"

    ResultType "Date"

    }

    CalculatedField "Calc String 1"

    {

    EvaluateAfter "Calc City-State-Zip"

    Expression "'rw_SplitWordAmt'( 'PM_Payment_WORK'.'String A 255''PM_Payment_WORK'.'String B 255'75 1  )  "

    ResultType "String"

    }

    CalculatedField "Calc String 2"

    {

    EvaluateAfter "Calc String 1"

    Expression "'rw_SplitWordAmt'( 'PM_Payment_WORK'.'String A 255''PM_Payment_WORK'.'String B 255'75 2  )  "

    ResultType "String"

    }

    CalculatedField "Calc String 3"

    {

    EvaluateAfter "Calc String 2"

    Expression "'rw_SplitWordAmt'( 'PM_Payment_WORK'.'String A 255''PM_Payment_WORK'.'String B 255'75 3  )  "

    ResultType "String"

    }

    CalculatedField "Calc Which Check Comment"

    {

    EvaluateAfter "Data - Document Number"

    Expression "if  (  'Data - Document Number'  =  accumulator[433]  )   OR   (  accumulator[433]  =  \"\"  )  then 'Calc Check Comment2' else 'Calc Check Comment' "

    ResultType "String"

    }

    CalculatedField "Check Total"

    {

    EvaluateAfter "Calc Which Check Comment"

    Expression "if 'RW_Foreign_Currency'( 'PM_Payment_WORK'.'Currency ID' )   =  0  OR  'PM_Payment_WORK'.'Control Type' =  2 then 'PM_Payment_WORK'.'Check Total'else 'MC_PM_Transactions'.'Originating Check Total'"

    ResultType "Currency"

    }

    CalculatedField "Data - Document Number"

    {

    EvaluateAfter "Calc Check Comment2"

    Expression "'PM_Payment_WORK'.'Document Number'"

    ResultType "String"

    }

    CalculatedField "DocumentNumberBottom"

    {

    EvaluateAfter "DocumentNumberTop"

    Expression "if accumulator[433]  =  \"\" then \"Prepayment\" else 'PM_Payment_WORK'.'Document Number'"

    ResultType "String"

    }

    CalculatedField "DocumentNumberTop"

    {

    EvaluateAfter "Page Overflow"

    Expression "if 'PM_Payment_Stub_Duplicate'.'Document Number' =  \"\" then \"Prepayment\" else 'PM_Payment_Stub_Duplicate'.'Document Number'"

    ResultType "String"

    }

    CalculatedField "H1 Suppress"

    {

    EvaluateAfter ""

    Expression "\"\" "

    ResultType "String"

    }

    CalculatedField "Page Overflow"

    {

    EvaluateAfter "Check Total"

    Expression "if 'PM_Payment_WORK'.'Stub Overflow' =  0 then \"\" else \"* * *  C O N T I N U E D  O N  R E M I T T A N C E  * * *\" "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 1"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 1 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2'\"\" \"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 2"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 2 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2'\"\" \"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 3"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 3 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2'\"\" \"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    }

    DisplayName "Multi-Purpose Check"

    FirstPageHeader "true"

    Key "7"

    LastPageFooter "true"

    LeftMargin "0"

    MainTable "PM_Payment_WORK"

    MaxRecords "0"

    MultiLoginReport "false"

    Orientation "Portrait"

    ReportTables

    {

    ReportTable "00000"

    {

    LinkedTo ""

    Table "PM_Payment_WORK"

    }

    ReportTable "00001"

    {

    LinkedTo "PM_Payment_WORK"

    Table "PM_Payment_Stub_Duplicate"

    }

    ReportTable "00002"

    {

    LinkedTo "PM_Payment_WORK"

    Table "PM_Vendor_MSTR"

    }

    ReportTable "00003"

    {

    LinkedTo "PM_Payment_WORK"

    Table "MC_Currency_SETP"

    }

    ReportTable "00004"

    {

    LinkedTo "PM_Payment_WORK"

    Table "MC_PM_Transactions"

    }

    }

    Restrictions

    {

    Restriction "PmtEqPmt"

    {

    Expression "'PM_Payment_WORK'.'Payment Number' =  'PM_Payment_Stub_Duplicate'.'Payment Number'"

    }

    }

    Sections

    {

    ReportBody "Body"

    {

    Dividers

    {

    }

    Fields

    {

    ReportControl "363"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Document Date'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "147"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "49"

    ZOrder "13"

    }

    ReportControl "389"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Discount Taken Total'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "331"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "49"

    ZOrder "14"

    }

    ReportControl "393"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Net Check Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "501"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "77"

    ZOrder "15"

    }

    ReportControl "422"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Outstanding Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "202"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "70"

    ZOrder "16"

    }

    ReportCalculatedField "430"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "DocumentNumberTop"

    DisplayOptions "Visible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "42"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "17"

    }

    ReportControl "530"

    {

    Alignment "right"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Apply To Voucher Number'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "406"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "91"

    ZOrder "18"

    }

    }

    PositionBottom "88"

    SectionType "Body"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportFooter "Footer-Check & Hdr"

    {

    BreakField "'PM_Payment_Stub_Duplicate'.'Sequence Number'"

    Fields

    {

    ReportCalculatedField "284"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "Calc Check Comment"

    DisplayOptions "Invisible"

    DisplayType "LastOccurrence"

    Font "Courier (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "7"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "490"

    PositionTop "93"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "91"

    ZOrder "23"

    }

    ReportCalculatedField "338"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "Calc Check Comment2"

    DisplayOptions "Invisible"

    DisplayType "Data"

    Font "Courier (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "7"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "392"

    PositionTop "93"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "19"

    }

    ReportCalculatedField "343"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "Data - Document Number"

    DisplayOptions "Invisible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "119"

    PositionTop "91"

    ReadingOrder "LeftToRight"

    SizeHeight "11"

    SizeWidth "77"

    ZOrder "24"

    }

    ReportCalculatedField "344"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc Which Check Comment"

    DisplayOptions "Visible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "10"

    PositionTop "126"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "196"

    ZOrder "25"

    }

    ReportCalculatedField "404"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Page Overflow"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "ALIGN_CENTER"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "0"

    PositionTop "138"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "567"

    ZOrder "26"

    }

    ReportCalculatedField "431"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "DocumentNumberBottom"

    DisplayOptions "Invisible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "7"

    PositionTop "91"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "105"

    ZOrder "27"

    }

    ReportControl "433"

    {

    Alignment "left"

    BackColor "Yellow"

    DisplayOptions "Invisible"

    DisplayType "LastOccurrence"

    Field "'PM_Payment_WORK'.'Document Number'"

    Font "Courier (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "7"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "12"

    PositionTop "106"

    ReadingOrder "LeftToRight"

    SizeHeight "6"

    SizeWidth "49"

    ZOrder "28"

    }

    ReportControl "521"

    {

    Alignment "left"

    BackColor "White"

    DisplayOptions "Visible"

    DisplayType "Sum"

    Field "'PM_Payment_Stub_Duplicate'.'Outstanding Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "200"

    PositionTop "120"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "70"

    ZOrder "20"

    }

    ReportControl "523"

    {

    Alignment "left"

    BackColor "White"

    DisplayOptions "Visible"

    DisplayType "Sum"

    Field "'PM_Payment_Stub_Duplicate'.'Discount Taken Total'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "332"

    PositionTop "121"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "49"

    ZOrder "21"

    }

    ReportControl "526"

    {

    Alignment "left"

    BackColor "White"

    DisplayOptions "Visible"

    DisplayType "Sum"

    Field "'PM_Payment_Stub_Duplicate'.'Net Check Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "501"

    PositionTop "120"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "77"

    ZOrder "22"

    }

    }

    NoBreakAtRecordCount "false"

    PageBreak "false"

    PositionBottom "150"

    RecordsPerBody "0"

    ResetReport "false"

    SectionType "AdditionalFooter"

    SuppressLastRecord "true"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportFooter "Footer-Totals & Comment"

    {

    BreakField "'PM_Payment_WORK'.'Document Number'"

    Fields

    {

    }

    NoBreakAtRecordCount "false"

    PageBreak "true"

    PositionBottom "162"

    RecordsPerBody "0"

    ResetReport "false"

    SectionType "AdditionalFooter"

    SuppressLastRecord "false"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportHeader "Header-Hdr 2"

    {

    BreakField "'PM_Payment_Stub_Duplicate'.'Sequence Number'"

    Fields

    {

    ReportControl "319"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Vendor ID'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "530"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "56"

    ZOrder "8"

    }

    ReportControl "323"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Document Date'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "362"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "63"

    ZOrder "9"

    }

    ReportControl "326"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Document Number'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "445"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "79"

    ZOrder "10"

    }

    ReportText "532"

    {

    Alignment "right"

    BackColor "Transparent"

    DisplayOptions "Visible"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "174"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "63"

    Text "Vendor Name:"

    ZOrder "11"

    }

    ReportControl "533"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Vendor Name'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "240"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "12"

    }

    }

    NoBreakAtRecordCount "false"

    PositionBottom "76"

    RecordsPerReportBody "12"

    SectionType "AdditionalHeader"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportHeader "Header-Remittance Header"

    {

    BreakField "'PM_Payment_WORK'.'Document Number'"

    Fields

    {

    }

    NoBreakAtRecordCount "false"

    PositionBottom "35"

    RecordsPerReportBody "0"

    SectionType "AdditionalHeader"

    SuppressWhenFieldIsEmpty ""

    }

    ReportSection "PageFooter"

    {

    Fields

    {

    ReportCalculatedField "310"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc Date"

    DisplayOptions "Visible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "367"

    PositionTop "196"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "70"

    ZOrder "29"

    }

    ReportControl "349"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Field "'PM_Payment_WORK'.'Vendor Check Name'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "261"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "30"

    }

    ReportCalculatedField "386"

    {

    Alignment "right"

    BackColor "Transparent"

    CalculatedField "Check Total"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "443"

    PositionTop "242"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "31"

    }

    ReportCalculatedField "439"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc String 1"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "33"

    PositionTop "222"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "520"

    ZOrder "32"

    }

    ReportCalculatedField "440"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc String 2"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "33"

    PositionTop "234"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "380"

    ZOrder "33"

    }

    ReportCalculatedField "441"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc String 3"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "33"

    PositionTop "246"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "380"

    ZOrder "34"

    }

    ReportCalculatedField "502"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Vendor Address Line 1"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "273"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "35"

    }

    ReportCalculatedField "503"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Vendor Address Line 2"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "285"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "36"

    }

    ReportCalculatedField "504"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Vendor Address Line 3"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "297"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "37"

    }

    ReportControl "531"

    {

    Alignment "right"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Field "'PM_Payment_WORK'.'Document Number'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "478"

    PositionTop "196"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "70"

    ZOrder "38"

    }

    }

    PositionBottom "365"

    SectionType "PageFooter"

    }

    ReportSection "PageHeader"

    {

    Fields

    {

    }

    PositionBottom "23"

    SectionType "PageHeader"

    }

    }

    Series "Purchasing"

    SixLinesPerInch "true"

    SkipBlankRecords "false"

    SortSegments

    {

    }

    SuppressCents "false"

    Type "PreprintedFormGraphic"

    UseReportFooterForLastPageFooter "false"

    }

    </Component>

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Steve:

    Was able to import your format in my test environment and print check.  Guess what, I was not able to see the issue your are referring to.  The decimals and the words are printing just fine.  How ever I have created two calculated fields one for check amount and other for amount in words and placed it on the check.  The fields  are shaded light grey.  

    8117.Capture.JPG

     

     

    Shall post the package file shortly ... 

     

     

    Cheers!

    Sanjay

     

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    <Component Name="Check with Two Stubs on Top" ProductId="0" Object="Report" >

    Report "Check with Two Stubs on Top"

    {

    CalculatedFields

    {

    CalculatedField "Calc Address 2"

    {

    EvaluateAfter "DocumentNumberBottom"

    Expression "if 'PM_Payment_WORK'.'Address 2' <>  \"\" then 'PM_Payment_WORK'.'Address 2'else 'PM_Payment_WORK'.'City-State-Zip Code'"

    ResultType "String"

    }

    CalculatedField "Calc Check Comment"

    {

    EvaluateAfter ""

    Expression "'PM_Payment_WORK'.'Check Comment'"

    ResultType "String"

    }

    CalculatedField "Calc Check Comment2"

    {

    EvaluateAfter "Calc Date"

    Expression "'PM_Payment_WORK'.'Check Comment'"

    ResultType "String"

    }

    CalculatedField "Calc City-State-Zip"

    {

    EvaluateAfter "Calc Address 2"

    Expression "if 'PM_Payment_WORK'.'Address 2' <>  \"\" then 'PM_Payment_WORK'.'City-State-Zip Code'else \"\" "

    ResultType "String"

    }

    CalculatedField "Calc Date"

    {

    EvaluateAfter "Calc Check Comment"

    Expression "'PM_Payment_WORK'.'Document Date'"

    ResultType "Date"

    }

    CalculatedField "Calc String 1"

    {

    EvaluateAfter "Calc City-State-Zip"

    Expression "'rw_SplitWordAmt'( 'PM_Payment_WORK'.'String A 255''PM_Payment_WORK'.'String B 255'75 1  )  "

    ResultType "String"

    }

    CalculatedField "Calc String 2"

    {

    EvaluateAfter "Calc String 1"

    Expression "'rw_SplitWordAmt'( 'PM_Payment_WORK'.'String A 255''PM_Payment_WORK'.'String B 255'75 2  )  "

    ResultType "String"

    }

    CalculatedField "Calc String 3"

    {

    EvaluateAfter "Calc String 2"

    Expression "'rw_SplitWordAmt'( 'PM_Payment_WORK'.'String A 255''PM_Payment_WORK'.'String B 255'75 3  )  "

    ResultType "String"

    }

    CalculatedField "Calc Which Check Comment"

    {

    EvaluateAfter "Data - Document Number"

    Expression "if  (  'Data - Document Number'  =  accumulator[433]  )   OR   (  accumulator[433]  =  \"\"  )  then 'Calc Check Comment2' else 'Calc Check Comment' "

    ResultType "String"

    }

    CalculatedField "Check Total"

    {

    EvaluateAfter "Calc Which Check Comment"

    Expression "if 'RW_Foreign_Currency'( 'PM_Payment_WORK'.'Currency ID' )   =  0  OR  'PM_Payment_WORK'.'Control Type' =  2 then 'PM_Payment_WORK'.'Check Total'else 'MC_PM_Transactions'.'Originating Check Total'"

    ResultType "Currency"

    }

    CalculatedField "Data - Document Number"

    {

    EvaluateAfter "Calc Check Comment2"

    Expression "'PM_Payment_WORK'.'Document Number'"

    ResultType "String"

    }

    CalculatedField "DocumentNumberBottom"

    {

    EvaluateAfter "DocumentNumberTop"

    Expression "if accumulator[433]  =  \"\" then \"Prepayment\" else 'PM_Payment_WORK'.'Document Number'"

    ResultType "String"

    }

    CalculatedField "DocumentNumberTop"

    {

    EvaluateAfter "Page Overflow"

    Expression "if 'PM_Payment_Stub_Duplicate'.'Document Number' =  \"\" then \"Prepayment\" else 'PM_Payment_Stub_Duplicate'.'Document Number'"

    ResultType "String"

    }

    CalculatedField "H1 Suppress"

    {

    EvaluateAfter ""

    Expression "\"\" "

    ResultType "String"

    }

    CalculatedField "Page Overflow"

    {

    EvaluateAfter "Check Total"

    Expression "if 'PM_Payment_WORK'.'Stub Overflow' =  0 then \"\" else \"* * *  C O N T I N U E D  O N  R E M I T T A N C E  * * *\" "

    ResultType "String"

    }

    CalculatedField "Rounded"

    {

    EvaluateAfter ""

    Expression "'RW_Round'( 'PM_Payment_WORK'.'Check Total'0 2 2  )  "

    ResultType "Currency"

    }

    CalculatedField "Rounded-AIW"

    {

    EvaluateAfter ""

    Expression "'RW_ConvertToWordsAndNumbers'( 'PM_Payment_WORK'.'Check Total''MC_Currency_SETP'.'Currency ID'0  )  "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 1"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 1 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2'\"\" \"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 2"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 2 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2'\"\" \"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    CalculatedField "Vendor Address Line 3"

    {

    EvaluateAfter ""

    Expression "'rw_SelectAddrLine'( 3 \"\" 'PM_Payment_WORK'.'Address 1''PM_Payment_WORK'.'Address 2'\"\" \"\" 'PM_Payment_WORK'.'City''PM_Payment_WORK'.'State''PM_Payment_WORK'.'Zip Code'\"\"  )  "

    ResultType "String"

    }

    }

    DisplayName "Multi-Purpose Check"

    FirstPageHeader "true"

    Key "7"

    LastPageFooter "true"

    LeftMargin "0"

    MainTable "PM_Payment_WORK"

    MaxRecords "0"

    MultiLoginReport "false"

    Orientation "Portrait"

    ReportTables

    {

    ReportTable "00000"

    {

    LinkedTo ""

    Table "PM_Payment_WORK"

    }

    ReportTable "00001"

    {

    LinkedTo "PM_Payment_WORK"

    Table "PM_Payment_Stub_Duplicate"

    }

    ReportTable "00002"

    {

    LinkedTo "PM_Payment_WORK"

    Table "PM_Vendor_MSTR"

    }

    ReportTable "00003"

    {

    LinkedTo "PM_Payment_WORK"

    Table "MC_Currency_SETP"

    }

    ReportTable "00004"

    {

    LinkedTo "PM_Payment_WORK"

    Table "MC_PM_Transactions"

    }

    }

    Restrictions

    {

    Restriction "PmtEqPmt"

    {

    Expression "'PM_Payment_WORK'.'Payment Number' =  'PM_Payment_Stub_Duplicate'.'Payment Number'"

    }

    }

    Sections

    {

    ReportBody "Body"

    {

    Dividers

    {

    }

    Fields

    {

    ReportControl "363"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Document Date'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "147"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "49"

    ZOrder "13"

    }

    ReportControl "389"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Discount Taken Total'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "331"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "49"

    ZOrder "14"

    }

    ReportControl "393"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Net Check Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "501"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "77"

    ZOrder "15"

    }

    ReportControl "422"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Outstanding Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "202"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "70"

    ZOrder "16"

    }

    ReportCalculatedField "430"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "DocumentNumberTop"

    DisplayOptions "Visible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "42"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "17"

    }

    ReportControl "530"

    {

    Alignment "right"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_Stub_Duplicate'.'Apply To Voucher Number'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "406"

    PositionTop "77"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "91"

    ZOrder "18"

    }

    }

    PositionBottom "88"

    SectionType "Body"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportFooter "Footer-Check & Hdr"

    {

    BreakField "'PM_Payment_Stub_Duplicate'.'Sequence Number'"

    Fields

    {

    ReportCalculatedField "284"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "Calc Check Comment"

    DisplayOptions "Invisible"

    DisplayType "LastOccurrence"

    Font "Courier (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "7"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "490"

    PositionTop "93"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "91"

    ZOrder "23"

    }

    ReportCalculatedField "338"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "Calc Check Comment2"

    DisplayOptions "Invisible"

    DisplayType "Data"

    Font "Courier (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "7"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "392"

    PositionTop "93"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "19"

    }

    ReportCalculatedField "343"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "Data - Document Number"

    DisplayOptions "Invisible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "119"

    PositionTop "91"

    ReadingOrder "LeftToRight"

    SizeHeight "11"

    SizeWidth "77"

    ZOrder "24"

    }

    ReportCalculatedField "344"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc Which Check Comment"

    DisplayOptions "Visible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "10"

    PositionTop "126"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "196"

    ZOrder "25"

    }

    ReportCalculatedField "404"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Page Overflow"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "ALIGN_CENTER"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "0"

    PositionTop "138"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "567"

    ZOrder "26"

    }

    ReportCalculatedField "431"

    {

    Alignment "left"

    BackColor "Yellow"

    CalculatedField "DocumentNumberBottom"

    DisplayOptions "Invisible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "7"

    PositionTop "91"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "105"

    ZOrder "27"

    }

    ReportControl "433"

    {

    Alignment "left"

    BackColor "Yellow"

    DisplayOptions "Invisible"

    DisplayType "LastOccurrence"

    Field "'PM_Payment_WORK'.'Document Number'"

    Font "Courier (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "7"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "12"

    PositionTop "106"

    ReadingOrder "LeftToRight"

    SizeHeight "6"

    SizeWidth "49"

    ZOrder "28"

    }

    ReportControl "521"

    {

    Alignment "left"

    BackColor "White"

    DisplayOptions "Visible"

    DisplayType "Sum"

    Field "'PM_Payment_Stub_Duplicate'.'Outstanding Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "200"

    PositionTop "120"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "70"

    ZOrder "20"

    }

    ReportControl "523"

    {

    Alignment "left"

    BackColor "White"

    DisplayOptions "Visible"

    DisplayType "Sum"

    Field "'PM_Payment_Stub_Duplicate'.'Discount Taken Total'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "332"

    PositionTop "121"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "49"

    ZOrder "21"

    }

    ReportControl "526"

    {

    Alignment "left"

    BackColor "White"

    DisplayOptions "Visible"

    DisplayType "Sum"

    Field "'PM_Payment_Stub_Duplicate'.'Net Check Amount'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "501"

    PositionTop "120"

    ReadingOrder "LeftToRight"

    SizeHeight "10"

    SizeWidth "77"

    ZOrder "22"

    }

    }

    NoBreakAtRecordCount "false"

    PageBreak "false"

    PositionBottom "150"

    RecordsPerBody "0"

    ResetReport "false"

    SectionType "AdditionalFooter"

    SuppressLastRecord "true"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportFooter "Footer-Totals & Comment"

    {

    BreakField "'PM_Payment_WORK'.'Document Number'"

    Fields

    {

    }

    NoBreakAtRecordCount "false"

    PageBreak "true"

    PositionBottom "162"

    RecordsPerBody "0"

    ResetReport "false"

    SectionType "AdditionalFooter"

    SuppressLastRecord "false"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportHeader "Header-Hdr 2"

    {

    BreakField "'PM_Payment_Stub_Duplicate'.'Sequence Number'"

    Fields

    {

    ReportControl "319"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Vendor ID'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "530"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "56"

    ZOrder "8"

    }

    ReportControl "323"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Document Date'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "362"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "63"

    ZOrder "9"

    }

    ReportControl "326"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Document Number'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "445"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "79"

    ZOrder "10"

    }

    ReportText "532"

    {

    Alignment "right"

    BackColor "Transparent"

    DisplayOptions "Visible"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "174"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "63"

    Text "Vendor Name:"

    ZOrder "11"

    }

    ReportControl "533"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "Data"

    Field "'PM_Payment_WORK'.'Vendor Name'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "8"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "240"

    PositionTop "49"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "12"

    }

    }

    NoBreakAtRecordCount "false"

    PositionBottom "76"

    RecordsPerReportBody "12"

    SectionType "AdditionalHeader"

    SuppressWhenFieldIsEmpty ""

    }

    AdditionalReportHeader "Header-Remittance Header"

    {

    BreakField "'PM_Payment_WORK'.'Document Number'"

    Fields

    {

    }

    NoBreakAtRecordCount "false"

    PositionBottom "35"

    RecordsPerReportBody "0"

    SectionType "AdditionalHeader"

    SuppressWhenFieldIsEmpty ""

    }

    ReportSection "PageFooter"

    {

    Fields

    {

    ReportCalculatedField "310"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc Date"

    DisplayOptions "Visible"

    DisplayType "Data"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "367"

    PositionTop "172"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "70"

    ZOrder "29"

    }

    ReportControl "349"

    {

    Alignment "left"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Field "'PM_Payment_WORK'.'Vendor Check Name'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "261"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "30"

    }

    ReportCalculatedField "386"

    {

    Alignment "right"

    BackColor "Transparent"

    CalculatedField "Check Total"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format "DLR11_$S2"

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "443"

    PositionTop "242"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "84"

    ZOrder "31"

    }

    ReportCalculatedField "439"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc String 1"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "33"

    PositionTop "222"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "520"

    ZOrder "32"

    }

    ReportCalculatedField "440"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc String 2"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "33"

    PositionTop "234"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "380"

    ZOrder "33"

    }

    ReportCalculatedField "441"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Calc String 3"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "33"

    PositionTop "246"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "380"

    ZOrder "34"

    }

    ReportCalculatedField "502"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Vendor Address Line 1"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "273"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "35"

    }

    ReportCalculatedField "503"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Vendor Address Line 2"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "285"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "36"

    }

    ReportCalculatedField "504"

    {

    Alignment "left"

    BackColor "Transparent"

    CalculatedField "Vendor Address Line 3"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "73"

    PositionTop "297"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "210"

    ZOrder "37"

    }

    ReportControl "531"

    {

    Alignment "right"

    BackColor "Transparent"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Field "'PM_Payment_WORK'.'Document Number'"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "478"

    PositionTop "172"

    ReadingOrder "LeftToRight"

    SizeHeight "12"

    SizeWidth "70"

    ZOrder "38"

    }

    ReportCalculatedField "534"

    {

    Alignment "left"

    BackColor "Light Gray"

    CalculatedField "Rounded"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "443"

    PositionTop "264"

    ReadingOrder "LeftToRight"

    SizeHeight "13"

    SizeWidth "84"

    ZOrder "40"

    }

    ReportCalculatedField "536"

    {

    Alignment "left"

    BackColor "Light Gray"

    CalculatedField "Rounded-AIW"

    DisplayOptions "Visible"

    DisplayType "LastOccurrence"

    Font "Helvetica (generic)"

    FontBold "false"

    FontColor "Black"

    FontItalic "false"

    FontSize "10"

    FontUnderline "false"

    Format ""

    FormatField ""

    Pattern "(none)"

    PatternColor "White"

    PositionLeft "35"

    PositionTop "204"

    ReadingOrder "LeftToRight"

    SizeHeight "13"

    SizeWidth "518"

    ZOrder "42"

    }

    }

    PositionBottom "365"

    SectionType "PageFooter"

    }

    ReportSection "PageHeader"

    {

    Fields

    {

    }

    PositionBottom "23"

    SectionType "PageHeader"

    }

    }

    Series "Purchasing"

    SixLinesPerInch "true"

    SkipBlankRecords "false"

    SortSegments

    {

    }

    SuppressCents "false"

    Type "PreprintedFormGraphic"

    UseReportFooterForLastPageFooter "false"

    }

    </Component>

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Steve

    The above package was tested at GP2013 SP2.  Before you import the file ensure you backup copy of your existing report.  Backup your system and company database. Conduct the test at your test environment. Hope it  works for you.

    Cheers!

    Sanjay  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans