• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Posting of A/R journal entries

We are currently testing some custom code changes for the posting of A/R
journal entries. We are trying to breakdown the A/R transactions to a finer
detail... for example instead of posting the automatic entry to
102000.104100, we would like to post the journal entry to
102000.104100.HFBD. We had to change P42800 and created a 55 for x4090 to
accomplish the change. The custom journal entries are created correctly,
the problem is the system will generate the automatic entry. Is there
someway to "turn off" the automatic entry only when we are posting the A/R
journal entries, without having to do a lot of custom code?

Any ideas are greatly appreciated.

Cathy Kaus
 

SallyWhite

Well Known Member
Cathy,

Unless I misunderstand your issue, I think JDE is already set up to allow comlete flexibility for the A/R automatic entry. This is based on the AAI RC**** item numbers by company, and you can override from your standard trade A/R account on each customer, by creating G/L class codes for each A/R trade account. You can also override the G/L Class code on each invoice entered, but that is more difficult to control. The association between G/L class and AAI is that the G/L class code (4 bytes) is appended to 'RC' to match the AAI item number (e.g., G/L class XYZ will post to the account specified in the AAI item RCXYZ for the company specified (or company 00000 for any company). So you are free to set up many automatic trade A/R accounts. I believe the automatic entry is created during the G/L post, and that is not a program to take lightly!


Regards,
Sally White
15+ yrs JDE Financials programming
V4R5/A7.3c10
 

John_Dickey

Reputable Poster
Cathy,
No, you cannot turn off the automatic posting without doing custom
coding. This is hard coded into JDE's G/L posting process. You can use
AAI's to adjust what G/L account the automatic posting entry will use.

John Dickey
White-Rodgers
(314) 577-1466
 
Sally

We currently use those codes in the transactions created in A/R. We changed
the P42800 to split the A/R trade account by invoice and G/L class. After
P42800 the transactions created are exactly what we need. When we try to
post the batch, the automatic AE entry for the A/R trade account is
generated, creating a duplication of entries and forcing the batch out of
balance.
 

SallyWhite

Well Known Member
Re: RE: Posting of A/R journal entries

Cathy,

In re-reading your original post, I still don't understand why you could not accomplish what you want by adding the subsidiary account to the RC AAI entries? The only way to avoid AEs being created by the G/L post is to use 9999 for G/L class. Perhaps it would help if you provide an example of the AE you get w/ the G/L post and the AE(s) you are creating w/ your custom P42800.

Regards,
Sally White
15+ yrs JDE Financials programming
V4R5/A7.3c10
 
RE: RE: Posting of A/R journal entries

Sally

I will try my best to explain what is happening with the posting. The
transactions generated from P42800 & the post program are:

Do
Ty Document G/L Date Account Desc.
Subledger/Asset # Debit Credit

AE 1 06/01/01 A/R Jde Mach Generated
102000.104100 1663.35
RI 1 06/01/01 A/r Jde Mach Generated
102000.104100.HFBD 1706.00
RI 1 06/01/01 COS
102025.352100.20601 711.82
RI 1 06/01/01 Finished Goods
102000.148000.HFBD 1289.51-
RI 1 06/01/01 All other j/e transactions
XXXXX.XXXXXX.XXXX XXXX.XX XXXXX.XX-

The goal is to capture the information for the A/R with the "HFBD" ,
accounting wants to break down the A/R to a finer detail. We use the flex
accounting to do this. We can not use the 9999 as the G/L class, as the G/L
class is being used to push thru the HFBD on the j/e's. The first entry is
created by the posting program, which causes the batch to be out of balance.
The second entry is generated from P42800. I am wondering if there is anyway
to stop the creation of the first entry?
 

John_Dickey

Reputable Poster
RE: RE: Posting of A/R journal entries

Cathy,
Okay, let me see if I understand what you are doing. You have added
custom code to the P42800 to generate the Debit to the Accounts Receivable
account, is that correct? Because JDE uses the AE entry to generate the
Trade A/R entry, you, in essence, are getting two debits to trade A/R, and
thus the journal entry is out of balance, correct?
Okay, this might be sneaky, but what if in the A/R AAI's for the RC
section you only had an entry for "blank" G/L class code. That would fix
the JDE AE entry to just one account. Then you would add to your custom
code in P42800 a credit entry that would offset that JDE AE entry. That
would then give you a journal entry that is back in balance. I figure since
you already had put in custom code to break down A/R trade as you want, that
is the best place to add the offset entry. How does that sound?

John Dickey
White-Rodgers
(314) 577-1466
 

SallyWhite

Well Known Member
Re: RE: RE: Posting of A/R journal entries

John:

I was going to suggest to Cathy that she add the credit entry to offset the expected AE to her custom P42800, but then wondered if the G/L post would consider the batch to be out of balance and reject it? I don't honestly know if you can 'trick' the G/L post like that!

Cathy:

If you are using the G/L Class to tell P42800 to code to 102000.104100.HFBD, why can't you set up your AAI for the RCxxxx (where xxxx is the G/L class) as:

Business Unit 102000
Object Account 104100
Subsidiary Account HFBD

Unless I am really missing something here, you would get the AE entry coded to 102000.104100.HFBD by the G/L post. Your custom change only makes an entry to one account, correct? Since the GLAA amounts for the G/L post-generated AE and the custom P42800 RI entry in your example don't have the same GLAA amounts, I may still not understand your requirements and why they cannot be attained via the AAI entry. I hope you understand that I am not trying to be difficult, but am still a little confused. If the only issue is that you want the HFBD subsidiary account included in the AE entry, your custom change is not necessary. If I am still missing your point, an example that shows what results you got prior to your custom change (using the same $$ in the example you posted) would be most helpful.

Regards,
Sally White
15+ yrs JDE Financials programming
V4R5/A7.3c10
 
Top