R42565 & Formscape

elway

Active Member
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].
 
Hi

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.
 
Back
Top