Open Forum

Expand all | Collapse all

invoice ship to addresses

  • 1.  invoice ship to addresses

    TOP CONTRIBUTOR
    Posted Jan 03, 2020 08:34 AM

    Hi All

    Happy New Year

    Were using BC130 on prem

    Working on our invoices (RDLC - report 1306) and having issues with addresses. I'm sure I'll have same issue on other reports too.

    The city, state zip is really messed up and not even consistent between company address (us) and ship to address

    Nav has City and ZIP concatenate din one field and state in another, so have get everything after last comma for ZIP, remove from city/zip and insert after city, state.
    . We were also missing our fax no.

    In object designer I was able to add Company ZIP and County (State) as separate fields in the dataset, but cannot find any fields for these for shipper address

    Anyone got any ideas and any info on how you're handling it?

    TiA

    Mark



    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: invoice ship to addresses

    Posted Jan 03, 2020 01:06 PM
    Have to tried to conduct word layout editing instead of RDLC for this particular document?  Formatting becomes a little easier in Word, but can't help slight differences to the fields, they would be the same in RDLC or Word layout editing as its the data on the XML.

    There isn't a Ship-to Fax, but there is a selltofaxno within the XML Fields available to map.  I believe you would need a developer to create an extension to add that field to the report.

    ------------------------------
    Steven Filipiak
    Business Consultant
    Columbus Global
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role