Hi,

Now I'm facing the problem when doing the layout for profit and loss report. The calculation i'm getting wrongly. May i know how can i minus the formula Net Sales - Total COGS = Gross Profit? Because now system is plus the Net Sales + Total COGS. Please advise. Thanks.

Hi,

As per my understanding your Gross Profit value and formula is correct.
In you case Sales amount showing with negative amount (Standard Display Logic for Infor) for system it is a credit balance and COGS amount showing with positive amount for system it is a debit balance.
For Example:-
Scrap Sale = -1000 but for Finance it is a Credit balance of 1000.
COGS = 900 but for Finance it is a Debit balance of 900.
Gross Profit = Sale - COGS = Credit - Debit = 1000 - 900 = 100

I think this will help you to understand calculation under Financial Statement.