Batch from R31802 Created but No detail Entries to post to the F0911

We are running the R31802 nightly to Create our batches for IC,IM.IH, and IS. The Batch number is getting created but nothing is writing to G/L. It is not for every work order. Anybody have any ideas. The Items have cost, the AAI's are setup, etc...

Edward,

Check the WorkCenter messages for the user running R31802.
Is there an error message something like below?
---------------------------------------------------------------------------------
"4956.IGT does not exist in the Account Master file (F0901). NOTE: If you get this error message on a discount amount, it is indicating that the account numbers set up in the Automatic Accounting Instructions are invalid. The AAI records being validated against are PKD/PKL for Accounts Payable and RKD for Accounts Receivable. If business unit is not defined in the AAI accounts, the program will use the business unit from the voucher/invoice. If the error message is on adjustment reason in cash receipts, the same holds true about the AAI account number being invalid for the adjustment reason entered. If you get this error message on a job being closed, it is indicating that the AAI account JCPB (Prior Year End Balance in Closed Jobs), JCR (Job Revenue),or JCC (Job Costs) is not set up"
--------------------------------------------------------------------------------

If yes then your problem may be due to Work Orders with no Itms in their parts list or which have a text/Non-stock item as the only entry in the Parts List.

The problem is due to a BUG in the Edit Line section DO event.

Bug is that code is using MCU (Branch/Plant) from last F3111 row read. If WO has no Parts List (or a Text/Non-Stock Item) AND R31802 has not yet processed any WOs w/Parts List before the current WO then the value of the Component Branch MCU used to construct the G/L acct with is NULL or Blank (Null Business Unit = Bad Thing).

The Fix we implemented was to set the Component Branch MCU value = to the Work Order Header's "Charge To" MCU if value is NULL or Blank.
The below code was inserted at the top of the DO event to correct this:
// -----------------------------------------------------------------
// 08/31/2001 - L. Jones, Wagstaff, Set Currency Decimals to fix Rounding problem
// 01/11/2002 - L. Jones, Wagstaff, Correct Problem with Null Branch/MCU
// 05/10/2002 - L. Jones, Wagstaff, Correct Problem with Blank Branch/MCU
If VA rpt_szComponentBranch_CMCU is equal to <Null> Or VA rpt_szComponentBranch_CMCU is equal to <Blank>
VA rpt_szComponentBranch_CMCU = VA rpt_szChargeToCC_MCU
End If
// -----------------------------------------------------------------


Hope this fixes your problem.

Cheers,

Larry,

This could work for Doc. Type IM (Inventory) but what happen with the other
documents (IC, IH and IS), they are not being generated. I will suggest like
you are saying to check the workcenter messages and check the data selection
to see if it match the information in the WOs being processed.

Victor



Check the WorkCenter messages for the user running R31802.
Is there an error message something like below?
---------------------------------------------------------------------------------
"4956.IGT does not exist in the Account Master file (F0901). NOTE: If you
get this error message on a discount amount, it is indicating that the
account numbers set up in the Automatic Accounting Instructions are invalid.
The AAI records being validated against are PKD/PKL for Accounts Payable
and RKD for Accounts Receivable. If business unit is not defined in the AAI
accounts, the program will use the business unit from the voucher/invoice.
If the error message is on adjustment reason in cash receipts, the same
holds

Edward,

just to check ... there are absolutely NO Journal Entries out there for the Batch? What is the Batch Status?

Edward,

You aren't by any chance running R31802 at the same time that users are doing transactions such as WO Completions on these WO's, are you? We ran into this problem some time ago and learned the hard way that WO Completions and R31802 on those WO's MUST NOT run at the same time, or we'd lose postings.

I do know of one great way to stop Journals out of the R31802. Setup Row Security and make sure that the User ID/User Group running R31802 is excluded from seeing your Work Centers or Raw Material B/P. That will pretty much give the effect you see. The User (including "SCHEDULER") must have Row Security to see and update the Work Centers and Raw Material Branch. This is SERIOUS! I have experienced a Live Client lose one quarter of a million Euros of WIP because of someone's incorrect implementation of Row Security. It can really make a mess.