Mark,
I am trying to come up with the Functional Specification for a similar
report to the one you mention below.
The requirement is to accrue work order labour and overheads based on the
work centres where the activity took place.
The assumption is no mods to JDE software are allowed.
Standard JDE posts the accruals against either the Charge To Business unit
on the Work Order if the AAI B.U is left blank=20
(AAI 3401) or the B.U entered in the AAI.=20
Mfg Accounting (R31802) cannot split out the recovery (accrual) based on
where the activity took place.=20
This information does however, as you allude to, live primarily in the
F31122 table, as work order hours are recorded at operation level which is
linked to a work centre.
(The accounting business unit related to work centre can then be derived if
the 'Project Number' field on the Bus Unit record for the Work centre is
populated with the related accounting BU)
Anyway - I can calculate the labour, labour o/head and machine o/head costs
by work centre based on data in the F31122 (and related files such as Work
Centre Rates table), and then determine which BU the accruals should have
been allocated to.=20
Similarly, for any labour / ohead / material variances I have been able to
calculate the details - give or take some rounding differences. ( As you say
getting the same totals as per the R31802 is difficult).=20
The report would then be used as the basis for generating correcting journal
entries to re-allocate the accruals. The frequency of the re-allocations is
yet to be determined, but would be at a minimum monthly.
What I am struggling with, and wondered if you had come up with a solution,
was how to select only a given range of work orders on the report so that
the re-allocations do not get doubled up or missed.
The issue is essentially a financial issue, in that JDE Manufacturing
Accounting cannot allocate the accruals based on where the activity took
place (i.e. when the payroll costs are expensed they will be expensed
against employees in the business units related to the work centres).=20
As such the main driver for running the report to determine what
re-allocation entries are required is, in my mind, the G/L Date.
I can determine which entries in the F31122 and F3112 / F3111 tables have
been posted to the G/L, but cannot then link the work orders to the G/L and
as such the G/L Date so that the report can be run for a reporting period.
I am posting the work order number to the subledger field in the G/L so
maybe this is the link ?
If you had come across this problem when developing your clients' solution,
how did you solve or get around it ?
Any feedback would be very welcome.
Regards,
Adrian
Xe Update 6, Citrix, HP, Oracle