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:

AGS-2096 Patronage Rate per Unit - 3rd option added for "Dollars per unit"

Patronage has been enhanced to support Dollars per Unit refund rate basis.  User now has the option to set Patronage Code and Activity Transaction refund rate basis to Dollars per Unit.  Using dollars per unit rate basis supports scenarios where refund rate needs to be $10.00 or higher.   

Activity inquiry and reports have been modified to indicate the dollar per unit rate basis by a dollar symbol ($).  On patron statements, the dollar per unit rate is printed with no symbol indicating rate basis, while the cents per unit or percent of amount rates will continue to include a trailing "c" or "%" symbol. 

• Navigation: Patronage > Patronage Codes > View/Edit Patronage Codes

• Navigation: Patronage > Patronage Codes > Update Patronage Rates

• Navigation: Patronage > Patronage Codes > Print Patronage Codes

• Navigation: Patronage > Account Balance Inquiry > Activity History

Update Activity Rate Basis Maintenance

• Navigation: Patronage > Report Manager > Activity Reports

• Navigation: Patronage > Report Manager > Activity Audit Reports

• Navigation: Patronage > Report Manager > Patron Statements