Item purchases report

Business Central/NAV User Forum
1

Hi all

I need to have report lists purchases per item with full details :

posting date - vendor code and name - QTY. - unit cost - and value

is there any similar report??

thanks in advance for all

2

You can look at standard report Vendor/tem Purchases or Inventory - Vendor Purchases

Or you can design report from Value entry or item ledger entry.

3

Dear Amol,

thanks a lot for you kind reply ,

[:D]

Theses reports solves a part of my problem ., but I need to list all purchase invoices related to a certain item from all vendors .

4

Welcome

For list of all purchase invoices for single item

Go to Item Card–> Click on Item button–>Click on Entries–> Select Value Entries–> You will see all the entries related to that item

Filter on Item Ledger Entry type field as Purchase.

You will get your desire output.

5

thanks [:D]

6

Welcome[:)]

7

Dear Amol

I have more two questions: [:)]

1- how can I enter a purchase invoice in a currency other than LCY??

2- how to print a posted " item ledger entry"??

8

  1. In Purchase Invoice screen select desire currency code in Foreign Trade tab

  2. What do you mean by print posted item ledger entry. ? What is require to print ?

9

we use item journal to adjust inventory manually.

sometimes we need to re-print a posted item journal entry

thanks again and again

10

You can look at the Warehouse–> History–> Registers–> Item Registers

Here you can have all the entries

Just click on entry you required–> click on Register–> select Item ledger

11

I really did this , but how can I print the entry??

[:)]