Microsoft Dynamics NAV (Archived)

item transaction

(0) Share

Report

Posted on by Community Member

am using nav2009 classic mode.how can get item transaction? include customer details and invoice no?

*This post is locked for comments

All responses (9)

Answers (1)

Suggested answer

ksundeep87 800 on at

Like (0)

Report

RE: item transaction

If you are able to access tables run,

Table No : 113 (Sales Invoice Line) filter customer no and Item no for all invoice details.

Table No : 115 (Sales Cr.Memo Line) filter customer no and Item no for all invoice details.

Table No : 6661 (Return Receipt Line) filter customer no and Item no for all return details.

Once you find the proper document NAVIGATE the Document No. and find the Applied entries.
Suggested answer

Community Member on at

Like (0)

Report

RE: item transaction

Safeek,

If you find this answer helpful, please mark this as verified.
Community Member on at

Like (0)

Report

RE: item transaction

thanks,thankyou so much
Verified answer

Community Member on at

Like (1)

Report

RE: item transaction

Hi Safeek,

Document No. would be your Sales Invoice no.. You can also refer "External document no", if you using the same during posting.

Also navigate that particular value entry and you would get all the required details.

Hope this helps.

Best Regards,

Vishal Salot

//If you find this answer helpful, please mark this as verified.
Community Member on at

Like (0)

Report

RE: item transaction

thank you vishal

this ok ,i have customer no and item no but i dont know invoice no how can get it?
Suggested answer

Community Member on at

Like (1)

Report

RE: item transaction

Hi,

You can open Value Entries Form (Form ID - 5802) and filter on that particular Item & customer (Source No. field).

Here you can find out all the transactions details about this particular customer and related item.

You can see the Posting Date, Source No. (Customer No.), Document No. (Invoice No.), Sales Amount Actual etc.

You can then navigate the related entries and find out the exact Invoicing details about the same.

Hope this helps.

Regards,

Vishal Salot
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: item transaction

It depends on how this item has been returned. One option is to post credit memo for this customer, and you will see it in the posted credit memos list. Another option is when you buy the item back from your customer at the same price you have sold it, and in this case it acts as a supplier. So, you will find it in supplier's card. Depends on your case.
Community Member on at

Like (0)

Report

RE: item transaction

ok., one customer bought one item.return back for warranty but invoice copy is missing

how can find the invoice ?
Community Member on at

Like (1)

Report

RE: item transaction

Hi

Item transactions may be viewed from the Inventory field on the item card or item ledger entries. To see the posted sales invoice you will need to view the Value Entries for your item. Easy to do. Just select any item ledger entry and pick Value Entries option from menu. Then remove filters re item ledger entry and add an item number filter. Then you can see all value entries for your selected item number.

Neil