Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

Posted on by Microsoft Employee

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

  • Suggested answer
    Matloob Profile Picture
    Matloob 781 on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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 !

  • Suggested answer
    Calogero Profile Picture
    Calogero 5 on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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

  • Zoila Goñi Vera Profile Picture
    Zoila Goñi Vera 170 on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    HELLO

    Did you solve the problem?

  • Suggested answer
    Kristi Slininger Profile Picture
    Kristi Slininger 66 on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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

  • Ashley O Profile Picture
    Ashley O 315 on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,786 on at
    RE: While GL posting getting this error offset account must have the type bank for the voucher

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans