Is there any other way besides looking at the ARUNPSTH table to identify unposted AR Transactions? Is it possible for transactions to disappear from the ARUNPSTH table without a post being done?

Identifying Unposted AR Transactions.

Posted By affrench over 6 years ago

Is there any other way besides looking at the ARUNPSTH table to identify unposted AR Transactions?
Is it possible for transactions to disappear from the ARUNPSTH table without a post being done?

0 Jay Converse Acumen over 6 years ago

I think this post belongs in the Sage 300 CRE forum.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 affrench over 6 years ago in reply to Jay Converse Acumen

Im using Sage 300 ERP 2016 not CRE
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Django over 6 years ago in reply to affrench

I don't think I've ever written a report off of those tables. Typically, if I want a report of unposted transactions, I report off of the batch tables: ARIBC, ARBTA, etc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 affrench over 6 years ago in reply to Django

OH oh okay, would it in turn give the AR Pending transactions because that is my aim to get the current AR Pending transactions
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Django over 6 years ago in reply to affrench

If you're looking for unposted receipts, then yes. If you're looking for OE transactions waiting to go to AR, then no (because they aren't in AR yet. :) )
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 6 years ago in reply to affrench

ARIBH
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 6 years ago in reply to affrench

Those must be temporary tables, you can't count on them having any records.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 affrench over 6 years ago in reply to Jay Converse Acumen

Okay is there any particular identifiers? Or I would just have to use the batches that arent posted as the filter?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Identifying Unposted AR Transactions.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING