Finance | Project Operations, Human Resources, ...

Unable to post vendor and customer journals

(1) Share

Report

Posted on by nk156

178

Hi All,

I am unable to post vendor or customer transactions and have gone through multiple posts informing different configurations. I have verified the configurations according to these posts too, however I am unable to know the cause for the below error during journal posting. Financial dimensions are setup on both customer and vendor

Account structure configuration - Activated

Vendor Payment Journal posting Log

Error Message while posting vendor payment journal

Customer Payment Journal posting Log

Error Message while posting customer payment journal

Immediate support is much appreciated.

Thank you,

Kind Regards,

Neeta

All responses (13)

Answers (0)

André Arnaud de Cal... 291,791 Super User 2024 Season 2 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Neeta,

Unfortunately, I can't suggest more than verifying the account structure settings. For sure there should be a difference in the setup somewhere.
nk156 178 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Andre,

Thank you for the reply. I have checked every parameter on the account structure, everything is mirrored. There is no difference. The mysterious factor I see is, how and from where (which form or configuration) is the system picking the ledger account details for the Bank. If it is picking for the Bank, then why isn't it triggering to pick for the vendor or customer. Please can you advise what this triggering factor could be.

Appreciate any support to resolve this.

Thank you,

Kind Regards,

Neeta
André Arnaud de Cal... 291,791 Super User 2024 Season 2 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Neeta,

If it is working in another environment, you would need to verify possible setup differences. Have you checked if the account structure setup for this environment is correct where the ledger account is included and activated?
nk156 178 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Saurabh,

Based on your suggestions, when I printed the payment journal, I noticed that the Ledger account against the Vendor Account type is missing. Please advise what is missing that is not triggering this ledger account.

The related journal line of this record is as below,

Please advise.

Thank you,

Kind Regards,

Neeta
Suggested answer

saurabh bharti 15,029 Super User 2024 Season 2 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi,

Few observations:

1. You have multiple posting profiles for each customer group, is this intentional? if yes are you selecting right posting profile on journal line where selected customer or vendor group belongs?

2. You group financial dimension is mandatory on journal line , which you should select by clicking on financial diemnsion button above journal line for vendor or customer.

Can you share screenshots of following:

1. Showing full journal line accocunt and offset account with selected financial diensions

2. Posting profile selected on journal line

3. Journal print
nk156 178 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Andre,

I have verified Frank's suggestion, it's all in place but doesn't resolve the issue.

I have exact setup for a different environment for a different project. The customer and vendor journals get posted on that environment. This is a new environment; I have manually set it for all the records except main account records which I had imported using template. There hasn't been any journal posted on this new journal as I get these errors for every posting.

Thanks,

Regards,

Neeta
nk156 178 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Frank Hamelly,

As advised, I have verified the Account and Offset account dimensions, they are all in place for both customer and vendor journal lines.

Thanks,

Regards,

Neeta
nk156 178 on at

Like (1)

Report

Unable to post vendor and customer journals

Hi Prem Kumar Bachu,

Group is one of the financial dimensions. I have done both, reactivated the account structure and also tried to split the lines for Group. It hasnt, helped.

Regards,

Neeta
André Arnaud de Cal... 291,791 Super User 2024 Season 2 on at

Like (0)

Report

Unable to post vendor and customer journals

Hi Neeta,

Firstly, check the suggestion from Frank. If this is not solving your issue, I have some questions.

Did it work before in this environment? If so, do you know if something got changed (customization, setup data, ...)? If this is a new legal entity or environment where it didn't work before, can you tell how the main accounts, dimensions, and account structures were created? Manually or via data import or another copy job?
Suggested answer

Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on at

Like (0)

Report

Unable to post vendor and customer journals

The error message seems to point to a missing dimension value as required for the Group dimension. Please check dimensions on Account and Offset account in the transactions.