Directions for per-unit-retains processing - New Method Release 18.1
This process is to walk through using the new Per-Unit-Retains function in Patronage 18.1
This replaces the functionality previously used of creating an Excel CSV Export file from GRN package and importing into PAT.
This replaces the functionality previously used of creating an Excel CSV Export file from GRN package and importing into PAT.
Accumulating Per-Unit-Retains
There are two ways to get to the Per-Unit-Retains Calculation.
- Pat > Patronage Transactions > Source Allocation > 5) Per-Unit-Retain Allocations
- PAT > Report Manager > Advanced Reports > Per-Unit-Retain Allocations Report
Both of these paths will get you to the same screen that allows you to accumulate the per-unit-retain source allocation transaction that will be saved in the patronage transactions.
- GREEN options -
Limit the report or creation of per-unit-retains to a range of names, locations & commodities. - GRAY options -
Use the name id fields to limit the range of name id’s that will be used to create the per-unit-retain transactions. Ideally, this will match how you payout your patronage accumulation but it could change under certain circumstances - RED options -
There are 6 Y/N questions for the different settlement distribution types. If you want to eliminate a type, you can exclude it by answering NO. Note that AP vouchers are considered the same as a grain settlement to a check, so they are always included. - YELLOW options - Delivery Sheet Detail Lines? -
New Page for Each Customer? -
Yes will create a new page for each customer so that’s easier to provide a copy of this report to your patron’s. I would make the report print out like a statement, so that you could just mail the per-unit-retain detail to the customer as proof behind the allocation.
Yes will create a new page for each customer so that’s easier to provide a copy of this report to your patron’s. I would make the report print out like a statement, so that you could just mail the per-unit-retain detail to the customer as proof behind the allocation.
- PURPLE options -
Post the Gross, Value, or net totals to the per-unit-transaction allocations. Note: this figure can be posted more than once, thus the warnings on the report that a record already exists.
Notes on the Report Created
- RED Warning -
If an allocation already exists for that customer and date range, you are warned on the report. It will still create an allocation transactions, but you do get a warning on the report. This warning occurs whether you are updating totals or not.
- Detail – All the settlements (with or without delivery sheet detail) are included on the report so that you may verify what is being allocated. Note that this detail is coming from the Grain package. This is not from accumulated patronage activity.
- Grand Totals – on the last page, grand totals of each calculation figure will be totaled for easy validation.
- If you answer NO to any of the grain settlement types, the grand totals amounts will state NA (not applicable) so you know what you flagged.
Per-Unit-Retain Allocation Remarks
Every allocation created for the customer will have a series of Remarks that give that provides the detail for what makes up the totals.
It’s the grand total for each settlement type for that allocation.
This is provided for research purchases.
NOTE: if you answered NO to a certain settlement type, such as A/R Reductions, then the notes would say NA as in you didn’t use this field to calculate.
To reverse Per-Unit-Transactions, take note of the Transaction number.
PAT > Patronage Transactions > Reverse Transactions
NOTE: The report will create multiple transactions if you post it multiple times. It does warn you on the report that there per-unit-transactions already exist.
