GP Vendors Break Up - Open Entries Only

[SARIESAREER]

Hi,

Can anyone let me know that how can i get vendors open entries break up?

thanks,

 

[VictoriaYudin]

I am not sure I understand what you're asking - can you please give a little more explanation for what you're looking to do?

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[SARIESAREER]

I need to have a list of all vendors open entries only with description, document numbers and balances eaither by report or smartlist options and then want to export to excel sheet.

 

[VictoriaYudin]

You can get this in SmartList - under Payables Transactions. For balance use the Current Trx Amount column, for description add Transaction Description. Then search on transactions where the Current Trx Amount > 0.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[VictoriaYudin]

Forgot to add - you also want to add a column for Voided and a search restriction for Voided = No.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[SARIESAREER]

This didn't worked.

I need the following criteria to be used:

i) Origin=OPEN
ii) Document Number of each open transaction
iii) Transaction Description for each transaction
iv) Balance of each open transaction
v) Period from 1st/Jan-2008 upto 31/Dec/2008

 

[VictoriaYudin]

i) OPEN in payables is exactly the same thing as Current Trx Amount > 0 and Document Status = Posted. So add a search criteria for Document Status = Posted.
ii) use column Document Number
iii)use column Transaction Description
iv) use Current Trx Amount
v) If you're looking to use the transaction (subledger) date use the Document Date column and add a search filter for Document Date is between (add your dates). If you need to use the GL posting date, then instead of Document Date use the Posting Date column.

Please post back if you need additional help on this.



Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[SARIESAREER]

One question more

Now i can get the required records for mentioned criteria, but only for invoices. I mean i can see only invoices which are open, and i need to see open payments and credit memos as well. Plz guide.

 

[VictoriaYudin]

If there were any unapplied credit memos or invoices you would see them here. Unless you are filtering by Document Type, you will get ALL payables transactions here.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[SARIESAREER]

I find the solution.

Thanks alot,