Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Writer AP Check Decimal Issue

    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  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Writer AP Check Decimal Issue

    <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 Microsoft Employee on at
    RE: Report Writer AP Check Decimal Issue

    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

     

  • Steve Connors Profile Picture
    Steve Connors 165 on at
    RE: Report Writer AP Check Decimal Issue

    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>

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Writer AP Check Decimal Issue

    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
    RE: Report Writer AP Check Decimal Issue

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Writer AP Check Decimal Issue

    This article might help.

    support.microsoft.com/.../872275

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans