invoice eff_date

[shaarawi]

hI all

I am seacrhing in MFG/Pro in Ih_hist table for invoice post date or eff_date I can not find it. We have problem that user is creating an invoice in period and post in the previous period. if there is not filed how we can solve this issue

Regards
Senior system analyst - Reporting Team Leader

IT Department

Unilever Mashreq

+203 4194199

+203 4278168 - Ext:2122

 

[RonnyK]

You can find this date in the ar_mstr where ar_nbr = ih_inv_nbr. The field ar_eff_date is the financial date.

 

[LuisGdelC]

Now... how to avoid this?

As you mentioned, users are backdating the effective date at post time. This means the GL calendars have not been closed for SO for the previous period; that is the first thing you want to look at.

By closing the GL calendar for SO, the system will not let you post journals (therefore not create AR records) against the previous period.

 

[willy]

I think LUIS is corruct , In this problem we are not closing (GL calender )