Accrued Revenue by Project Report - Revision history

Amohammad at 16:41, 8 April 2024

2024-04-08T16:41:50Z

Amohammad at 16:41, 8 April 2024

2024-04-08T16:41:41Z

Amohammad at 19:48, 27 March 2024

2024-03-27T19:48:54Z

Amohammad: Created page with "NOTOC ===Default Menu Location=== Reports >> Project >> Accrued Revenue by Project [http://abiscorp.com/adjwiki/GetFile.aspx?File=Project Management\accrbyjob.jpg|Click..."

2024-03-27T19:33:44Z

Created page with "__NOTOC__ ===Default Menu Location=== Reports >> Project >> Accrued Revenue by Project [http://abiscorp.com/adjwiki/GetFile.aspx?File=Project Management\accrbyjob.jpg|Click..."

New page

__NOTOC__
===Default Menu Location===

Reports >> Project >> Accrued Revenue by Project

[http://abiscorp.com/adjwiki/GetFile.aspx?File=Project Management\accrbyjob.jpg|Click here for a screenshot.]

===General Description===

The Accrued Revenue by Project report is a custom report written for a customer in the Metal Building Industry.

The special/custom requirements are listed below:

* The Project must be incomplete or completed within the last 90 days.

* The Sales Total (sototal) field on the report is limited to Sales Order line items with an item code of BUILDING, CHANGEORDER, CL, or STHR on Sales Order Types B, R, or S.

* The Invoice Total (invtotal) field on the report is limited to Invoice line items with an item code of BUILDING, CHANGEORDER, CL, or STHR.

===Report Filters===

'''Production Start/End Date''': This is the [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Project%20Management\accrbyjob_proddate.jpg|Production Date on the Project Control screen].

'''Proj Type''': The Project Type. Not selecting any types will ignore the filter.

'''Proj Status''': The Project Status. Leave this field blank to view all project statuses in the given date range.

===Standard Report Fields===

'''Project#''': The Project ID.

'''Customer''': The default customer on the Project.

'''Proj Type''': The Project Type.

'''Proj Status''': The Project Status.

'''Accrual Amt''': The [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Project%20Management\accrbyjob_accramt.jpg|amount accrued on the Project]
.

'''Sales Amt''': The extended sales total of Sales Order line items with an item code of BUILDING, CHANGEORDER, CL, or STHR on Sales Order Types B, R, or S.

'''KIPS''': The total KIPS (1000 lbs) of Sales Order line items with an item code of BUILDING, CHANGEORDER, CL, or STHR on Sales Order Types B, R, or S.

'''Linked Inv#''': An invoice number that is linked to the Project.

'''Date''': The date of the invoice.

'''Net InvAmt''': The extended sales total of Invoice line items with an item code of BUILDING, CHANGEORDER, CL, or STHR.

===Additional Report Fields for Customization===

'''frtamt''' : The extended sales total of Sales Order freight lines.

'''whsename''' : The name of the Project Warehouse.

@@ Line 3: / Line 3: @@
 ===Default Menu Location===
-Reports >> Project Managemet >> Accrued Revenue by Project
+Reports >> Project Management >> Accrued Revenue by Project
 [[File:Accrued_Revenue.png]]

@@ Line 1: / Line 1: @@
 __NOTOC__
 ===Default Menu Location===
-Reports >> Project Management >> Accrued Revenue by Project
+Reports >> Project Managemet >> Accrued Revenue by Project
 [[File:Accrued_Revenue.png]]

@@ Line 2: / Line 2: @@
 ===Default Menu Location===
-Reports >> Project >> Accrued Revenue by Project
+Reports >> Project Management >> Accrued Revenue by Project
-[http://abiscorp.com/adjwiki/GetFile.aspx?File=Project Management\accrbyjob.jpg|Click here for a screenshot.]
+[[File:Accrued_Revenue.png]]
 ===General Description===
@@ Line 17: / Line 17: @@
 * The Invoice Total (invtotal) field on the report is limited to Invoice line items with an item code of BUILDING, CHANGEORDER, CL, or STHR.
 ===Report Filters===
-'''Production Start/End Date''':  This is the [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Project%20Management\accrbyjob_proddate.jpg|Production Date on the Project Control screen].
+'''Production Start/End Date''':  This is the Project start date and Project end date.
 '''Proj Type''':  The Project Type.  Not selecting any types will ignore the filter.
@@ Line 37: / Line 38: @@
 '''Proj Status''':  The Project Status.
-'''Accrual Amt''':  The [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Project%20Management\accrbyjob_accramt.jpg|amount accrued on the Project]
+'''Accrual Amt''':  The amount accrued on the Project
 '''Sales Amt''':  The extended sales total of Sales Order line items with an item code of BUILDING, CHANGEORDER, CL, or STHR on Sales Order Types B, R, or S.
@@ Line 49: / Line 49: @@
 '''Net InvAmt''':  The extended sales total of Invoice line items with an item code of BUILDING, CHANGEORDER, CL, or STHR.
 ===Additional Report Fields for Customization===
@@ Line 55: / Line 56: @@
 '''whsename''' : The name of the Project Warehouse.

Accrued Revenue by Project Report - Revision history

Amohammad at 16:41, 8 April 2024

Amohammad at 16:41, 8 April 2024

Amohammad at 19:48, 27 March 2024

Amohammad: Created page with "__NOTOC__ ===Default Menu Location=== Reports >> Project >> Accrued Revenue by Project [http://abiscorp.com/adjwiki/GetFile.aspx?File=Project Management\accrbyjob.jpg|Click..."

Amohammad: Created page with "NOTOC ===Default Menu Location=== Reports >> Project >> Accrued Revenue by Project [http://abiscorp.com/adjwiki/GetFile.aspx?File=Project Management\accrbyjob.jpg|Click..."