• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Address line (ADD1) prints only 30 characters on invoice

USEJ

Member
Hi list,

We are on B7332 and we have a problem when printing invoices. The address does
not appear completly.

In the Address Book, the address line (ADD1) is 40 characters, but when we print
the invoice (R42565), the ADD1 line prints only 30 characters.

We logged an issue on Knowledge Garden and they developped a Sar. The Call
number is 4072481 and the Sar is 4701269, but only for B9. So we are not able
to fix this issue.

Do you have the same printing problem? Would you be willing to join us to
speed up this issue.

Thanks for your help


***********************************
Martin Lévesque
Premier Tech
levm4@premiertech.com
418-867-8883 ext. 6385
 

Larry_Jones

Legendary Poster
Martin,

most companies would not use the "as-shipped-from-JDE" format for business documents. Major or minor formatting changes are usually applied to these documents to make them more presentable.

As such, why not spend the 10 - 15 minutes in the Report Design Aid to correct the problem yourself (by extending the field lengths)?

My apologies if you've already tried this and/or other remedies to address this issue and it still won't print more than 30 characters. My perception from your e-mail was that you had not tried to address the issue by modifying the document yourself.

FYI At our version level (see below) this is not an issue on our customized document.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 

Larry_Jones

Legendary Poster
Martin,

I just read KBohn's reply to your issue and am now with egg on my face. I don't know if this is a problem introduced with B7332 or a problem older than that that we encountered and coded around.

If it will help any below is the segment of code we use to retrieve and format the order address information.

