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!

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

Changing Invoice Due Date does not change A/R Ageing report 1

Status
Not open for further replies.

johnhugh

Technical User
Mar 24, 2010
702
SG
Hi,

I've done a macro which changes the due date of an AR invoice in table ARIBH and AROBL.
The due date shows correct under customer inquiry and on the A/R aging report.
However the ageing it calculates on the A/R ageing report is wrong.
My invoice is shown in the wrong ageing column.

Does anyone know on what basis the aging is calculated and what I have to change to make my invoice show up in the right column?
 
Forget about ARIBH, once it's posted, it doesn't matter. AROBL.DATEDUE and AROBS.DATEDUE should be enough.
 
Thanks tuba, AROBS seems to have done the trick.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top