Order Reconciliation Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Held Order by Pay Type Report |
Sales Journal by Currency Report
This report displays invoices and credit invoices based on the invoice date range and optionally, currency, you defined. The amounts on this report display in the local currency and alternate (foreign) currency.
Determining the alternate currency: The system looks at the currency code and conversion rate defined for the order in the Order Header Extended table to determine the currency associated with the invoice and the conversion rate to use to determine the alternate currency amount. The system multiplies the local amount by the conversion rate to determine the alternate amount. If the currency code has Decimalized currency unselected, the system rounds the amount to the nearest whole unit of currency.
How to print: Select Submit at the Print Sales Journal by Currency Screen.
For more information: See the sample report in PDF format.
Contents:
• invoice dates: the invoice date range you selected at the Print Sales Journal by Currency Screen.
• currency: the currency associated with the invoices and credit invoices. The system looks at the currency code defined for the order in the Order Header Extended table to determine the currency associated with the invoices and credit invoices. If the invoices and credit invoices are for the local currency, this field is blank.
• invoice date: the date when you shipped and billed the merchandise.
• pay plan type: the payment plan type associated with the order. Valid values are regular (no payment plan), deferred, and installment.
• pay type: the payment type associated with the invoice or credit invoice.
• invoice: invoice number; this is an invoice that falls under the currency, invoice date, pay plan type, pay type combination.
• customer: the number of the customer associated with the invoice.
• order: the order number associated with the invoice.
• merchandise: the merchandise amount on the invoice in the alternate currency. The system multiplies the local merchandise amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate merchandise amount. If the invoice is for the local currency, the merchandise amount displays in the local currency.
• freight: the freight charges for the invoice in the alternate currency. The system multiplies the local freight amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate freight amount. If the invoice is for the local currency, the freight amount displays in the local currency.
• additional freight: the additional freight amount for the invoice in the alternate currency. The system multiplies the local additional freight amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate additional freight amount. If the invoice is for the local currency, the additional freight amount displays in the local currency.
• tax: the tax amount for the invoice in the alternate currency. The system multiplies the local tax amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate tax amount. If the invoice is for the local currency, the tax amount displays in the local currency.
• handling: the special handling amount for the invoice in the alternate currency. The system multiplies the local handling amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate handling amount. If the invoice is for the local currency, the handling amount displays in the local currency.
• additional charge: the additional charge amount for the invoice in the alternate currency. The system multiplies the local additional charge amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate additional charge amount. If the invoice is for the local currency, the additional charge amount displays in the local currency.
• total invoice: the amount billed for the invoice in the alternate currency. The system multiplies the local invoice total by the conversion rate defined for the order in the Order Header Extended table to determine the alternate invoice total. If the invoice is for the local currency, the total invoice amount displays in the local currency.
• amount collected: the amount you have received from the customer in the alternate currency. The system multiplies the local collected amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate collected amount. If the invoice is for the local currency, the amount collected displays in the local currency.
• total credits: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoice credits grouped under the currency, invoice date, payment plan, pay type combination.
• XXX total credits (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoice credits grouped under the currency, invoice date, payment plan, pay type combination. This field displays only for invoice credits associated with an alternate currency.
• total invoices: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan, pay type combination.
• XXX total invoices (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan, pay type combination. This field displays only for invoices associated with an alternate currency.
• totals for pay type: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, pay type combination.
• XXX totals for pay type (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, pay type combination. This field displays only for invoices associated with an alternate currency.
• totals for pay plan type: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan combination.
• XXX total for pay plan type (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan combination. This field displays only for invoices associated with an alternate currency.
• total for date: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date combination.
• XXX total for date (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date combination. This field displays only for invoices associated with an alternate currency.
• grand total: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices across all currencies, invoice dates, payment plans, and pay types. A grand total in the alternate currency does not display on this report.
Order Reconciliation Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Held Order by Pay Type Report |
CS06_01r OMSCS 18.1 April 2019 OTN