Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

First Tab (Physical Results)

 

Field NameDescription

Transaction type

Name of the transaction

revenue items are placed on top

expense below revenue items  

Description

Show the PO/SO number to which the revenue /expense

items are allocated

Doc No/ Tracking NoBill/Invoice number  
DateDate of bill / invoice
Posted

If bill/ invoice  has been posted or not . If posted Y is populated against that

expense

Allocated (unit)Qty allocated to the expense  
Booked (unit) Invoice Quantity
Price (unit)Price associated with the expense 
Currency 
Transaction value

For actual transactions - Value of the bill/ invoice

For forecasts- Cost projected X allocated qty  

FXWork in progress 
Forecast (USD)

Transaction value X FX

Currently the P&L will run in USD . so any expense recorded in non USD will need

a FX to convert the same into USD. 

Accounting (USD)Transaction value X FX as entered in the bill /invoice   
DifferenceDifference between forecast and Accounting column  



Second Tab (Physical/ Futures Results)

...