Ledger Error submitting pay statement.

(0) Share

Report

Posted on by Community Member

After creation of the Pay statement in Payroll > Common > Pay statements > All say statements

when I Submit for payment, the system throws the following error.

"One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid. Use the Accounting distribution form or the Posting profile to update the ledger account."

and

"The state of the source document or source document line could not be updated. . The Payroll clearing account is set in the Payroll parameters and I can post the Pay statement, but when I try to submit it I get the 'accounting distribution error'.

I can post the Pay statement so i think the Payroll accounting set up is correct, I suspect that the issue is on the AP side, where/how should I check to see what ledger account is having the problem?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

DavidSturt 4 on at

Like (0)

Report

Hi Rick,

Please open the Pay Statement details form for one of the pay statements that is giving you an issue. Then on the 'Financials' tab click on the 'View Distributions'. Please verify that all earnings, benefits, tax entries and accruals have valid distributions set. The 'ledger account' from the distributions will be used to create the sub ledger journal when posting.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your reply David.

In the Earning statement on the Financial dimensions tab of the line detail there is valid financial dimension data.

Viewing the the Accounting distribution a complete expense account is present.

On the Pay statement I see the same thing.

On the Accounting distribution tab there is a complete and valid expense account for every earning code, benefit plan and the tax code on the Pay statement.

I CAN post the pay statement so the accounting is correct and balanced on the GL side, the issue I believe is on the AP side when AX tries to create the Payment journal.

Any guidance on set up or troubleshooting tips to determine the account that is invalid or missing on the AP side would be appreciated.

Thanks,

Rick

Was this reply helpful? Yes No
DavidSturt 4 on at

Like (0)

Report

Hi Rick,

Have all the steps in the Prerequisites section of this article been completed? technet.microsoft.com/.../jj677320.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi David thank you again for your reply.

Yes, this has been reviewed and all of the settings on the Payroll parameters form are filled in.

The error is being thrown from the class SourceDocumentLineStateFullyDistributed. My next step is to have one of our local devs debug this but am still open to any suggestions from you or the community.

Thanks,

Rick

Was this reply helpful? Yes No
DavidSturt 4 on at

Like (0)

Report

Hi Rick,

Do you have the financial dimensions set up on the Employee details form? If you look at the employment section under financial dimensions. Having a dev debug sounds like a good option. Let us know what you find.

Was this reply helpful? Yes No
DavidSturt 4 on at

Like (0)

Report

Hi Rick,

Did you resolve this issue?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Not yet, we cannot repro in COM. Dev is comapring the two environments. Everything points to set up, we should find out soon. I will post the solution when I find it, I know there are others in the Community who interested.

Thanks.

Was this reply helpful? Yes No
AhmadHammoud 250 on at

Like (0)

Report

Hi Rick

Did you resolve the issue ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ahmad, Here is what I had to do to resolve our issue.

1. I clicked on GL | Setup | Posting | Transaction Posting Definitions.

2. I clicked on the Bank tab and selected Payroll Disbursement

3. I created a new entry in here and added the Posting Definition for AP Pay.

Once that was done, I added a posting account for the Procurement category. The main reason for this step is that AX creates a Vendor Invoice using the Payroll Procurement Category behind the scenes. This is why we were missing an account because the Vendor Invoice process could not be finished before the payment journal is created. Here are the steps I took to add the account. The account you want to use is the Payroll Clearing account that you have set up in Payroll Parameters.

1. Click Procurement and Sourcing | Setup | Vendors | Vendor Groups.

2. Select MAG as your payroll vendor is in this vendor group.

3. Click Item Posting.

4. Select Purchase Expenditure for Expense.

5. Add a line for an Item Category and select Payroll.

6. Enter the Main Account of 2100.

7. Save and Close the form.

Finally, we needed to add the fund to the Vendor Account. I performed the following steps:

1. I clicked on AP | Commons | vendors | All Vendors.

2. I located vendor 0474 and edited the record.

3. I added fund 20 to the vendor account.

Once all this setup was completed, we were able to resolve the issue and see the payment journal generate.

Was this reply helpful? Yes No