Gross Profit in GP

(0) Share

Report

Posted on by Community Member

I am trying to run a gross profit report by PO in GP. We do not use Serial Numbers in GP, just model, lot numbers and quantity. My problem is the sales information does not link back to any PO information. Please advise with any help

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

kdd281 469 on at

Like (0)

Report

RE: Gross Profit in GP

You may want to consider using the Sales module since it records Cost of Goods (based on your Inventory method - FIFO etc). If your cost is fluctuating that much you won't be able nail the real cost down unless you start using the PO generator directly in the Sales module, then you can create that link on the PO side for reporting.
Suggested answer

sandipdjadhav 18,302 on at

Like (0)

Report

RE: Gross Profit in GP

Hello,

If you study IV00200 table that hold by Item--> Lot unit cost. You can use same table link with your Sales Line Item to get Selling Price and get your Profit by Sales Line Item.

Let me know how it goes.

Thanks much
Sandip
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Gross Profit in GP

You will need to commit your PO's to SOPs in order to even get close. The lot number may help as the PO lines will have lot numbers as will the SOP lines have lot numbers. You need to match up the SOP lines and UNITPRCE to the POP Unit Cost and multiply by quantities. If you commit your POs to SOPs this will be possible using the SOP60100 table( the ever popular SOP to POP table)