Determine which Invoices are listed in OE Pending

Posted By affrench over 6 years ago

Is there a way to determine which Invoices are listed as OE Pending from a database level whether it be looking at the OEINVH or some other table as I am trying to build a Crystal Report based off these Pending Invoices.

Parents

0 Django over 6 years ago

What do you mean by pending? Waiting to do through day-end on into AR?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 affrench over 6 years ago in reply to Django

OE Pending refers to the Section in the Customer Inquiry Credit Status Tab where it shows the customers balances. OE Pending usually relates to Order Entry transactions not processed by the day end as yet so it shows as OE Pending. What I am seeking is a database identifier that shows which transactions were either not processed by the day end as yet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 affrench over 6 years ago in reply to Django

OE Pending refers to the Section in the Customer Inquiry Credit Status Tab where it shows the customers balances. OE Pending usually relates to Order Entry transactions not processed by the day end as yet so it shows as OE Pending. What I am seeking is a database identifier that shows which transactions were either not processed by the day end as yet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 49153 over 6 years ago in reply to affrench

OEINVH.INVSTATUS
1 = Document shipped not costed
2 = Document costed
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 affrench over 6 years ago in reply to 49153

Thank You. will check this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Determine which Invoices are listed in OE Pending

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING