cancel
Showing results for 
Search instead for 
Did you mean: 

Advance G/L determination user can't change GL from row level

MukeshSingh
Participant
0 Kudos

Hi Export,

We are using SAP 9.0 PL-10 and we active Advance G/L determination and set by item wise & BP group wise.

Problem

When we making AP Invoice then GL account pick as per Advance G/L determination setting but we need validation system check Advance G/L determination setting if not match with correct GL account (Item wise) as per setting then system block the entry.


Regards,

Mukesh Singh

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member1098261
Participant
0 Kudos

Hi Mukesh Singh,

Your problem is that, you cannot change GL account into A/P invoice at row level?

If this is your problem, the reason could be the "purchase account posting system" in your Company detail. If this option is checked, you cannot change GL Account at row level in documents.

MukeshSingh
Participant
0 Kudos

Hi Jonny Cortonicchi,

In my SAP this field not enable, please find the attachment.

Thanks

Mukesh Singh

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Do you require transaction notification? Please post Advance G/L determination setting and  correct GL account windows with field information.

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Good Morning Sir,

Please find the screen short.

we need if we already set advance GL determination then system check setting if user change then block the entry.

Thanks

Mukesh Singh

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Let me check and update ASAP.

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Hi Nagarajan Sir,

Any update i am waiting for your reply.

Mukesh

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Sorry to keep you waiting. To create required SPTN, can i check your DB through team viwer? Because in my DB there is no above features.

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Yes sir please give your cell no or any contact so that i give my TV.

Thanks

Mukesh Singh

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please "Follow" to get details of me.

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Hi Nagarajan Sir,

I can't access your contact no.

If possible please send me your skypeid or contact details or guide me how to validate advance gl determination.

Regards,

Mukesh Singh

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please send your ammyy ID through "direct message".

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Hi Nagarajan Sir,

By mistake click Assumed Answered.

my ammy id is 25 855 431, please help.

Thanks

Regarrds,

Mukesh Singh

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Which version using for ammyy?

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Sory for delay reply Ammy admin version - V2.13 ID- 25 855 431

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Not having enough time to check through ammyy now. I will check may be after 3 hours.

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Ok sir i am waiting for you

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Can you install latest version of ammyy?

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Hi Nagarajan Sir,

If possible please send SPTN for AP Invoice validation.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this and add your required advanced account code in like function.

IF @transaction_type in ('A') AND (@OBJECT_TYPE='18')


BEGIN


If exists (SELECT T1.[DocEntry] FROM OACT T0  INNER JOIN pch1
T1 ON T0.AcctCode = T1.AcctCode inner join OPCh t2 on t2.docentry
= t1.docentry where t0.formatcode NOt like '%%4%%' and t2.doctype
= 'S' and t1.docEntry = @list_of_cols_val_tab_del)


Begin


SET @error = 1
SET @error_message = 'Not allowed to choose
Asset Account'


End


End

Thanks & Regards,

Nagarajan

MukeshSingh
Participant
0 Kudos

Hi nagarajan Sir,

This query not helpful.

I installed Ammy Admin v3.

Please give your time so that we try to fix the issues.

Thanks

Mukesh Singh

kothandaraman_nagarajan
Active Contributor
0 Kudos

hi,

Sorry not connecting. I will check it tomorrow.

Former Member
0 Kudos

Hi Mukesh,

Could you post a screenshot to show your issue?

Thanks,

Gordon