Be delighted to--!
Uh Oh, Order Totals Are Wrong!
This week's free tip of the week is brought to you courtesy of Peter
Bannister, an independent JD Edwards consultant based in the UK. Reach
Peter at
[email protected]. Peter has spent 8 years implementing
JDE World and OneWorld for both end users and business partners within
Europe. Although he has a rich understanding of most of the ERP suite within
JDE, and a broad appreciation of the complementary products, he specialises
in distribution. He is currently on site at a large multi-national as a
finance/distribution consultant.
So you have looked at the credit check (P42050) for a customer and the order
totals look wrong – what do you do? Well the first thing is to understand
what you are looking at--
JDE allows credit checking at Parent, Customer and Line of Business, a
Knowledge Garden Document by JD Edwards (reference ODS-01-0094) goes some
way towards explaining how this should all work, this tip/trick gives some
pointers on what to do when it doesn’t.
Where do the credit check Amount Due and Order Totals come from?
The Amount Due comes from the total of the open amounts on the Accounts
Receivable detail file (F03B11 for those on OneWorld or F0311 for those on
World). The order total however comes from the F03012 (customer by Line of
Business) or the F0301, depending whether advanced Accounts Receivable is
being used or not.
It’s pretty certain that the Accounts Receivable figure is always going to
be correct but in a lot of circumstances the order total (APRC from the
above files) can get corrupted.
So how can I validate what the number should be?
Take a look at the sales order detail (F4211) file and look for orders that
are open e.g. less than next status 999. Take out all blanket orders, quote
orders, store/forward orders, held lines and all kit component lines.
Remember to take account of those lines that are back ordered. Convert the
extended value you get to the currency of the address book values (APRC),
using the order/transaction date as a basis for the exchange rate, and
total. This should be your baseline value by either customer or customer
and company depending whether you are using advanced accounts receivable or
not.
So the Open Order Values still don’t agree...what next?
The next step would be to run the program R42995 (Repost Active Sales
Orders) but there are some features of this program than people need to be
aware of. These are:
i) It has some hard coded logic internal to the program
which means that if you are using Advanced Accounts Receivable (e.g.
customers by company) then you need to create a version per company you want
to rebuild.
ii) Held orders “may not” be considered correctly. At the
time of writing this there are calls outstanding on the “inclusion” of held
order (see call 6437001)
iii) Some “foreign” orders miss some of the logic as
described in the validation section. Again there are calls for this (see
call 6446468)
iv) Some “foreign” orders still select status 999 orders, but
selections can be used to exclude these.
v) Zero the APRC field in the relevant file (F0301 or
F03012) before running R42995, this is similar to an existing tip for the
commitments (F41021) since if there are no open sales lines (lines at status
< 999) the open order totals will not be affected. Alternatively, the
suggestion from JDE is that a dummy sales line (at zero price!) is entered
before the run so there is a line at a status less than 999. This dummy
order would be cancelled after the R42995 has run. This second approach is
rather cumbersome but does not use any technical tools!
vi) Create versions for the update of Order Total separate to
any commitment update. Updating the order header and customer totals in the
same version are OK.
vii) Check security. The person who submits this job has to
have access to all the data.
viii) Make sure that all data on the customer master is correct,
as the R42995 checks to see of all data is correct before it updates the
customer record. If only one value is incorrect (albeit just the category
code) IT WILL NOT UPDATE the customer record with the new order totals. To
give a concrete example; if a UDC code from 01/03 (the UDC behind AC03) is
deleted with customers still having this assigned then R42995 will not
update the customer record with the recalculated value. This is true for
OneWorld only and is valid at update 5.
ix) There are rounding errors in the R42995 – so if you get
within a reasonable order of magnitude, don’t beat yourself up about it!!
These are all the circumstances the author is aware of at the time of
writing this, but the two last thoughts are to check the Knowledge Garden
and report the problem stating that you have walked through the above.
Good luck!
Andy Klee
www.JDEtips.com
Andy Klee
www.JDETips.com