Unposted batches report

[Merle Schwickerath]

Anyone familar with a report (SmartList) that will print off all the unposted
batches? At times we have a multiple of them that I would like to review to
see what is related to the prior month or that are intercompany.

[Victoria [MVP]]

Merle,

Just to clarify what you're looking for - do you need a list of batches (one
line per batch) or a detailed list of all the transactions in a batch?
Also, which module would this be for?

My first guess is that you're looking for a detail of all the unposted GL
transactions. If that is the case, under Account Transactions, add columns
for Document Status, CorrespondingUnit and IC TRX. Document Status will be
Work for any unposted transaction. IC TRX will be Yes for any Intercompany
transaction originating in the company you're in. CorrespondingUnit will
show a value if the Intercompany transaction came from another company and
is unposted in the one you're looking at.

If you're looking for something else, please post back with more details.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
Anyone familar with a report (SmartList) that will print off all the unposted
batches? At times we have a multiple of them that I would like to review to
see what is related to the prior month or that are intercompany.

[Merle Schwickerath]

What is the difference between status of "open" & "work" for a batch? Is
there a field that also gives the batch name?

Merle

Post by Victoria [MVP]
Merle,
Just to clarify what you're looking for - do you need a list of batches (one
line per batch) or a detailed list of all the transactions in a batch?
Also, which module would this be for?
My first guess is that you're looking for a detail of all the unposted GL
transactions. If that is the case, under Account Transactions, add columns
for Document Status, CorrespondingUnit and IC TRX. Document Status will be
Work for any unposted transaction. IC TRX will be Yes for any Intercompany
transaction originating in the company you're in. CorrespondingUnit will
show a value if the Intercompany transaction came from another company and
is unposted in the one you're looking at.
If you're looking for something else, please post back with more details.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
Anyone familar with a report (SmartList) that will print off all the unposted
batches? At times we have a multiple of them that I would like to review to
see what is related to the prior month or that are intercompany.

[Frank Hamelly, MCP-GP]

Merle:

There are three TRANSACTION statuses in GP - 'Open', 'Work', and
'History'. Batches are either posted or unposted.

An example of the three statuses for a payables document would be as
follows:

1. Work - the transaction has been entered (saved) but not posted.
Some transactions can be saved individually, some can only be saved in
batches. In the case of a batch of payables transactions sitting in a
batch awaiting posting, these transactions would be in 'Work' status.
2. Open - following the same scenario, after you post the payables
transaction or batch, the transaction is in 'Open' status.
3. History - the payables transaction moves to 'History' status once
it has been paid or voided.

Yes, there is a field that identifies the Batch ID.

Hope this helps,

Frank Hamelly
MCP-GP, MCT
East Coast Dynamics
www.eastcoast-dynamics.com

[Merle Schwickerath]

I got all that information in the SmartList. Brings back information that I
was looking for except.....

I have a Intercompany batch. The batch is correct & has not been posted
yet. I run the SmartList searching only for the (1) Batch_ID, the time
frame, even the journal #. The SmartList report gives me the batch with alot
of incorrect information - account #'s are wrong. Seems to only happening
with intercompany transactions. Don't understand why.

Post by Frank Hamelly, MCP-GP
There are three TRANSACTION statuses in GP - 'Open', 'Work', and
'History'. Batches are either posted or unposted.
An example of the three statuses for a payables document would be as
1. Work - the transaction has been entered (saved) but not posted.
Some transactions can be saved individually, some can only be saved in
batches. In the case of a batch of payables transactions sitting in a
batch awaiting posting, these transactions would be in 'Work' status.
2. Open - following the same scenario, after you post the payables
transaction or batch, the transaction is in 'Open' status.
3. History - the payables transaction moves to 'History' status once
it has been paid or voided.
Yes, there is a field that identifies the Batch ID.
Hope this helps,
Frank Hamelly
MCP-GP, MCT
East Coast Dynamics
www.eastcoast-dynamics.com

