News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Sales Transaction Line...

Finance | Project Operations, Human Resources, ...

Suggested answer

Sales Transaction Line Cost picked from which layer of IV10200

(0) Share

Report

Report

Posted on by sandipdjadhav

18,265

Hello Team,

Is there any way to know the Sales Line Item cost is picked from which layer from IV10200?

Any help on this is highly appreciable.

Thanks much
Sandip

Categories:

Microsoft Dynamics GP

All responses Img

All responses (2)

Answers Img

Answers (0)

sandipdjadhav 18,265 on at

Like (0)

Report

RE: Sales Transaction Line Cost picked from which layer of IV10200

Hello Joe,

Thanks so much for your reply. It is very helpful.

Thanks again.

Sandip Jadhav
Suggested answer

Joseph Markovich 3,900 on at

Like (1)

Report

RE: Sales Transaction Line Cost picked from which layer of IV10200

Hi Sandip-

It is stored in IV10201. Query that for your SOP Number -- the cost showing there is the cost from the receipt layer. SRCRCTSEQNM is the column that is the original receipt layer the line took from.

In GP, you can get to this from Inventory > Inquiry > Receipts. Look for your item number and then drill into the receipt layers. It's just not as quick as a SQL query.

I hope this helps.

Thanks.
Joe

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans