Information Systems:CCP - Miscellaneous Billing
In the 'contract' part of CCP (Customer/Contract Pricing), we can enter rebates from the vendor. COOP, which are co-op fees as the contract level, or VEDI, which are vendor debits at the item level.
Bills to the vendor or rep are generated automatically, based on the entered parameters.
Co-op Fees
These are entered at the contract level.
2/09/16 12:12:49 uniPHARM -- PRODUCTION CXRIU410/UPDATE
UPDATE UX - Enter/Update Contract Level Billing PRODUCTION 1.00
Contract #
BNA007BLIS BLISTEX JULY MEMO
Seq # Class Timing Billing Date
10 COOP LAST SALE Last day of the sale 00 00
For Cust/Vend/Broker
BROK 10102 BLISTEX/ZARINA CONFECTIONER
Method Bill Basis $/Funds % $ per Unit
APDED FIXEDAMT 250.00 CAD .000 .000
Cost Centre Project Acct Bypass
IFP 007 N
Added by User/Date Last Updated User/Dte Posted Date
SHELLYL JUN 12 14 SHELLYL JUN 12 14 JUL 31 14
Timing determines when the bill is generated.
FIRST SALE First day of the sale uses sales start date on the contract header LAST SALE Last day of the sale uses sales end date on the contract header PO RECEIPT Receipt of the first PO looks for PO's with the contract number in the shipment mark SPEC DATE On billing date specified uses the billing date on this record
Bill Basis determines how to calculate the amount of the fee.
AMTPURCH % of Total amount purchased unbilled PO receipts with this contract # in shipment mark AMTSOLD % of Total amount sold sales for all items on this contract, since last bill date FIXEDAMT Fixed amount amount from this record UNITPURCH $ per unit purchased unbilled PO receipts with this contract # in shipment mark UNITSOLD $ per unit sold sales for all items on this contract, since last bill date
Method determines how the vendor or rep is to be billed.
APCRD A/P credit transaction will be transferred from A/R to A/P APCS A/P car stock transaction will be transferred from A/R to A/P APDED A/P Deduction transaction will be transferred from A/R to A/P ARCHQ A/R Cheque REPRT Report only
For Cust/Vend/Broker
Vendor Debit
These are entered at the item level.
2/09/16 12:32:54 uniPHARM --Volume test CXRIU330/UPDATE
UPDATE UX - Enter Contract Item Further Details VOLUME 1.00
Contract # Vendor # Broker #
SH-DL-0811 ZERO BARS 22547 22547
Item
R 00874529 ZERO BARS GOLD 50GM DARK
Seq # Type For Warehouse Timing $ or % UOM Margin %
22 VEDI VEND *ANY PO REC 1.930 CAD BX
Applies to Acct Effect EDL Zone Price List Rebates?
NET VEND APDED *ANY *ANY N
Bill on Date Send Bill to Billing Line Description Bill Backs?
00 00 10843 N
Added by User/Date Last Upd by User/Date Posted Date
NORMAM AUG 10 15 NORMAM AUG 10 15 AUG 16 15
Timing determines when the bill is generated.
MONTHLY At end of each month on the first of the month PO REC On receipt of PO receipt of this item with contract # in shipment mark, since last bill date SALE At time of sale sale for this item with contract # in shipment mark, since last bill date SLS END At end of sales period after sales end date on the contract header SPEC DT On billing date specified bill on date from this record
Timing also determines how the amount is calculated.
MONTHLY At end of each month receipts of this item with contract # in shipment mark, since last bill date PO REC On receipt of PO receipts of this item with contract # in shipment mark, since last bill date SALE At time of sale sales for this item with contract # in shipment mark, since last bill date SLS END At end of sales period sales for this item with contract # in shipment mark SPEC DT On billing date specified receipts of this item with contract # in shipment mark
Applies to
MEMO Memo NET SALE Net Sales Price NET VEND Net Vendor Price PRICE TICK Price Ticket
Accounting Effect
*NONE No Accounting Effect APCRD A/P Credit transaction will be transferred from A/R to A/P APDED A/P Deduction transaction will be transferred from A/R to A/P ARCHQ A/R Cheque PO PRICE Purchase Order Price REDUCECOST Reduce cost and print report REPORT Report on
Send Bill to
Generate Billing
Every night, CXBILL03C, CXBILL06, CXBILL, and CXBILL07 are called from EODUPD.