[Merle Schwickerath]

I got all that information in the SmartList. Brings back information that I
was looking for except.....

I have a Intercompany batch. The batch is correct & has not been posted
yet. I run the SmartList searching only for the (1) Batch_ID, the time
frame, even the journal #. The SmartList report gives me the batch with alot
of incorrect information - account #'s are wrong. Seems to only happening
with intercompany transactions. Don't understand why.
Merle

Post by Frank Hamelly, MCP-GP
There are three TRANSACTION statuses in GP - 'Open', 'Work', and
'History'. Batches are either posted or unposted.
An example of the three statuses for a payables document would be as
1. Work - the transaction has been entered (saved) but not posted.
Some transactions can be saved individually, some can only be saved in
batches. In the case of a batch of payables transactions sitting in a
batch awaiting posting, these transactions would be in 'Work' status.
2. Open - following the same scenario, after you post the payables
transaction or batch, the transaction is in 'Open' status.
3. History - the payables transaction moves to 'History' status once
it has been paid or voided.
Yes, there is a field that identifies the Batch ID.
Hope this helps,
Frank Hamelly
MCP-GP, MCT
East Coast Dynamics
www.eastcoast-dynamics.com

[Victoria [MVP]]

Merle,

Looks like this SmartList does not work correctly for Intercompany
transactions. I am guessing what it's doing is looking at the account index
on each line, then bringing back the account with that index number from the
company you're logged into, not from the other (IC) company. You can start
a support incident with Microsoft to register this as a bug, but
realistically even if they confirm this is an issue, they may not have a
quick fix for you. If you need this quickly, you would have to either
create a custom SmartList in SmartList Builder or another report based off
the SQL data directly.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
I got all that information in the SmartList. Brings back information that I
was looking for except.....
I have a Intercompany batch. The batch is correct & has not been posted
yet. I run the SmartList searching only for the (1) Batch_ID, the time
frame, even the journal #. The SmartList report gives me the batch with alot
of incorrect information - account #'s are wrong. Seems to only happening
with intercompany transactions. Don't understand why.
Merle

Post by Frank Hamelly, MCP-GP
There are three TRANSACTION statuses in GP - 'Open', 'Work', and
'History'. Batches are either posted or unposted.
An example of the three statuses for a payables document would be as
1. Work - the transaction has been entered (saved) but not posted.
Some transactions can be saved individually, some can only be saved in
batches. In the case of a batch of payables transactions sitting in a
batch awaiting posting, these transactions would be in 'Work' status.
2. Open - following the same scenario, after you post the payables
transaction or batch, the transaction is in 'Open' status.
3. History - the payables transaction moves to 'History' status once
it has been paid or voided.
Yes, there is a field that identifies the Batch ID.
Hope this helps,
Frank Hamelly
MCP-GP, MCT
East Coast Dynamics
www.eastcoast-dynamics.com

[Myrat Jorayev]

Victoria,
I am looking for report to see all unposted batches.
Where I can create report to see all unposted batches for all modules...

Even if you can give me written SQL, it will be ok.

Regards, Myrat

Post by Merle Schwickerath
Anyone familar with a report (SmartList) that will print off all the unposted
batches? At times we have a multiple of them that I would like to review to
see what is related to the prior month or that are intercompany.

Post by Victoria [MVP]
Merle,
Just to clarify what you're looking for - do you need a list of batches (one
line per batch) or a detailed list of all the transactions in a batch?
Also, which module would this be for?
My first guess is that you're looking for a detail of all the unposted GL
transactions. If that is the case, under Account Transactions, add columns
for Document Status, CorrespondingUnit and IC TRX. Document Status will be
Work for any unposted transaction. IC TRX will be Yes for any Intercompany
transaction originating in the company you're in. CorrespondingUnit will
show a value if the Intercompany transaction came from another company and
is unposted in the one you're looking at.
If you're looking for something else, please post back with more details.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
What is the difference between status of "open" & "work" for a batch? Is
there a field that also gives the batch name?
Merle

