The AGRIS 18.1.0 release has added:

AGS-3650:  New Per-Unit Retains Report (Gross, Value, Net) with ability to automatically post amounts as Patronage Transactions

With this enhancement you can:

• Simplify the process of reporting per-unit retain amounts to the IRS. 
• Improve the accuracy of the value based per-unit retain amounts for reporting to the IRS. 
• Reduce time and effort to use and post desired Per-Unit Retain Allocations based on the desired method (Gross, Value, Net).

Navigation:  PAT > Report Manager > Advanced Reports > 1) Print Standard Reports

A.  The Per-Unit Retain Allocation Report

Selection screen:

• These are the default settings for the report.
• The Yes / No flags allow you to choose what settlement types to include or exclude in the report.

Report sample:

• Shaded rows represent the total of the Delivery Sheets for that particular settlement. 
• "Sheet Purged" means that the underlying Delivery Sheet was purged.  Thus the Per-Unit Retain Allocation amounts for all three methods will be "Net" settlement.
• The totals at the bottom show totals for the different settlement types selected on the report based on the Per-Unit Retail Allocation method (i.e., Gross, Value, Net). "N/A" appears when the settlement type flag is set to "N".  The sum of each settlement column by Per-Unit Retain Allocation method totals the respective column total in the "Total Patrons" area.  
• The report shows the amounts for all three methods in the right columns.

Post? 

N = This allows you to run the report.  Once you've run and validated the report, choosing one the following will actually post the Per-Unit Retain Allocations as Patronage Transactions for 1099 reporting.

1=Gross:  The Per-Unit Retain Allocation is based on Quantity * Price. 

2=Value:  The Per-Unit Retain Allocation based on Quantity * Price - Value Discounts.

3=Net:  The Per-Unit Retain Allocation based on check amount or Quantity * Price - All Discounts.

While the report shows the amounts for all three methods in the right columns, the method selected for the Post displays:

• On the title of the report.  In this sample, it is "Per-Unit Retain Allcoation Report (Posted Based On Value)".
• As bold in the applicable "-----Per-Unit Retain Allocation-----" column on the right.  In this sample it is "Value".
• As shaded in the total section at the bottom.
• In the transaction number range at the bottom.  In this sample it is "Transaction Based on Value: 0000011"

Notice that a red warning message appears on the header row of each Patron when a Per-Unit Retail Allocation when a post already exists within the selected time period.  In the sample above, the message reads "4,006.00 Per-Unit Retain Allocation Already Exists for 01/01/08 - 12/31/08".

B.  The Per-Unit Retain Allocation Report

Selection screen:

Export output:

The purpose of the Export is to allow you the flexibility to over-ride any of the data based on your calculations and procedures, and then import the data (via Reports > Import Procedures > Comma Separated Import File).  

The columns on the export are below.

Columns A through M:

Columns N through Z:

Columns AA through AM:

Columns AN through AZ: