Invoice Print File

Oops

Member
Hi, List!

I've got some questions trying to get into OW philosophy so far.

Why do OW use F42565 (Invoice Print) table instead of getting records right from F4211 (Sales Order Detail) while printing invoice (R42565)?
Why are the records stored in the up-mentioned table? Is it a bug in B7332 SP13?

Any help would be greatly appreciated.

Thanks in advance.

Cheers,
Oops!
 

James_Halligan75

Active Member
The temporary table F42565 is created not from one file F4211, but also
F42119. The invoice print therefore facilitates re-print of invoices
where the F4211 has been purged to F42119

James
 
If you have ever looked through the code of R42565, you will realise what a huge and complicated program this is. To try and amend the invoice format from this program is a nightmare and a very high spec PC is required to do any amendments. Because the invoice format is subject to reasonably frequent changes, I am pleased that this work file is used as I can easily amend the format using the F42565 table. The changes that I have made to R42565 are 1. Suppress All output (No PDF created) and 2. In place of F42565.Delete I have instituted a call to our own invoice format print program. This has helped us to re format the print in a manner suitable for Formscape printing of invoices.

Sun ES4500 6x400 Processors, OneWorld XE (Finance, Distribution & Manufacturing), Oracle 8.1.6, NT4 Fat Clients.

Neil Mackenzie
I T Manager
Smiths Manufacturing (Pty) Ltd
Tel: (Direct) +27 (0) 31 7194142
Cell: +27 (0) 82 773 9605
Fax +27 (0) 31 7194444
e-Mail: [email protected]

Hi, List!

I've got some questions trying to get into OW philosophy so far.

Why do OW use F42565 (Invoice Print) table instead of getting records right from F4211 (Sales Order Detail) while printing invoice (R42565)?
Why are the records stored in the up-mentioned table? Is it a bug in B7332 SP13?

Any help would be greatly appreciated.

Thanks in advance.

Cheers,
Oops!


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=18194
 
The records should not be stored in the F42565 table. This is a work file
and should be cleared after the records have been processed. If an invoice
run is abnormally terminated in any way records can be 'stranded' in this
file. We had so many records in the file it really impacted the time to
process invoices (up to 20 minutes). The file just kept getting bigger &
bigger. JDE told us to make sure no invoicing was being processed and to
clear the records out of that file. Invoice processing time dropped to a
few seconds.

As to why they use the file - who knows??

Make it a great day!
Dianne

ONE WORLD
B73.2 Cum: 2 Mini-cum:applied
Service Pack Level 12.4
Enterprise Platform AS/400 V4R4 Co-existent
Testing B73.3.3 (Xe)
 

sf_woo

Active Member
Hi,

I understand that this is a temporary table. The printing invoice allows
print from past records in F42119 as well. The table stores records from
both F42119 and F4211. However we do find that this table does not get
purged properly at times if the invoice print job is terminated
unexpectedly. We use SQL to drop those records.

Regards

Sook Fun

OneWorld B732.2 SP 12.2
HP UX 11.0
Oracle 8.0.4
Citrix Metraframe 1.8
Fat clients - NT, Win98, Win95
 

Oops

Member
Dear List!

Thanks a lot!
Your replies were a great help for me and a nice confirmation of my own research.
I do hope that all of us were right and the job would be done :)!

Cheers and regards,
Oops!
 
Top