E1: 40: 41: 42: 43: Posting Edit Code 'M' in Inventory, Sales, and Procurement - Distribution (Case Study) (Doc ID 2326399.1)

Last updated on OCTOBER 09, 2024

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.1 and later
JD Edwards EnterpriseOne Inventory Management - Version 9.1 and later
JD Edwards EnterpriseOne Sales Order Management - Version 9.1 and later
Information in this document applies to any platform.

Goal

The purpose of this document is to explain as-of behavior of posting edit code 'M, Machine-generated transactions only' in Inventory, Sales, and Procurement. The confusion may come in perceiving the words "machine-generated transactions only". Is the automatic account returned based on the settings in DMAAI considered 'machine-generated'?

Data Dictionary Definition

Alias- PEC (Posting Edit Code)
Definition: A code that controls G/L posting and account balance updates in the Account Master table (F0901).
Valid values are:
- Blank Allows all posting. Posts subledgers in detailed format for every account transaction. Does not require subledger entry.
- B Only allows posting to budget ledger types that begin with B, J, K, L, M, N, O or U.
- I Inactive account. No posting allowed.
- L Subledger and type are required for all transactions. Posts subledgers in detailed format for every account. The system stores the subledger and type in the Account Ledger (F0911) and Account Balances (F0902) tables. If you want to report on subledgers in the Financial Reporting feature, use this code.
- M Machine-generated transactions only (post program creates offsets).
- N Non-posting. Does not allow any post or account balance updates. In the Job Cost system, you can still post budget quantities.
- S Subledger and type are required for all transactions. Posts subledgers in summary format for every transaction. The system stores the subledger detail in the Account Ledger table. This code is not valid for budget entry programs.
- U Unit quantities are required for all transactions.
- X Subledger and type must be blank for all transactions. Does not allow subledger entry for the account.

Note that this document shall not deal with other posting edit code because it is not the scope of this document.

Possibly, this document explains the question Why P4310 with line type SC (Stock Inventory & G/L Account; which has Inventory Interface 'C') ends in error when account number from DMAAI is set 'M'? But inventory transaction does not issue any error?

Error Detail

Error Posting Edit Code Does Not Allow Entry
CAUSE:
The posting edit code does not allow transactions to be posted to this
account.

RESOLUTION:
Blank - all postings are allowed.
'N' - the Account or Business Unit does not allow posting.
'B' - only budgets may be entered for an account.
'S' or 'L' - a subledger and type must be entered for all transactions.
'X' - a subledger and type are not allowed for any transactions.
'I' - the account is inactive, posting is not allowed.
'K' - the final budget is "Locked" or frozen and budget changes must
be entered using journal entries.
'U' - units are required for all transactions.
'M' - only machine generated transactions are allowed for this account.
The posting edit code is defined for business units in the Business Unit Master
file (F0006) using Single Business Unit Revisions or Job Master Setup. The
posting edit is defined for accounts in the Account Master file (F0901)
using G/L Account Structure programs and Job Cost Basic/Speed Budget Setup.
ER Details:
       Form                                      P4310_W4310A
       Control Id                               1
       Control Title                            Grid
       Event                                    Row is Exit & Changed - Asynch
       Line No                                  1049
BSFN Details:
       Source File                             b0000108.c
       Source Line                            xxx
       Error ID                                 0069
       BSFN DSTR Item                     47