While GL posting getting this error offset account must have the type bank for the voucher

(0) Share

Report

Posted on by Community Member

Ax 3.0 version

i have created a JV with two vendors V018742 debit and other vendor V014080 credit and setting the posting profile as 132412 -- advances for expense and offset account type selected as ledger .

while posting the same JV getting warning/error --offset account must have the type bank for the voucher

Pls let me know if there any setup required to change for vendor or jv level

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

It looks like you might be using a Vendor payment journal rather than a General journal to make your voucher. You should be able to do a vendor (debit) and vendor (credit) transaction within a regular General journal to transfer part of a vendor balance between two vendors. Vendor payment journals, on the other hand, typically must offset Bank because they are used for writing cheques.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

we had tried to created 4 liner JV from General Journal for vendor - V018742 debit and credit entry and for vendor V014080 also debit and credit entries but still same msg is showing --offset account must have the type bank for the voucher

Was this reply helpful? Yes No
Ashley O 317 on at

Like (0)

Report

I'm experiencing the same problem but my client is using AX 2012 R3

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Ashley O,

Is it right that you have a vendor account in debit and credit?

Where did you create this Transaction? (GL Journal, AP invoice Journal, etc.)?

Have you tried splitting the voucher into two lines to get it posted?

Ludwig

Was this reply helpful? Yes No
Suggested answer

Kristi Slininger 66 on at

Like (1)

Report

We need more information on your setup, since this is what is causing the issue. Somewhere you have defined that the Offset account type must be Bank.

Validate how your journal names are defined. You can define the journal name to require a specific offset account type, such as Bank.

Or if you are defining a method of payment on the transaction, you may have the method of payment defined to require Offset type of bank (see Payment controls).

Kristi

Was this reply helpful? Yes No
Zoila Goñi Vera 170 on at

Like (0)

Report

HELLO

Did you solve the problem?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Zoila Goñi Vera,

This is a very old thread.

Why don't you create a new one and provide some additional details on the problem that you have and the system that you use?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Calogero 5 on at

Like (0)

Report

Hi guys,

I had the same issue and I found out the reason. Basically in the method of payment set-up form there is a box in the payment control area that if it is active will require a bank type as offset account while you post vendor transactions even in a GL journal, in order to skip this control either you disactivate the box highlighted below or as a workaround you can post vendor transactions(in GL ) by filling the amount in the credit side and put vendor in the offset account and you will correct accouting figures.

Hope this helps

Regards

Was this reply helpful? Yes No
Suggested answer

Matloob 781 on at

Like (0)

Report

Hello,

Even i had a same issue in D365 FO on cloud and my issue resolved when i have removed method of payment from specific lines which requires bank as a mandatory offset account type.

Cheers !

Was this reply helpful? Yes No