AX 2012 - "Account number for transaction type Vendor balance does not exist."

(0) Share

Report

Posted on by Ahmed Ahmed El-Maadawy

460

When I create a Purchase Order with a Bank as a Offset Account I get the two following errors when posting

Account number for transaction type Vendor balance does not exist
Account number for transaction type Bank does not exist.

I checked the posting profile and everything seems fine. What could be the problem?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Cristina 373 on at

Like (0)

Report

Purchase Order and Offset Account? Do you mean really Purchase Order or Invoice?

In Purchase orders you only select the item, not the Offset Account,...

Can you give me more details?

Was this reply helpful? Yes No
Ahmed Ahmed El-Maadawy 460 on at

Like (0)

Report

Excuse me, I meant Purchase Payment. When making a Vendor payment these two Warnings show

Was this reply helpful? Yes No
Cristina 373 on at

Like (0)

Report

Can you record the process with the task recorder? It will be easier to understand your problem with this document (word document).

Was this reply helpful? Yes No

Ahmed Ahmed El-Maadawy

460 on at

Like (0)

Report

Vendor Payment

Auto-generated document.

Recorded by:	ama
Recorded date:	6/19/2012
Document created:	6/19/2012
Task notes:

Vendor Payment............................................................................................................................... 1

Form name: Journal number details............................................................................................ 2

Form name: Infolog.................................................................................................................... 2

Form name: LedgerJournalTableCustPaymentPreview................................................................ 3

Form name: Payment journals.................................................................................................... 3

Form name: Journal voucher....................................................................................................... 3

Form name: Infolog.................................................................................................................... 5

Form name: Journal number details

1. Close the Journal number details form.

Form name: Infolog

2. Select the address EZZO -> Accounts payable from the Address bar by clicking the navigation path arrows.

3. Click Area Page node: Accounts payable -> Common -> Payments -> Payment journals.

Form name: LedgerJournalTableCustPaymentPreview

Form name: Payment journals

4. Click the Payment journal -> Maintain -> Edit lines button.

Form name: Journal voucher

5. Change Account from '' to 'Ezzo-000002'.

6. Change Debit from '' to '1000.00'.

7. Make sure the selection is changed in table Journal lines to:

Date	Company accounts	Account	Description	Debit	Credit	Offset account type	Offset account	Payment status
6/19/2012	ezzo	Ezzo-000002		1000.00		Ledger		None

8. Change Offset account type from 'Ledger' to 'Bank'.

9. Make sure the selection is changed in table Journal lines to:

Date	Company accounts	Account	Description	Debit	Credit	Offset account type	Offset account	Payment status
6/19/2012	ezzo	Ezzo-000002		1000.00		Bank		None

10. Change Offset account from '' to 'CIB - EUR'.

11. Click the Post -> Post menu button.

Form name: Infolog

Was this reply helpful? Yes No

Ahmed Ahmed El-Maadawy 460 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

Cristina 373 on at

Like (0)

Report

Are you posting both accounts in the same company?

Have you check the posting profile that is used in the transaction has the correct accounts? This ledger accounts are blocked to post in journals?

Was this reply helpful? Yes No
Ahmed Ahmed El-Maadawy 460 on at

Like (0)

Report

Both Accounts are in the same company

I double checked the posting profile and they have the correct accounts. How can I check if the accounts are blocked to post in journals?

Was this reply helpful? Yes No
Verified answer

Aman Kumar 100 on at

Like (0)

Report

Hi Ahmed,

Even I faced this issue and when I explored I found that the reason for this error is "Account strucutre".

In my case, I had defined one account strucutre for my company where I had applied a filter for "Main accounts". My filter only covered P&L accounts. However all the subledger accounts are of type "Balance". As system was not able to find any account structure for balance sheet account, hence it was throwing this error.

Probable solution for your problem would be to define an appropriate account structure for all the summary accounts.

Hope it helps...

Was this reply helpful? Yes No
Prateek Dagar 5 on at

Like (0)

Report

Go to GL-->Setup-->Posting--> Account for automatic Transactions--> Create New and select the posting type as ''Vendor balance''. Attach appropriate Ledger Account. I hope this will work.

Regards,

Prateek Dagar

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you try to recreate the posting profiles ? I have had a similar issue recently, and recerating the posting profiles fixed the issue.

Was this reply helpful? Yes No

Community site session details

AX 2012 - "Account number for transaction type Vendor balance does not exist."

Vendor Payment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

AX 2012 - "Account number for transaction type Vendor balance does not exist."

Vendor Payment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates