Invoice posted

[waynelaw]

Dear All,

Wayne from Malaysia.
Just make few enquiries as below,

1) How to know which invoices had been posted, and when is the date to post it ?

2) I use Invoice Post(7.13.4) to do invoice posting to AR.


regards,
wayne

 

[sharkdim]

maybe ,after running 7.13.4 ,it can give you the report for it....

 

[anandpatwari31]

1) If invoice number appears in 7.13.2 pending invoice register with Include ready to POST flag to Yes.then invoice is still unposted.
If it appears in 7.13.7 Invoice history inquiry then it is posted invoice.

Unfortunately Mfgpro doesnot stores the posting date of invoice

 

[W.Wulmsen]

Hello Wayne,

Maybe a little bit late, but it is always possible to retrieve the date of booking.
When an invoice is posted, the data is written to ar_mstr.
Every Financial booking is traced with batches.
To retrieve the book date and the related userid, retrieve the ba_mstr.

In the ar_mstr use the field ar_batch.
Retrieve ba_mstr where ba_batch = ar_batch and ba_module = "SO".
The ba_date is ALWAYS the system date of booking.

William W