These procedures are general guidelines only, as each situation can be different. If you have other questions or need things clarified, please call customer support at 800-366-2474 or e-mail mysupport@culturatech.com
Before activity is accumulated for the period, review the following for any changes.
Has a new location been added? If so, are patronage codes set up by location?
Has any new product categories for inventory been added?
Has any new commodity codes or discount codes been added?
If yes to any of these questions, please review the patronage code set up and add any that are necessary. See Step 2 below for how to add a patronage code.
To add a patronage code go to Patronage
Reminder: Inventory patronage codes are equal to the Recap Category on the product category. This information can be found by printing a product category listing.
Select Patronage Codes from the menu and then chose View/Edit Patronage Codes
Click on the insert button, the following screen appears.
For inventory activity type in an S for Purchase/Sales and for the Accounting Type use 1.
For commodity activity type in a P for Purchase/Sales, use accounting type 2 – 4 for grain activity, which are explained below and 5 is used for discounts.
Activity type 2 – Commodity Received. This is for grain delivered by the patron and is accumulated based on the delivery sheet date.
Activity type 3 – Commodity Purchase/Sold. This is for grain that has been applied to a contract and/or settled. The activity is accumulated based on the latest date of application to the contract or date of delivery sheet.
Activity type 4 – Commodity Settled. This is for grain settled and is accumulated based on the settlement date.
The next portion on the screen is where the product category, commodity code or discount code is added. Remember to remove the location code unless each location is doing the refund based on a different rate.
Accumulate the activity.
To accumulate activity chose the Process Activity menu option and then the Accumulate Activity menu option
The following screen will appear.
Put in the date range for which the activity is to be accumulated. It is recommend accumulating by month regardless if waiting until the end of the fiscal year to accumulate.
Balance the accumulation to ledger, inventory management and/or commodity accounting. The inventory activity will be balanced to the respective product category sales in inventory management or to the sales on the financial reports.
Reports to print
Ledger – Use the financial statements or trial balance
Inventory Management – Use the inventory activity report Gross Margin Report by Product Category. Adjust the parameters and change the Transaction Type to be 1 – 1, change the activity date and on the Subtotal & Other Options screen answer the question "Print Inventory Activity Detail?" no.
Commodity Accounting – The report to use will depend on the accounting type being used to accumulate the activity.
Accounting type 2 "Grain Received" – Use the standard Delivery Sheet Report adjusting the parameters as follows:
Paid Status – P – U
Purchase/Sale – P – P
Application Type – Leave blank
Sheet Date – Use the date range of the activity to be balanced.
Accounting type 3 "Grain Purchased/Sold" - Use the standard Delivery Sheet Report adjusting the parameters as follows:
Paid Status – P – U
Purchase/Sale – P – P
Application Type – Blank – ZZ. This will only find grain applied to contracts.
Apply 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:
Print Status – P – U
Purchase/Sale – P – P
Settlement 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:
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. See the screen shot below.
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"
Patronage – Product Activity Report – Summary. Adjust
the parameters for the date range of the activity.
If accumulating the activity each month as you progress through the year then balance each month as you go along. If you are accumulating the activity at the end of the fiscal year then balance first for the whole year. If there is a problem then balance by the month to find where the problem is.
Run the Name/Address Report adjusting the parameters based on the flags used to issue the patronage refund. Verify that the list is correct. If not, make the necessary changes in Name/Address.
After everything is balanced compress the activity by going to Process Activity and the chose Compress Activity. Be sure to answer Y to "Compress Activity" question.
Now is the time to add any accrual activity that needs to be accounted for (i.e. storage) or activity on in the system (i.e. cotton or milk). To determine storage accruals run the Storage Charge process without updating. See the print screen below.
Transfer any activity that needs to be transferred. Option 1 allows the user to control whose activity and which activity is being transferred. Option 2 use the patronage split information in Name/Address to move all activity as defined.
The auditors may require reports that show member business vs. non-member business. There are several reports that will provide this information. The report to run will depend on the information that the auditor wants to see. Most generally the report to use is the standard activity report Product Activity Report – Summary. Run the report adjusting the parameters only for the date range to find all business and then run the report again adjusting the parameters for the date range and for only member/consenter business.
Put the correct refund rates on the patronage codes by selecting the patronage code and changing the rate and the rate basis.
In Set up Information - Patron Refund Information, verify the information and make any necessary changes.
Print the Projected Refund Summary - by Patron report. Be sure to adjust the parameters to only include those people who are eligible to participate in the refund. Verify the actual refund amount. Review the information to be sure that the patrons included are correct. If patrons are missing or are included and should not be, change the flags in Name/Address and then compress the activity again. This time put in the date range of the activity and answer N to "Compress Activity" question.
Go to Setup Information to check the System Integration to be sure that it is turned on for Patronage Refunds. This will allow the vouchers to be created in AP.
You are now ready to create the Patronage Refund Transactions by going to Patronage Transaction – Patronage Refunds.
Enter in the appropriate date range for the activity
Select the proper Equity Source Code
The Transaction date will be the date of the vouchers and should be the current day.
Enter Remarks as desired. These will only be viewable when looking at the transaction in Patron Transaction History.
Click OK
For rate selection chose Option 2 – Patronage Code Refund Rate.
Click OK.
After the system finds the first patron for a refund the user can accept the next voucher number or blank it out and use the next control number
After the transactions have been created go to Accounts Payable to print the checks.
Created by Sherelyn J Thomas-roberson Created on 10/17/2007 4:38:00 PM Edited on 08/14/2012