Posting key validation with document type

[Former Member]

Dear Team,

We would like to restrict Vendor or Customer manual posting with specific FI document type. System should not accept only GL posting for such document type. e.g. We have decided 'KR' document type for manual vendor invoice booking but we want to restrict it  should accept only vendor posting along with GL credit (50) or GL debit (40). We make 0002 line item validation for set of posting keys 31, 22, 40 & 50 but how we can restrict for this document system should not accept only 40 & 50 posting keys? I tried with completion document but it is not accepting segment level (line item) level fields in validation.

Through user exit in validation it is possible but is there any standard way to achieve this?

Thanks & Regards / Avinash

[Former Member]

Hi Aviya,

In OBA7 please deselect "Assets", "Material" and "GL Account: check boxes from  Account Type Allowed frame. Also Select Cust/Vend check in Control Data frame.

Please advise what is the key you want to have debit posting if you do not want 40. Also in case of reversal what is the Credit key if 50 is not required.

Please confirm.

Thanks

Naseem

[Former Member]

Hi Naseem,

Thanks for your reply. We want to use offset posting key for above case would be 40 or some times 50 also in special case. Moreover we have separate document type for reversal. In OBA7 setting vendor & GL account types are selected. We have separate document type for GL posting 'SA' but want to restrict for 'KR' should be use for vendor & GL posting not for GL only like SA.

Regards / Avinash

[Former Member]

Hi Ayiva,

Let me revisit your requirement... you want to use manual vendor invoice through FB60 in FI? if this is the case then selecting vendor and GL account types in document type KR would restrict the data to go in predefined keys i.e. debit line item will use posting key 40 and credit line item will use posting key 31. Posting key 50 is for credit entry for GL Account Type (plz check OB41 for full description) and you may not be able to use it for debit line item. What special circumstances it can be use as debit... I am not sure...

Please confirm if you restricting users to use FB60 only for manual vendor invoice. or F-43 can also be used for this purpose.

Thanks

Naseem

[Former Member]

Hi Naseem,

Our requirement is for 'KR' document type system should accept only 31, 34, 40 & 50 posting keys. However Vendor credit posting key (31 & 34) should be mandatory for KR document type irrespective of transaction, it may be FB60, F-43 or even F-02 with KR document type. Main object is user should use SA document type for GL posting not KR. We make validation for KR document type system will allow only 31, 34, 40 & 50 posting keys, after validation it is observed that user are posting only 40 & 50 for KR document type. Now we want to restrict it for KR doc type.

Regards / Avinash

[ajaycwa1981]

Hi

You should not have such validation ideally, it is a matter of discipline

However, solution is as below

1. Uncheck customers n vendors in SA doc type

2. Write a document level validation for KR that if Account Type is not equal to K, system should throw error

If Need be, use user exit with in validation.

Ajay M

[Former Member]

Hi Ajay,

Thanks for your confirmation.

Option 1 we have done but second will not work. So I think best option would be use user exit on completion document.

Regards / Avinash

[ajaycwa1981]

That's right buddy. It will work

Ajay M

[ajaycwa1981]

Hi Avinash

Did it work??

Br. Ajay M