Balancing Patronage Accumulation to INV and GRN

What reports are you using to balance sales to patronage?

NOTE:

The Accumulate Activity will pick up all activity that is within the ACTIVE patronage codes.
Inactive patronage codes do NOT pull activity.
Items that are inactive in inventory but within the active patronage code will pull into activity.
Inactive customers will have activity accumulated and a refund paid.
PAT does not use active/inactive status on name id.

PATRONAGE REPORT

Patronage > Activity Reports > PRODUCT ACTIVITY REPORT - SUMMARY
Gives total quantity and total amount by patronage code.
Compare this to the reports in Inventory/Grain/Ledger.

INVENTORY REPORT

INV > activity report > standard > GROSS MARGIN REPORT BY PRODUCT CATEGORY
Run the report twice, once for activity date range with void date blanked out
Then once again for voids using the void date.
Subtract the voids from the activity.
Range selection of 1 to 1 for invoices to invoices on both reports.
Customer to Customer record.
No Detail on totals.
Common UOM on Additional Options Screen

GRAIN REPORT

Verify how you accumulate grain.
(i.e.: received, purchased/sold, settled, discounts)
All grain must be on a delivery sheet for accounting types 2 “Grain Received” and 3 “Grain Purchased/Sold”, due to this requirement it is recommended to accumulate and balance patronage at year end, not each month.
·         (Accounting Type 2 - Grain received accumulates off delivery sheet date)
·         (Accounting Type 3 - Purchased/sold - contract application date or sheet date [whichever comes later] but it must be on a delivery sheet
(delivery sheet reports, standard, CONTRACT APPLICATION REPORT)
·         (Accounting Type 4 - Settled - settlement date)
·         (Accounting type 5 - Discounts - settlement date)

         So, in knowing how you are accumulating, you can run delivery sheet reports or settlement reports using the correct date range to get grand totals & you need to run them twice.
        Once for transaction date with voids open.
        Then run it again for void dates to subtract from first report totals.

Accounting type 1 “Inventory Purch/Sold” is only used for the Inventory Package.
Accounting type 2 “Grain Received” – Delivery Sheet Activity Report less Voided Activity Report - Use the standard Delivery Sheet Reports adjusting the parameters as follows:
Delivery Sheet Activity Report
·            Paid Status – P- U
·            Purchase/Sale – P – P
·            Application Type – Leave blank
·            Apply Date – Use the date range of the activity to be balanced
Voided Activity Report
·            Paid Status – P – U
·            Purchase/Sale – P – P
·            Application Type – Leave Blank
·            Delivery Sheet Status – V - V
·            Settlement/Defer/Void Date – Use the date range of the activity to be balanced
Accounting type 3 “Grain Purchased/Sold” - Delivery Sheet Activity Report less Voided Activity Report - Use the standard Delivery Sheet Reports adjusting the parameters as follows:
Delivery Sheet Activity Report:
·            Paid Status – P – U
·            Purchase/Sale – P – P
·            Application Type – AA – ZZ
·            Application Date – Use the date range of the activity to be balanced
Voided Activity Report
·            Paid Status – P – U
·            Purchase/Sale – P – P
·            Application Type – AA – ZZ
·            Delivery Sheet Status – V - V
·            Settlement/Defer/Void Date – Use the date range of the activity to be balanced
Accounting type 4 “Grain Settled” – Use the standard Settlement Report adjusting the parameters as follows:
Settlement report:
·            Print Status – A – U (A = Unpaid A/P Voucher to U = Unprinted)
·            Purchase/Sale – P – P
·            Settlement Date – Use the date range of the activity to be balanced
Voided Settlement Report
·              Paid Status – V - V
·               Purchase - P - P
·               Void Date – Use the date range of the activity to be balanced.
Accounting type 5 “Commodity Discounts” – Use the standard Delivery Sheet Report adjusting the parameters as follows:
Delivery Sheet Report
·            Paid Status – P – U
·            Purchase/Sales – P – P
·            Settlement Date – Use the dare range of the activity to be balanced
·            On the Additional Options screen adjust the following parameters:
·            Deduction Status – P – P
·            Deduction Type – This is the discount code of the activity
·            Answer Y to the question “Include Only the Sheets with These Deductions”
Voided Delivery Sheet Report
·            Paid Status – P – U
·            Purchase/Sales – P – P
·            Sheet Date – Use the dare range of the activity to be balanced
·            On the Additional Options screen adjust the following parameters:
·            Deduction Status – P – P
·            Deduction Type – This is the discount code of the activity
·            Answer Y to the question “Include Only the Sheets with These Deductions”

LEDGER REPORT

If you are balancing to the ledger:

Print out the Grain system Account setup by ledger code
SJI > System Accounts > Commodity Accounts > Print
Answer YES by ledger account
See what is posting to your purchase accounts
Is it just the Grain purchases or is it also discount codes.
If it is discount codes, are those codes defined to be pulled into Patronage?
Because if you balance Patronage to ledger grain purchases and Purchases cost of grain is getting hit by discount codes and purchases, then we have to decide if you want those discount codes in Patronage setup or not.
This must all be considered if balance Pat to Ldg.
Print the Trial Balance for the appropriate ledger codes to balance to Patronage
LDG > Report Manager > Journal Entry Reports > Standard > Trial Balance
Key in ledger account
Key in Location code if required.
Key in ledger period to match Patronage accumulation periods.