Finance | Project Operations, Human Resources, ...

Error when invoicing Project on-account deduction

(0) Share

Report

Posted on by angelv

107

Hi,

Im getting the error " the transaction on voucher do not balance as per date. (accounting currency, reporting currency:) when trying to post the project invoice proposal with an on-account deduction line. Other transaction types i can post aside from this.

Ledger posting setup is fine as all has set accounts which are active in the structure. Customer summary account is present and posting profile is set in parameters. Automatic account for penny difference is also set.

Not sure what else i am missing to solve the error. PLease help. Thank you.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Gunjan Bhattachayya 35,429 on at

Like (0)

Report
Copy link

Link copied!

Hi angelv,

Are you trying to post the on-account deduction line only or do you have any other transactions chosen as well? Could you please let us know the version of AX you are using as well?

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

Like (0)

Report
Copy link

Link copied!

Hi angelv,

How do you treat the prepayments? Are you posting them on P&L or BS accounts?

This can be configured in the project group settings and depending on this setup different sections of your project posting matrix might be used.

Can you also let us know how you setup the on-account transaction and how you plan to deduct it?

There are multiple ways how this can be achieved and I wonder, which one you selected.

Would be great if you could share some screenprints.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
angelv 107 on at

Like (0)

Report
Copy link

Link copied!

Hi gunjan,

we are using D365 and trying to apply the deduction to a fee which is same amount as the deduction.

I tried to remove the on-account if invoice will proceed and it got posted. Always getting error when im adding the on-account deduction in the invoice.

Was this reply helpful? Yes No
angelv 107 on at

Like (0)

Report
Copy link

Link copied!

Hi ludwig!

We post prepayments in a BS account. The deduction line is auto-generated from the the prepayment line.

Im trying to apply the deduction line to a fee in the project invoice proposal. For the past months we are able to post same transactions but not sure why for this particular transaction it is giving error.

Below is its project group setup:

Also, the transaction is in GBP currency and entity accounting currency is in USD.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello angelv,

For T&M projects you can setup the on accounts as follows:

Please note that I have two lines !

When you create the invoice proposal you will see the on account and the deduction.

Note: In my case this does not make much sense because I invoice and deduct the amounts at the same time but by entering different date values you can achieve that out of the box.

Best regards,

Ludwig

P.S. Please don't accrue revenue for fees. This makes usually no sense.

Was this reply helpful? Yes No