0143 // =======================================================
0144 // Get the override Sold To Address Lines. If an override address
0145 // exists (no error), format the returned address lines, otherwise fetch
0146 // the appropriate address.
0147 // =======================================================
0148 //
0149 F4006 Get Order Address
BC Document (Order No, Invoice, etc.) -> mnDocumentNumber
BC Order Type -> szDocumentType
BC Order Company (Order Number) -> szDocumentCompany
"1" -> cAddressNumberType
RV Sold To Addr Alpha Name <- szMailingName
RV Sold To Addr Line 1 <- szAddressLine1
RV Sold To Addr Line 2 <- szAddressLine2
RV Sold To Addr Line 3 <- szAddressLine3
RV Sold To Addr Line 4 <- szAddressLine4
RV Zip Code WF <- szPostalCode
RV City (WF) <- szCity
UNDEFINED X szCounty
RV State WF <- szState
UNDEFINED X szCarrierRoute
UNDEFINED X szBulkMailing
RV Country WF <- szCountry
RV Addr Lines Error Code WF <- cFetchFailed
UNDEFINED X cBatchFile
0150 If RV Addr Lines Error Code WF is not equal to "1"
0151 F0116 Get Mailing Address Format
RV Sold To Addr Alpha Name <> szNameMailing
RV Sold To Addr Line 1 <> szAddressLine1
RV Sold To Addr Line 2 <> szAddressLine2
RV Sold To Addr Line 3 <> szAddressLine3
RV Sold To Addr Line 4 <> szAddressLine4
RV Sold To Addr Line 5 <> szAddressLine5
RV Sold To Addr Line 6 <> szAddressLine6
RV Sold To Addr Line 7 <> szAddressLine7
UNDEFINED X mnAddressNumber
RV City (WF) -> szCity
RV State WF -> szState
RV Zip Code WF -> szZipCodePostal
RV Country WF -> szCountry
UNDEFINED X szCountyAddress
0152 Else
0153 //
0154 // =======================================================
0155 // Retrieve from F0101 the 2nd, 3rd, 4th & 5th address numbers using
0156 // SHAN8 as the key.
0157 // The "Formatted Address" function will be passed an AN8, which the
0158 // function uses to extract the Address Lines. The actual AN8 we pass
0159 // depends on the "Send Invoice To" flag from the Customer Billing
0160 // Instructions. If '2' use Related Address 2, if '3' use Related Address
0161 // 3, if '4' use Related Address 4, if '5', use Related Address 6.
0162 // Otherwise, stick with SHAN8 from the business view.
0163 // =======================================================
0164 //
0165 // Sar # 1927465 - the error message WF must be initialized prior to the Get
0166 // Address info BF, then passed to the BF to insure that the returned value
0167 // valid
0168 RV Address Error Msg WF = " "
0169 //
0170 // NOTE: SAR 2824134. Add Related Address Number 1 Included
0171 // As An Output Parameter In The Following Call. RL5648295.
0172 //
0173 F0101 Get Address Information for OP
BC Address Number -> mnAddressNumber
UNDEFINED X szAlphaName
UNDEFINED X jdAddressEffectiveDate
UNDEFINED X szTaxCertificate
UNDEFINED X szCreditMessage
RV Related Addr 1 WF <- mnRelatedAddress1
RV Related Addr 2 WF <- mnRelatedAddress2
RV Related Addr 3 WF <- mnRelatedAddress3
RV Related Addr 4 WF <- mnRelatedAddress4
UNDEFINED X mnRelatedAddress5
RV Related Addr 6 WF <- mnRelatedAddress6
UNDEFINED X szBranchPlant
UNDEFINED X szLanguagePreference
RV Address Error Msg WF <> szErrorMessage
"1" -> cSuppressError
RV Sold To Tax ID WF <- szTaxID
RV Tax Person/Corp Format WF <- cPersonCorporationCode
0174 //
0175 If RV Address Error Msg WF is not equal to <Blank>
0176 RV AN8 For Address Lines WF = BC Address Number
0177 Else
0178 //
0179 // BEGIN: SAR 2824134. Add Related Address Number 1 Logic. RL5648295.
0180 //
0181 If RV Send Invoice To WF is equal to "1"
0182 RV AN8 For Address Lines WF = RV Related Addr 1 WF
0183 Else
0184 //
0185 // END: SAR 2824134. Add Related Address Number 1 Logic. RL5648295.
0186 //
0187 If RV Send Invoice To WF is equal to "2"
0188 RV AN8 For Address Lines WF = RV Related Addr 2 WF
0189 Else
0190 If RV Send Invoice To WF is equal to "3"
0191 RV AN8 For Address Lines WF = RV Related Addr 3 WF
0192 Else
0193 If RV Send Invoice To WF is equal to "4"
0194 RV AN8 For Address Lines WF = RV Related Addr 4 WF
0195 Else
0196 If RV Send Invoice To WF is equal to "5"
0197 RV AN8 For Address Lines WF = RV Related Addr 6 WF
0198 Else
0199 //
0200 // Sar #1927465 - if billing instructions say to use parent 0153 address, use
0201 // it.
0202 //
0203 If RV Send Invoice To WF is equal to "P"
0204 RV AN8 For Address Lines WF = BC Address Number - Parent (F42565)
0205 Else
0206 RV AN8 For Address Lines WF = BC Address Number
0207 End If
0208 End If
0209 End If
0210 End If
0211 End If
0212 End If
0213 End If
0214 //
0215 // =======================================================
0216 // Pass the extracted Address Number to the "Formatted Address"
0217 // function, which should return the correct formatted address lines.
0218 // =======================================================
0219 //
0220 F0116 Get Mailing Address Format
RV Sold To Addr Alpha Name <- szNameMailing
RV Sold To Addr Line 1 <- szAddressLine1
RV Sold To Addr Line 2 <- szAddressLine2
RV Sold To Addr Line 3 <- szAddressLine3
RV Sold To Addr Line 4 <- szAddressLine4
RV Sold To Addr Line 5 <- szAddressLine5
RV Sold To Addr Line 6 <- szAddressLine6
RV Sold To Addr Line 7 <- szAddressLine7
RV AN8 For Address Lines WF -> mnAddressNumber
UNDEFINED X szCity
UNDEFINED X szState
UNDEFINED X szZipCodePostal
UNDEFINED X szCountry
UNDEFINED X szCountyAddress
0221 End If
0222 //

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 

owss

Member
Re: [Address line (ADD1) prints only 30 characters on invoice ]

hi

You can create a new variable and name it using jde standards.
Then in the Do Section do a Fetch single to F0116 and assign to the new
variable. Don't forget initialize this variable before to assign the value.
Also hide the original variable.

Hope this help you until the Sar is completed.



USEJ <USEJ@premiertech.com> wrote:


Hi list,

We are on B7332 and we have a problem when printing invoices. The address
does
not appear completly.

In the Address Book, the address line (ADD1) is 40 characters, but when we
print
the invoice (R42565), the ADD1 line prints only 30 characters.

We logged an issue on Knowledge Garden and they developped a Sar. The Call
number is 4072481 and the Sar is 4701269, but only for B9. So we are not
able
to fix this issue.

Do you have the same printing problem? Would you be willing to join us to
speed up this issue.

Thanks for your help


***********************************
Martin Lévesque
Premier Tech
levm4@premiertech.com
418-867-8883 ext. 6385





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4080

*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************


____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
 
Top