Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Customer Statement 1

Status
Not open for further replies.
erprider

erprider

Technical User
Jul 31, 2008
234
OM
Hi,

I would like to reprocess the complete AR customer statement starting from 1st January. Now when I run the customer statement it is giving me the opening and closing amount but no transactions. Moreover would like to know if we have processed the statement and have okayed the same, after sometime we realize that there were some more entries to be posted to that customer for that period, we post the same and then how do we generate a new customer statement incorporating the changes.



Thanks
 
Sort by date Sort by votes
In ARCUS, you'll need to reset DATELASTST, AMTLASTSTT, AMTLASTSTH, and if balance forward customers, DTBEGBALFW, AMTBALFWDT, and AMTBALFWDH.

Then AROBP.DATELSTSTM, too.
 
Upvote 0 Downvote
Thanks for the reply!
You mean to reset in the backend table? Will you please tell me step by step?
 
Upvote 0 Downvote
Open those tables in a database editor, and change the dates and amounts to what you want them to be.
 
Upvote 0 Downvote
AR Customer Statement -ARSTMT10.rpt has tables

1.ARSTCUS
2.ARSTNAT
3.ARSTOBL
4.ARSTOBP
5.ARSTRUN
6.CSCCD

but you said to reset the field in ARCUS table.
 
Upvote 0 Downvote
Yes, I know exactly what I said. You have to generate new statements.
 
Upvote 0 Downvote
so i have to reset in the ARCUS table isnt it?
 
Upvote 0 Downvote
I Update the table but no changes happened in the table
UPDATE ARCUS
SET DTBEGBALFW='20090101'
WHERE idcust= 'ia0008'



UPDATE AROBP
SET DATELSTSTM='20090101'
WHERE idcust= 'ia0008'
 
Upvote 0 Downvote
The AROBL.DATELSTSTM must be set to 0 for a transaction to appear on the statement. Once you approve the statement run this field value is updated with your statement's run date. I would expect AROBP.DATELSTSTM has the same requirement.
 
Upvote 0 Downvote
Thank you very DjangMan & tuba2007 it has fixed i reset as 0 in AROBL.DATELSTSTM
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vbdbcoder
  • Locked
  • Question
"Ship All" function does not work for 1 customer
Replies
2
Views
306
vbdbcoder
vbdbcoder
Sage300
  • Locked
  • Question
Customer "price list" is not defaulting in the customer tab in order entry
Replies
1
Views
195
ettienne
ettienne
rerb
  • Locked
  • Question
Initializing FR Error (30): Fail in starting Statement Designer
Replies
1
Views
115
DjangMan
DjangMan
ravazz
  • Locked
  • Question
Sage 300 Freeze during customer statement
Replies
2
Views
73
2ManyHats
2ManyHats
vbdbcoder
  • Locked
  • Question
Where to find AR customer's credit availble value like in AR customer inquiry screen ?
Replies
3
Views
64
Jay Converse
Jay Converse

Part and Inventory Search

Sponsor

Back
Top