Finance | Project Operations, Human Resources, ...

Print Billing Statement

(0) Share

Report

Posted on by AediX

When printing billing statements, how can we get the breakdown of the previous balances to add on the current charges as VATable/NON-VATable Sales. Currently we can only show the correct breakdown of the previous balances if we assume it to be all VATable but if the previous balance is a combination of VATable and NON-VATable Sales, the computation of breakdown on the current billing is incorrect.

These are the sample cases we need to assume when computing for the breakdown.

1. Previous balance is an overpayment from VAT and NON-VAT transactions.

2. Previous balance is an underpayment from VAT and NON-VAT transactions.

3. Previous balance is from a two month period, no transactions were made for the past two months.

4. Previous balance is from another account number (a transfer was made).

Appreciate your help.

Thank you in advance.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Ai.D,

Can you explain what a billing statement is? Is this an invoice document or something else, such as customized report?

From where in AX do you open and run this statement?

Can you possibly add some screenprints?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
AediX 20 on at

Like (0)

Report

Hi Ludwig,

Yes, a billing statement is the same as an invoice.

Here is the path where the report is located: "Company/Accounts receivable/Periodic/Collections/Print/Archive Billing Statements"

Please see sample invoices below. The problem lies on the breakdown of the second invoice.

First Invoice

Second Invoice

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Ai.D.,

Many thanks for sharing this information.

The billing statement seems to be part of a system modification or a 3rd party solution that was implemented.

Can you talk to your system admins or to the developers who created this for some help?

That does not seem to be a standard feature.

Many thanks,

Ludwig

Was this reply helpful? Yes No
AediX 20 on at

Like (0)

Report

Hi Ludwig,

Yes, I already coordinated this with our outsourced AX Developer and he is currently having a hard time correcting the balances as he can't determine as to what table he can get a balance from previous billing that can be identified as to VAT or Non-VAT transaction.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Ai.D,

I think having the developer taking a look is the only chance you have because this report is a customized one and only the one who created it knows how it was designed and what might be missing.

Best regards,

Ludwig

Was this reply helpful? Yes No
AediX 20 on at

Like (0)

Report

Hi Ludwig,

Thank you for your help!

Was this reply helpful? Yes No