cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate Credit Memos - One G/L Account

0 Kudos
251

Hi all,

Our accountant just found out that there are duplicated G/L account applied in single Journal entry during he try to process his BAS.

I'm only 2 months in this company and business one, so I'm not sure why this G/L account applied twice in single Journal entry sometimes.

Does anyone know what is going on with these journal entry?

Thank you

p.s. it only happen on journal entries for some credit memo.

Accepted Solutions (1)

Accepted Solutions (1)

hdolenec
Contributor

I'm not familiar with BAS, but there are several reasons why would there be duplicate postings to same GL accounts.

If it is revenue or COGS account:

  • document has two lines with same account but different cost centers or projects
  • option to split journal entry by document lines is active

If it is customer receivable account:

  • chosen payment term has several installments
  • down payment was applied to document

Would be helpful to see Crredit Memo, journal entry and to know exactly which report is showing you these duplicate rows.

0 Kudos

Thank you for answering.

It is the first stated reason.

It happens to our revenue account.

And there is two lines with same G/L account applied with different cost in same document.

Is there any way to fix it for previously created document and prevent it for the future??

Thank you

hdolenec
Contributor
0 Kudos

But there is nothing to fix, that's how B1 was designed to work. In automatic journal entries postings are consolidated by GL account, cost centers and projects. The only way to have a single posting in your case is to not use cost accounting.

0 Kudos

Oh cool.

I thought it has some configuration problem within our accounting.

It's challenging to figure out myself with no experience in SAP accounting.

Thank you by the way.

Answers (1)

Answers (1)

msundararaja_perumal
Active Contributor
0 Kudos

slsap1997,

There is nothing special in SAP accounting, as long as you have knowledge in accounting, it should be good enough to understand the behavior.

You have provided in incomplete data, and from my first glance of the JE, it looks like the base document might have Down payment invoice, you need to present the entire document flow to understand the scenario and expect people to provide appropriate response.

Thanks.