Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

(0) Share

Report

Posted on by Community Member

Which report would I use to get results that include purchases by account numbers (financial) but also show each invoice (purchasing)? Here is a modified result from that report:

Loc	Code	GP GL	Inv Date	Invoice #	Vendor	Amt
71	7570	01-80-71-7570	03/31/13		Batesville Casket Co Inc	39.50
72	7570	01-80-72-7570	01/28/13	72-41457	Modern Press	342.47
72	7570	01-80-72-7570	03/31/13		Batesville Casket Co Inc	79.00
73	7570	01-80-73-7570	03/31/13		Batesville Casket Co Inc	26.34
74	7570	01-80-74-7570	02/11/13	82-8300043236	Fedex	99.40
74	7570	01-80-74-7570	03/11/13	74-20715	Belmont Business Systems	250.12
74	7570	01-80-74-7570	03/11/13	74-20714	Belmont Business Systems	325.70
74	7570	01-80-74-7570	03/31/13		Batesville Casket Co Inc	188.00

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

To be more specific, you want each purchasing document (Shipment) along with the purchasing GL account. This is to be linked with all the Invoices matched for this shipment.

Is that what you are looking for specifically ?

What are these fields (Loc and Code) ? Are the the location number and shipment number ?

Your feedback is highly appreciated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am afraid that I am not wording this correctly, but we only use the purchasing side to enter AP invoices (no POs or anything else). The reports I can find that show the purchasing GL code are all on the Financial side and only show monthly amounts, not each entry and the reports that I can find on the Purchasing side don't show the purchasing GL accounts.

The location and code columns I think were added by us. Our accountant is no longer with us and I just cannot figure out which report she was using.

Thanks for any help you can offer.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

In case you want a report that is similar to the template provided above, can you please provide us with the description of the GL Accounts above.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sure!

All of our accounts start with 01-

the next segment shows which company (10,80,30,26,37,91)

The next segment shows which location (71,72,73)

The final segment is the account code (7560=Office Supplies; 7570= Sales support)

Was this reply helpful? Yes No
Steve Baldasti 325 on at

Like (0)

Report

Did you try SmartList?

Microsoft Dynamics

SmartList

Purchasing

Payables Transactions

You'll have to work with the setup based on your system but this is a quick way to get a list

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have tried Smart List, but I can't find the GL code column. The Payables Transactions list just shows each invoice entry without breaking it down by GL code. That is why I think that I may need a Financial report/smart list.

Thanks!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Smart List Option

The Payable Transactions Smart list shows all the payable transactions including the following types (Invoice, Finance Charge, Misc Charge, Return and Credit Memo). By default, the smart list shows basic columns, you could add the associated GL Accounts from the "Columns Button", add the corresponding "Amount" fields to retrieve this piece of information.

For drill down capabilities (In order to dig for further details for a specific transaction), you could simply double click on the transaction and then go to "Distribution" in order to check the GL entries made by the selected transaction.

For customized Payable Transaction Views, you could check Ms. Victoria Yudin blog as she has provided several useful customized payable views on the link below;

Payable SQL Views

Hope this helps,

Was this reply helpful? Yes No
Steve Baldasti 325 on at

Like (0)

Report

Ok try this - open SL, when you open Payables Transactions, the window opens. Click on Columns, a window opens with the preset columns. You want to add a column, See the button ADD, click it. All the Columns open.

Find Purchases Account No. Click it. Now it's part of the sort. Go to Search to fine tune your search, say by Vendor ( your not looking through all the Vendors) or Date or Acct. You get the list you can send to Excel or Word. You like what you see then you can save by going to Favorites

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The Purchases Account No isn't an option for me in the Payables smart list columns.

Was this reply helpful? Yes No
Steve Baldasti 325 on at

Like (0)

Report

It maybe already be part of your Column list? If a column isn't on the listing then it's part of the search. That's my experience.

Was this reply helpful? Yes No