Post by Victoria [MVP]
Merle,
Work = Unposted
Open = Posted to Open Year
History = Posted to Closed Year
You can show the Batch ID by adding the Batch Number column.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
I got all that information in the SmartList. Brings back information that I
was looking for except.....
I have a Intercompany batch. The batch is correct & has not been posted
yet. I run the SmartList searching only for the (1) Batch_ID, the time
frame, even the journal #. The SmartList report gives me the batch with alot
of incorrect information - account #'s are wrong. Seems to only happening
with intercompany transactions. Don't understand why.

Post by Merle Schwickerath
I got all that information in the SmartList. Brings back information that I
was looking for except.....
I have a Intercompany batch. The batch is correct & has not been posted
yet. I run the SmartList searching only for the (1) Batch_ID, the time
frame, even the journal #. The SmartList report gives me the batch with alot
of incorrect information - account #'s are wrong. Seems to only happening
with intercompany transactions. Don't understand why.
Merle

Post by Victoria [MVP]
Merle,
Looks like this SmartList does not work correctly for Intercompany
transactions. I am guessing what it's doing is looking at the account index
on each line, then bringing back the account with that index number from the
company you're logged into, not from the other (IC) company. You can start
a support incident with Microsoft to register this as a bug, but
realistically even if they confirm this is an issue, they may not have a
quick fix for you. If you need this quickly, you would have to either
create a custom SmartList in SmartList Builder or another report based off
the SQL data directly.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Frank Hamelly, MCP-GP
There are three TRANSACTION statuses in GP - 'Open', 'Work', and
'History'. Batches are either posted or unposted.
An example of the three statuses for a payables document would be as
1. Work - the transaction has been entered (saved) but not posted.
Some transactions can be saved individually, some can only be saved in
batches. In the case of a batch of payables transactions sitting in a
batch awaiting posting, these transactions would be in 'Work' status.
2. Open - following the same scenario, after you post the payables
transaction or batch, the transaction is in 'Open' status.
3. History - the payables transaction moves to 'History' status once
it has been paid or voided.
Yes, there is a field that identifies the Batch ID.
Hope this helps,
Frank Hamelly
MCP-GP, MCT
East Coast Dynamics
www.eastcoast-dynamics.com

[Victoria Yudin]

Merle,

Table SY00500 in each company database hold all unposted batches for the company. You might find the information on this page helpful: http://victoriayudin.com/gp-tables/companysystem-tables/.

Victoria

[Victoria [MVP]]

Merle,

Work = Unposted
Open = Posted to Open Year
History = Posted to Closed Year

You can show the Batch ID by adding the Batch Number column.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
What is the difference between status of "open" & "work" for a batch? Is
there a field that also gives the batch name?
Merle

Post by Victoria [MVP]
Merle,
Just to clarify what you're looking for - do you need a list of batches (one
line per batch) or a detailed list of all the transactions in a batch?
Also, which module would this be for?
My first guess is that you're looking for a detail of all the unposted GL
transactions. If that is the case, under Account Transactions, add columns
for Document Status, CorrespondingUnit and IC TRX. Document Status will be
Work for any unposted transaction. IC TRX will be Yes for any Intercompany
transaction originating in the company you're in. CorrespondingUnit will
show a value if the Intercompany transaction came from another company and
is unposted in the one you're looking at.
If you're looking for something else, please post back with more details.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Merle Schwickerath
Anyone familar with a report (SmartList) that will print off all the unposted
batches? At times we have a multiple of them that I would like to
review
to
see what is related to the prior month or that are intercompany.

[l***@gmail.com]

How do I run a smartlist showing an unposted batch from the Purchasing module? I want to see details like GL distribution and posting date. Thanks!