Hi, We have currently an issue with “Customer Self Billing” which causes to have differences based on, what it seems, a rounding of the price: As you can see in the image, there is a deviation based on net amount and invoiced amount. in both cases the price is per ton and the tons are 2,433. The difference is because: Invoiced Amount (matched quantity x Customer Part Price/Curr) = 2,433 x 3030 = 7371,99 Net amount (matched quantity x Calculated Net Price/Curr) = 2,433 x 3030,102 = 7372,238This difference causes that when we do the “Print Invoice” it generates an error showing an unabalanced voucher and not registering the AR postings and tax (IP2 and IP4). The real price is 3030,102 which is the price in the Customer Order. It seems that somehow, IFS takes the customer part price/curr as a rounded number based on the Customer Order line. Do you know how to avoid this? Thanks and kind regards.

Question

Self-Billed Customer Order line deviations and price differences causing unbalanced voucher

5 months ago
September 18, 2024
2 replies
31 views

E

+2

EndikaMT
Do Gooder (Customer)

Hi,

We have currently an issue with “Customer Self Billing” which causes to have differences based on, what it seems, a rounding of the price:

As you can see in the image, there is a deviation based on net amount and invoiced amount. in both cases the price is per ton and the tons are 2,433. The difference is because:

Invoiced Amount (matched quantity x Customer Part Price/Curr) = 2,433 x 3030 = 7371,99
Net amount (matched quantity x Calculated Net Price/Curr) = 2,433 x 3030,102 = 7372,238

This difference causes that when we do the “Print Invoice” it generates an error showing an unabalanced voucher and not registering the AR postings and tax (IP2 and IP4). The real price is 3030,102 which is the price in the Customer Order.

It seems that somehow, IFS takes the customer part price/curr as a rounded number based on the Customer Order line. Do you know how to avoid this?

Thanks and kind regards.

+11

Chanu_Yazi
Hero (Partner)
5 months ago
September 21, 2024

Hi @EndikaMT

I can share my general comments on your issue.

This error could be due to a mismatch in your voucher. Please check the voucher details and see if there is any difference between the IP2 and IP4 postings.

If there is, check if any values are set in the fields of your company window. These fields control the maximum acceptable difference between debit and credit amounts in the accounting/parallel currency when posting an invoice.

Also, make sure IP31 Posting is defined in the 'Posting Control' window for customer invoices. This allows the system to post any small differences when creating the voucher.

If the error still occurs, I think it may need a deeper investigation and analysis.

Further, you might have to report this to IFS, as this type of error can happen for different reasons. Some of these reasons, including bugs, have already been addressed by the IFS R&D team.

Regards,

Chanuka

https://www.linkedin.com/in/chanuka-doluweera-7b7619159/

E

+2

EndikaMT
Do Gooder (Customer)
5 months ago
September 23, 2024

Hi,

Thanks your reply. In this case is not related to a currency mismatch. In the past I used that option you mentioned for vouchers with currency discrepancies but in this case is caused because self-billed process, in one case and I do not know why, rounds the price without decimals.

Kind regards.

Self-Billed Customer Order line deviations and price differences causing unbalanced voucher

Reply

Cookie policy

Cookie settings

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings