Announcements
325
HI Experts,
While printing statements, document which has zero open balance is displayed, i checked in backend, GP displaying zero since the open balance of document is in decimals E.g 0.00002 . Kindly suggest me a solution to fix this issue..
*This post is locked for comments
Suresh,
Wait... 1400 records for each of 1400 customers?! That's, like, almost 2 million records! That can't be right, can it? You meant one record for each of 1400 customers, yes?
Are you saying that the payments and invoices themselves were fractional-cent amounts? I mean, the amounts showing up on your statements were not fractional-cent balances; but that individual transactions were tiny fractional-cent amounts?
In our case, an external program that integrated accounts receivable batches into GP wasn't rounding calculated amounts properly, resulting in transactions that included fractional cents.
You're right that the method we used was OK for a hundred customers or so. 1400 would have presented a challenge. I suppose that I might have tried creating an Excel workbook with enough information to create a batch of debits/credits and then integrated it into GP instead of having to enter them all manually.
But deleting 1400 records? Are you talking about deleting a batch in GP? If not, then you very likely will have trouble down the road since GP spreads the storage of data over so many tables. Deleting records from just one table ain't gonna be enough! I can't tell you the number of times I've seen GP experts advise against direct manipulation of the back-end database.
I would most certainly run Check Links and Reconcile just to see the extent of the effect of deleting all those records.
Sincerely,
Steve Erbach
WOW Logistics Company
Appleton, WI
Thanks for helping me out steve. I will try your method!
Dear All,
I too had faced such a situation previously, where there were 3rd and 4th decimal place value (0.00025, 0.001, 0.00056, etc) for Payments and Invoices which were appearing in Statements but no relevant to the Finance Users. Mr. Bricks and Mr. Erbach has provided an excellent fix., but this fix can be used if the records are in 10s or 20s or even 100s in number. My situation I had around 1400 records, 1 record for 1 customer. I have taken a backup of the records and deleted the 1400 records from the table. Still I don't know whether that is a correct fix or will that cause any issue in the future. But this fix worked and Finance Users have not complained any issues so far. Mr. Bricks and Mr. Erbach, can you please share some thoughts or advice in my approach.
Hasib,
Mr. Bricks has the right approach, I think. The only difficulty is in actually typing in such a small value in GP.
We had a situation a couple years ago where fractional cent amounts were introduced into our Accounts Receivable from one of our external processes. We got rid of them by creating 1-cent invoices or 1-cent credit memos for each of the documents that had fractional cent balances.
Then, in the SQL backend, I changed the 1-cent amounts to the proper fractional cent offset amounts. Then we could post the fractional-cent invoices and credit memos.
I wrote about it here (Part One) and here (Part Deux).
Sincerely,
Steve Erbach
WOW Logistics Company
Appleton, WI
Hi Hasib
If you have any balance remaining, the invoice will still show as outstanding.
These small residual balances are most likely the result of currency rounding.
You will either need to create a Debit Note or a Credit Note depending on what the balance is, and apply it against the invoice with the small amount to zero this out.
Once you have the invoice at $0.00 it should not print.
You may also want to check your selection criteria for statements to ensure that you are not printing statements for Zero Balance Due
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
