• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • 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!

R42565 & Formscape


Does anybody know about how JDE collates and processes the SOP information through the R42565 Print Invoice process? My UK client is using B8.11SP1 and wishes to generate invoices using Formscape but are having difficulty in locating data such as: Customer VAT reference, Customer Account Currency, (EEC) Commodity Class (aka Tariff Code) and Exchange Rate.

As people may know, the F42565 file holds the invoice data but is cleared once the invoice is printed. It may also be that some (or all) of these fields are not populated in F42565 at all. Possibly, a customisation of R42565 would even be necessary to pull in some of this data.

Given that these fields are all required for UK invoices, how have other UK clients resolved this issue?

[Also cross-posted to E1 Applications board].



We implemented the R42565 in formscape by customizing it, because it has a very variable layout with sections that appear or dissapear in different situatios

We created a new custom section for all output, and make all other sections to suppress output

In this new section we only have a GPTX string that we fill with XML to make the output.

then the XML is taken in formscape in a container to process the invoices


Instead of trying to use F42565, turn on EDI output for a R42565 version. This will populate the F470nn tables with invoice data that you can read using ODBC.

Just remember to regularly run the corresponding EDI purge to get rid of old invoices.