Sales Interface

New features added, version 7.5.2

Listed below for the Sales Interface is the posting type, the posting type description, the debit or credit type for the posting type, what transactions are used for the postings, and the calculation for the posting.

For example, the posting type COGS is used to post for each sales order line and is calculated as the cost type S for the item times the quantity shipped.

Sales Interface Default Posting Parameter Requirements

You must set up default posting parameter records for the following posting types in the sales interface:

CASH
A/R
CDSC
DPST
WTDN
WTUP

Default posting parameter records are those that are set up by location with the Argument Item or value set to ANY. Program ARPE, Cash Receipts Entry, uses the default posting parameter records. If these records are not entered here, you will receive errors when you run program ARPE, Cash Receipts Entry.

The Sales Interface uses Single-sided entries

A/R Accounts Receivable Debit - Each sales order. Net Invoice value exclusive of payment recorded.

CASH  Cash and Checks Debit - Each customer check. The value of the check.

CDSC  Discounts Taken Credit - Each invoice. The amount discounted from the invoice amount due by the customer in accordance with the terms offered.

COGS  Cost of Goods Sold Debit - Each sales order line. Inventory cost for cost type S (quantity shipped * cost type S unit cost)

COGS2 Second Cost of Goods Sold Debit - Each sales order line. Inventory cost for second posting cost type (quantity shipped * second posting cost cost type unit cost)

COGSD  Ship Detail Cost of Goods Debit - Each sales order line shipping location record. Inventory cost for cost type S (location quantity shipped * cost type S unit cost). If a remainder exists, the last location gets remaining amount.

This posting type is not a replacement for the COGS posting type. Do not suppress posting of the COGS posting type when using this posting type. This is not necessary and will result in bad journals.

For a given line item, the postings will come either from the COGSD or the COGS posting type depending on the presence of shipping location records. It will never post both sets for the same line item.

CPAY  Payment Credit Credit - Each sales order payment line. The payment amount.

CTFCR Container Freight - Credit Credit - Each container. The freight amount assigned to the container.

CTFDR Container Freight - Debit Debit - Each container. The freight amount assigned to the container.

CURR Currency Gain/Loss 

DPAY  Payment Debit  Debit - Each sales order payment line. The payment amount.

DPST  Deposits  Debit - Each sales order. Deposit consumption in summary record.
Credit - Each deposit received from a customer. The deposit amount (check amount).

FCCR  Cost of Freight Credit Credit - Each sales order. Summary record freight cost amount.

FCDR  Cost of Freight Debit  Debit - Each sales order. Summary record freight cost amount.

FRT  Freight Credit - Each sales order. Summary record freight amount.

INV  Inventory  Credit - Each sales order line. Inventory cost for cost type S (quantity shipped * cost type S unit cost)

INV2 Second Inventory Cost Credit - Each sales order line. Inventory cost for second posting type (quantity shipped * second posting cost cost type unit cost)

INVD  Ship Detail Inventory  Credit - Each sales order line shipping location record. Inventory cost for cost type S (shipping location quantity shipped * cost type S unit cost). If a remainder exists, the last location gets remaining amount.

This posting type is not a replacement for the INV posting type. Do not suppress posting of the INV posting type when using this posting type. This is not necessary and will result in bad journals.

For a given line item, the postings will come either from the INV or the INVD posting type depending on the presence of shipping location records. It will never post both sets for the same line item.

MISC  Miscellaneous Credit - Each sales order miscellaneous charge record amount.

NSF  Returned Checks Credit - Each customer check. The value of the check that was returned 'insufficient funds'

OAC  On Account Cash Debit - Each customer check. The amount placed 'on account', i.e. not applied to an invoice.

REV  Revenue Credit - Each sales order line. Quantity shipped * list price.

REVD  Ship Detail Revenue Credit - Each sales order line shipping location record. Shipping location quantity shipped * list price. If a remainder exists, the last location gets remaining amount.

This posting type is not a replacement for the REV posting type. Do not suppress posting of the REV posting type when using this posting type. This is not necessary and will result in bad journals.

For a given line item, the postings will come either from the REV or the REVD posting type depending on the presence of shipping location records. It will never post both sets for the same line item.

RMPC  Returns Paid by Check Debit - Each sales order. Net invoice where the order is a credit and the customer requested a refund by check in POS.

SLAC  Commission Earned  Credit - Each sales order line. Commission amount.

SLXP  Selling Expense (Commission) Debit - Each sales order line. Commission amount.

TAX Sales Tax Credit - Each sales order line. Quantity shipped * tax rate for order line.

TDSC  Trade Discounts Debit - Each sales order line. Quantity shipped * list price less extended price.
Debit - Each sales order Summary level customer additional discount.

TDSCD  Ship Detail Trade Discount Debit - Each sales order line shipping location record. Shipping location quantity shipped * list price less extended price. If a remainder exists, the last location gets remaining amount.

This posting type is not a replacement for the TDSC posting type. Do not suppress posting of the TDSC posting type when using this posting type. This is not necessary and will result in bad journals.

For a given line item, the postings will come either from the TDSC or the TDSCD posting type depending on the presence of shipping location records. It will never post both sets for the same line item.

WTDN  Write Down Debit - Each Invoice. The unpaid amount written off.

WTUP  Write Up Credit - Each Invoice. The overpaid amount written off.

Sales Post Types and Parameter Items

INV, COGS, INV2, COGS2, REV, TDSC (line items), SLXP, SLAC, TAX - These posting types are all taken from the order lines.

REVD, COGSD, INVD, and TDSCD - These postings types are all taken from the shipping detail location records.

TDSC (additional discount in summary), FRT, DPST (deposit consumption), A/R, DPST (net is negative), RMPC (retail only), MISC, FCCR, FCDR - These posting types are taken from the order header.

CPAY, DPAY - These posting types are taken from the order header when payments are made on the summary page.

WTDN, WTUP - These posting types are taken when a payment is written up or down in program ARPE, Cash Receipts Entry.