cancel
Showing results for 
Search instead for 
Did you mean: 

Different Balance Due and Cumulative Balance

Former Member
0 Kudos

Hi Experts,

My Client, SBO 8.8 PL17, are experiencing an issue where the balances differ from the balance due screen and the cumulative balance.

There are 2 closed invoice showing in the cumulative balance window as well as on Ageing report. These 2 invoices was closed with Credit Notes, both are linked to the target credit, on the actual invoice it shows as closed, the applied transactions clearly states that the doc is closed. In the DB, the INV1 lines for the invoice is also closed.

For some reason it just doesn't want to pick up that the invoice is linked to the credit.. The credit is not displaying though.

I have have read through notes but none of them have the same issue as this, they are all related to partial payments, which is not the case here.

If anyone have any suggestions, please let me know.

Kind Regards,

Wynand.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI,

it might be due to the user has change the item on the credit document after copy from the invoice because in this case linking in between these two documents get break. so please check that credit is made properly or not. or may be after copying the invoice to credit user has delete the item and then filled the item manually on the credit document.

Thanks

Honey

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Kindly check the following query whether the same gives any result :


select * from OINV t0 inner join JDT1 t1 on t0.transid=t1.transid and t1.account<>t1.shortname
where t0.docstatus='C' and (t1.BalDueDeb+t1.BalDueCred)<>0

Also, check the INV6 table and the values displayed therein for the paidtodate and paid fields.

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Hi Wynand,

Welcome you back to post on the forum. Your 1st posting was a year ago. Please close it.

For this question, it could be by a bug. Can you reproduce it in test environment?

Thanks,

Gordon