P/O Return Entry Screen
Click this button to open the P/O Purchase History Screen and check information about the items you have purchased from your vendors.
If the transaction was entered manually in Purchase Orders, the field displays the user ID of the person who entered the transaction.
Enter a unique number for a new return you want to add. Use up to 22 characters. You can also leave the field showing ***NEW*** to let Purchase Orders assign the return number during posting.
When editing an existing, incomplete return, enter its number or select it from the Finder beside the Return Number field.
You specify the length, prefix, and next number to assign to returns in the P/O Options screen.
Identifies the vendor to whom you are returning the items. The vendor number sets the default tax group and payment terms. In multicurrency systems, the vendor number also specifies the currency of the document.
-
To select an existing vendor, enter the vendor's number and then press Tab.
-
To add a new vendor, do one of the following:
-
If you want to add the vendor record now, click the New button after entering the vendor number. Fill in the vendor information in Accounts Payable, choose Add, then choose Close to return to Purchase Orders.
-
If you do not want to add the vendor record now, enter only the vendor number. (You can enter the vendor name on the next tab.)
-
Note: You must add the vendor record in Accounts Payable before you can post invoices, credit notes, and debit notes for the vendor in the Accounts Payable program. You cannot enter returns for vendors whose accounts are inactive in Accounts Payable.
If you use Inventory Control, select an Inventory Control location code to which the vendor can send the credit note for the return.
You can also use the Zoom button to open a separate screen where you can edit the address for the code you select, or you can omit the code and enter an address manually. You do not need to specify a bill-to location.
If you are entering a return to a receipt, the bill-to information from the receipt is displayed, but you can change it.
You can edit bill-to information as long as the return is not complete (that is, you have not issued a credit note from the return).
If the purchase order and receipt were job-related, the Job-Related check box will be selected for the return, and you will not be able to change this selection.
If you are not referencing a particular receipt, you have to choose Job Related if you are returning materials related to a job.
The contract, project, category, cost class and resource (item number column) for each receipt detail will be provided by the program — as will the customer billing type, billing rate, and A/R item used for billing.
Note: If you use different terms than “Contract,” “Project,” and “Category” in Project and Job Costing, the program displays them instead.
If you are entering a return without a receipt number, you can enter a purchase order number, including a number that has not been added to Purchase Orders, or leave the field blank.
If you are entering a return to a receipt, you cannot edit the field. If the receipt specified a purchase order number, the purchase order number is displayed.
Enter the posting date for the transaction.
The posting date is different from the document date. The posting date is the date for transactions being posted to the General Ledger, so it also determines the contents of the Fiscal Year and Period fields.
If you have a multicurrency system, currency revaluation uses posting dates to select open documents for revaluation purposes, and thus, revaluation adjustments are posted to General Ledger in the correct fiscal year and period.
Depending on your settings in the P/O Options screen, Purchase Orders automatically displays the session date or the document date by default in this field.
You can change the posting date, but you cannot separately change the fiscal year and period.
Note: If you consolidate G/L transactions, the posting date for consolidated entries is the last date of the fiscal period.
If the receipt used retainage accounting, the program will display additional retainage fields for each return detail line to display the retainage percentage and period for each detail line in the return.
The program will also display the Retainage tab to let you specify the exchange rate that you want to use for returns of multicurrency retainage receipts.
Enter the date you want to use as the return date. The program displays the sign-on date you entered to start Sage 300.
You can also change the posting date if you want a different date for the G/L transactions when they are posted in the General Ledger. (The posting date determines the fiscal year and period displayed beside the Posting Date field.)
Use the Ship Via fields to specify the shipping method by which you plan to return the goods to the vendor. The program displays the ship-via description for the code you select.
Enter an optional ship-via code or use the Finder to select one of the ship-via codes you have defined in Purchase Orders.
You can also skip the Ship Via field and enter a description of the shipping method in the field beside the Ship Via field, or leave both fields blank.
Enter an optional template code from the templates defined in the Templates screen.
The template code provides default information for the Return tab. If you selected a receipt number for the return or you are editing a previously posted return, you cannot change the entry in the Template Code field.
On returns you enter without receipt numbers, if the vendor record specifies different information from those used with the template, the information from the vendor record is inserted in place of the default template information.
If you select a new template after choosing the vendor, Purchase Orders will replace the return information and vendor information with the information from the new template.
You cannot change the template after you have added details to the return.
The account set from the vendor record appears in this field as the default. It specifies the general ledger payables control, purchase discounts, prepayment, and retainage accounts to which the transaction will be distributed.
You can change the account set for a particular purchase order, receipt, return, invoice, credit note, or debit note. If you use multicurrency accounting, however, the new account set must use the same currency as the vendor's account set.
Note: If you change the account set on a receipt, make sure that you use the same account set for returns, invoices, and credit or debit notes.
This is the fiscal year and period to which the return transactions will be posted in the general ledger. You can change the fiscal period by changing the Posting Date.
You can enter a different Return Date, and you can enter a different Posting Date for the document.
(Remember that you cannot post transactions to closed fiscal periods.)
Open this table from the Return tab.
For job-related returns, the program provides the Billing Type, Billing Rate, and AR Item Number that was used for the receipt.
The Job-Related check box in the top part of the screen will be selected if the receipt was job-related.
This field displays the A/R item number associated with the project resource used for the contract in Project and Job Costing. You can select a different A/R item number only for time and material projects, as follows:
- On a standard project, this field displays the A/R item number and unit of measure specified for the project resource category as the default. You can accept the item number or select another valid A/R item number.
- On a basic project, this field displays the A/R item number and unit of measure specified for the project category. You can accept the item number or select another valid A/R item number.
- If you change the A/R item number, the item number must be a valid item number in Accounts Receivable, and the unit of measure must be a valid unit of measure both for the new item number and the vendor’s currency.
Cost plus and fixed price projects do not use an A/R item number.
This field appears only in multicurrency systems for time and materials projects and for fixed price projects using billings and costs or accrual-basis accounting methods.
The billing currency is the customer's currency specified on the contract, and you cannot change it.
Billing currency is blank for Fixed Price projects using completed project or project percentage complete methods, and for Cost Plus projects.
Note: Billing currency is not displayed for basic or standard internal Time and Materials projects, or for single-currency Fixed Price projects that use billings and costs or accrual-basis accounting methods.
This field displays the billing rate for the specified resource (for standard projects) or category (for basic projects).
You can edit the billing rate if the billing type is Billable. The field displays 0.000000 if the billing type is Non-Billable or No Charge.
- You can specify the billing rate for Time and Materials projects and for Fixed Price projects that use Billings and Costs or Accrual-Basis accounting methods.
- Billing rate is disabled and set to 0.000000 on a basic or standard internal contract for Time and Materials projects or for Fixed Price projects using Billings and Costs or Accrual-Basis accounting methods.
- The billing rate cannot be negative.
This field appears in the detail-entry section only for job-related purchase orders.
The billing type indicates to Project and Job Costing whether to bill the cost to the customer. You can change this field only for a time and materials project, as follows:
On a basic project:
For a billable project, the category billing type determines whether you can change the billing type for the detail. If the specified category is:
- Billable, the default billing type for the detail is billable, but you can change it.
- No charge or non-billable, the program sets the same billing type for the detail, and cannot change it. You cannot specify a billing rate for the detail, which the program sets as zero.
If the detail is billable you can specify a billing rate for the detail.
If you change the billing type for the detail to no charge or non-billable, the program sets the billing rate to zero and you cannot change it.
If the project is no charge or non-billable, the detail uses the same billing type as the project, the billing rate is set to zero, and you cannot change them.
On a standard project:
If the project is billable, the resource billing type determines whether you can change billing type for the detail. If the specified resource is:
- Billable, the program displays Billable as default billing type, but you can change it for the detail. If the detail is billable, you can specify a billing rate for the detail.
- No charge or non-billable, the program sets same billing type for the detail, and you cannot change it. You cannot specify a billing rate for the detail, which the program sets as zero.
If you change the billing type for the detail to no charge or non-billable, the program sets the billing rate to zero, and you cannot change it.
If the project is no charge or non-billable, the detail uses the same billing type as the project, and you cannot change it. The program also sets the billing rate to zero, and you cannot change it.
For fixed price and cost plus projects, the Billing Type field is blank. A billing type is not required for these types of projects.
This field appears for Time and Materials projects if you selected the Job Related option for this transaction.
You must enter a unit of measure that is valid for the item number/resource that you specified and for the contract customer's currency.
Note: For internal time and materials projects (basic or standard contracts) the A/R item unit of measure will be disabled or blank.
To enter comments for a detail line, click the Zoom button beside the Comments field, enter comments, then click Close. (Press Shift+F9
to open or close the screen using your keyboard.)
Any comments entered for the detail line on the receipt are included on the return, but you can change or delete them.
You can print the comments on the return form.
If the purchase order and receipt were job-related, the program will provide the job to which each detail was assigned. If you use different terms than “Contract,” “Project,” and “Category” in Project and Job Costing, the program displays them instead.
Purchase Orders updates the actual quantities and costs for jobs with the amounts on returns.
For job-related returns:
- The Job-Related check box will be automatically selected if the purchase order and receipt were job-related.
- You enter/select the resource using the Item Number field.
Use the Item Number field to identify the resource for this detail.
You must specify a resource that is assigned to the project and category in Project and Job Costing. You can specify an inventory item number, or the code for another type of resource (such as an equipment code, subcontractor code, or employee number).
Note: You cannot leave this field blank.
You can enter a discount as a percentage or an amount. The program uses the amount you enter in this field to calculate the discounted cost for the item detail.
If you enter a percentage in this field, Purchase Orders calculates the discount amount for the item detail.
Tip: If you prefer not to enter discounts for individual details, you can enter a discount percentage for the entire document on the Totals tab. Purchase Orders then prorates the discount amount for the transaction details, overriding any discounts you may have entered manually for the details.
You can enter a discount as a percentage or an amount. The program uses the amount you enter in this field to calculate the discounted cost for the item detail.
If you enter a discount amount, the program calculates and displays the discount percentage based on the cost. (Alternatively, you can enter a percentage in the Discount Percent field, and let the program calculate the discount amount.)
Tip: If you prefer not to enter discounts for individual details, you can enter a discount amount for the entire document on the Totals tab. Purchase Orders then prorates the discount amount for the transaction details, overriding any discounts you may have entered manually for the details.
On new returns you are entering without receipt numbers, you enter the item number or select it from the Finder. If you use the Allow Non-inventory Item Numbers option in Purchase Orders, you can also enter an item number that is not included in your Inventory Control data.
If you are entering a return to a receipt or you are editing a return you posted previously, the program displays the item number that was entered with the detail. You cannot change it.
This field appears if you use Inventory Control.
If you are entering a return without a receipt number, enter the code for the location from which you are returning the items.
If you are entering a return to a receipt or editing a previously posted return, the program displays the location code entered for the detail on the receipt. You cannot change it.
If a manufacturer's item number was used on the receipt or return, the program also displays the manufacturer's item number on the return.
Manufacturer's item numbers are alternative item numbers — such as bar codes or shortcut codes — that identify your inventory item. You set up manufacturer's item numbers in the Inventory Control system.
You can enter manufacturer's item numbers wherever you enter item numbers in Purchase Orders.
Use the Non-Stock Clearing Account field to change the non-stock clearing account associated with this item's account set.
If the item used in the detail is a non-stock item, the non-stock clearing account associated with the item's account set appears.
If you are returning a non-stock item, the non-stock clearing account associated with the item's account set appears. You can specify a different account, if necessary.
If optional fields have been defined in Purchase Orders for return details, you can click the Zoom button beside the Optional Fields field to display the optional fields assigned to a selected detail, and edit their contents.
For more information about using optional fields in transactions, see About Optional Fields in Transactions.
Enter the number of units of the item that you are returning.
If you are entering a return to an existing receipt or editing a previously posted return, be sure that the return quantity you enter is in the unit of measure that is used for the detail. You cannot change the unit of measure that was entered with the receipt or previously posted return.
If you do not allow negative inventory levels in Inventory Control and you enter a return quantity that will drop the item quantity on hand below zero, a warning message is displayed. You must then choose whether you still want to return that quantity.
If you use Serialized Inventory and Lot Tracking, a separate screen appears after you have entered the quantity of serialized/lotted items returned, then press Tab (or press Enter). (This screen also opens when you click the Zoom button in the Quantity column header.)
You can enter a return cost on returns that do not reference a receipt number.
Note that if you change the displayed return cost, the unit cost is recalculated. The program also recalculates the return cost if you change the unit cost.
If you are working with an existing receipt or return, you cannot change either of these entries.
If the Retainage option was selected for the receipt, the program will display additional retainage fields for each return detail line to let you enter a retainage percentage or amount and the retention period.
The program will also display the Retainage tab to let you specify the exchange rate that you want to use for the retainage portion of multicurrency returns.
If you clear the Retainage option, the percentage and period retainage fields disappear from the item detail section, and the Retainage tab also disappears.
By default, the program displays the retainage percentage/amount and retention period that was in effect for the receipt.
Note: Retainage accounting applies only to job-related transactions, and is available only if you selected retainage accounting in the Accounts Payable program.
This field appears on the Detail Items/Taxes screen.
Use this field to indicate whether tax amounts are included in the item cost (instead of charged in addition to the detail cost).
To toggle between Yes and No in this field, enter any character in the field, or double-click the field with a mouse.
The default choice for this option is provided from the vendor record in Accounts Payable or from the vendor contract cost.
You can choose Yes for this option only if the Allow Tax In Price option is selected for the authority in Tax Services.
If you are adding a return without a receipt number, enter the unit of measure to use or select it from the Finder. (If you entered a non-inventory item number, you cannot select a unit of measure from the Finder.)
If you are entering a return to a receipt, the program displays the unit of measure entered for the detail on the receipt. You cannot change it.
Enter the code the vendor uses to identify the item or edit a displayed code, if necessary.
If the vendor's item number is specified in the item record (when you are adding a new detail) or on the receipt for which you are entering a return, the code appears in this field. (You can enter vendors' item numbers when assigning vendor types in Inventory Control item records.)
This is the unit of measure (such as pounds, kilograms, tons) for the weight of this item on the return.
By default, the program displays the weight unit of measure from the receipt (if you specified one), but you can change it to another defined unit of measure (and the program will recalculate the weight accordingly).
The weight UOM for the complete return is determined by the default weight unit of measure set in the I/C Options screen (or in the P/O Options screen, if you do not use Inventory Control).
This field appears on the Taxes tab for Receipt Entry, Invoice Entry, Return Entry, and Credit/Debit Note Entry if retainage applies to the document.
It shows the amount of tax calculated for this authority for the retainage portion of the document if you report tax for retainage amounts when you create the retainage document (not when you create the original document).
Retainage appears only on job-related documents if you select the Retainage option on the first tab of the transaction entry screen.
Retainage tax amounts are computed using the retainage tax base and the tax rate for each tax authority.
The retainage tax base is the amount (before included taxes) used as the base for calculating taxes on the retained amount.
Essentially, the retainage tax base is the retainage portion of the document (excluding tax) if you report tax for retainage amounts at the time that you create the retainage document (not when you create the original document).
Retainage appears only on job-related documents if you select the Retainage option on the first tab of the transaction entry screen.
Retainage tax amounts are computed using the retainage tax base and the tax rate for each tax authority.
Tax reporting fields appear on the Taxes tab only if the tax group's tax reporting currency is different from your functional currency and the vendor's currency.
Along with the tax reporting currency, the program displays the amount of included and excluded tax to be reported in that currency on tax tracking reports for all the tax authorities listed on the document.
You set the tax reporting currency for tax groups in the Tax Services module in Common Services.
This field displays the sum of the tax reporting amounts for all tax authorities.
It appears only if the tax reporting currency for the tax group is different from your functional currency and the vendor's currency.
You set the tax reporting currency for tax groups in the Tax Services module in Common Services.
This field appears on the Taxes tab for Receipt Entry, Invoice Entry, Return Entry, and Credit/Debit Note Entry if retainage applies to the document.
It shows the total amount of tax calculated for the retainage portion of the document if you report tax for retainage amounts when you create the retainage document (not when you create the original document).
Retainage appears on job-related documents only if you select the Retainage option on the first tab of the transaction entry screen.
Retainage tax amounts are computed using the retainage tax base and the tax rate for each tax authority.
The Retainage tab lets you specify the exchange rate that you want to use for returns of multicurrency retainage receipts. You can:
-
Use the original document exchange rate
-
Use the current exchange rate
Note: This tab will appear only if you used retainage accounting on the original receipt or invoice.
The Optional Fields tab contains optional fields added by your company that apply to the transaction as a whole. Optional fields on detail lines apply to the individual transaction detail.
Note: This tab will appear only if you have Transaction Analysis and Optional Field Creator.
The Rates tab appears only for multicurrency ledgers.
When Purchase Orders calculates the tax amount in a tax reporting currency, the program uses the Tax Reporting Currency Exchange Rate that appears (or that you enter) on the Rates tab.
However, if you have changed the tax reporting amount that appears on the Taxes tab, you can click the Derive Rate button to see the actual exchange rate between the tax amount and the tax reporting amount.
In other words, the Derive Rate button appears so you can derive the exchange rate for the tax reporting currency, if you change the calculated amount on the Taxes tab.
The program displays the exchange rate currently in effect for the specified currency and the displayed rate type and rate date, but you can change the rate.
You receive a warning if you change an exchange rate by an amount that exceeds the Spread setting for the currency in Common Services' Currency Rates table.
If you are entering a return to a receipt, the screen also displays the exchange rate entered on the receipt.
Type or select the date to use to select the exchange rate for the document you are entering.
The program displays the rate date that is nearest the document date you entered, but you can specify a different date for which an exchange rate exists for the currency in Common Services' Currency Rates table.
If you change the rate date, Purchase Orders checks the rate tables for a date match, and updates the rate if necessary.
If you are entering a return to a receipt, the screen also displays the rate date used with the receipt.
If the rate type you want to use is not displayed, enter the code or choose it from the Finder.
The program uses rate types when converting multicurrency amounts on the invoice to functional currency. Examples of rate types might be "spot rate," "average rate," and "contract rate."
You define rate types using the Currency Rate Types screen in Common Services, and assign the default rate type for Purchase Orders on the Processing tab of the P/O Options screen.
If you are entering a return to a receipt, the screen also displays the rate type used with the receipt.
Enter a comment for the return, using up to 250 characters. The program automatically wraps text as you reach the end of a line. If you wish to insert your own line breaks, press Ctrl+Enter where you want a line break to occur.
If you are entering a return to a receipt, the comment, if any, entered on the receipt is displayed, but you can change it.
If you are editing a posted return, you cannot change the comment.
This is the tax amount that will be applied to the retainage invoice (if the tax authority allows you to defer tax on retained amounts on an original receipt and invoice).
If you are applying all tax amounts to the original invoice, this amount will be zero.
Retainage amounts are invoiced at a later time, in Accounts Payable.
You can enter an optional discount percentage or discount amount for the entire document, or enter discounts for individual detail lines.
If you enter a discount for the entire document, Purchase Orders prorates the discount amount for the document details, overriding any discounts you may have entered manually for the details.
Overview
Use the Return Entry screen to:
- Enter, edit, and post returns of merchandise to vendors.
- Export returns to non-Sage 300 programs and other Sage 300 Purchase Orders databases.
- Assign serial/lot numbers to returned items (if you use Serialized Inventory and Lot Tracking ).
Return Tab
Use the Return tab to enter:
- The return date.
- The receipt number to which the return applies (if any).
- The billing address for the return.
- An optional description, reference, and comment.
- The details of items you are returning to a vendor.
Note: The information you can enter is restricted if the return includes a receipt number or you have already posted the return.
This tab also lets you:
- Open the P/O Return Entry Bill-To Location Screen.
- Edit details on a return you posted previously.
- Open the P/O Return Entry Detail Items/Taxes Screen on which to enter details instead of using the spreadsheet-style grid you see on the Return tab. (The Detail Items/Taxes screen displays all the fields for a single detail, including tax fields.)
Taxes Tab
Use the Taxes tab to:
- Check the vendor's tax group.
- Check tax information and edit the tax-included options and amounts for the vendor's tax authorities.
To cancel changes you make to tax amounts, click the Calc. Taxes button. The program recalculates the taxes using the tax tables in Tax Services.
Retainage Tab
The Retainage tab appears only for returns of job-related items that had amounts retained on the receipt or invoice. If the items were originally received in another currency, you use this tab to specify the exchange rate to use for the return:
- Original retainage exchange rate for the return.
- Current exchange rate.
Optional Fields Tab
This tab appears if you have assigned optional fields to the Return Entry window, and allows you to add or change information in these fields. More...
Rates Tab
The Rates tab appears only in multicurrency ledgers when you are entering a return for a vendor who does not use the functional currency. More...
Totals Tab
Use the Totals tab to:
- Enter a comment for the return.
- Enter the discount percentage or amount for the entire return.
- Verify return totals for the vendor.
- Check the estimated weight of the goods for that you are returning.
- Check the number of item details entered for the vendor on the return.
- Check the return subtotal and tax amounts for the vendor.