Difference between revisions of "Information Systems:CCP - Miscellaneous Billing"

From uniWIKI
Jump to navigation Jump to search
Line 30: Line 30:
 
'''Timing''' determines when the bill is generated.
 
'''Timing''' determines when the bill is generated.
   
FIRST SALE First day of the sale
+
FIRST SALE First day of the sale uses sales start date on the contract header
LAST SALE Last day of the sale
+
LAST SALE Last day of the sale uses sales end date on the contract header
PO RECEIPT Receipt of the first PO
+
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
+
SPEC DATE On billing date specified uses the billing date on this record
   
 
'''Bill Basis''' determines how to calculate the amount of the fee.
 
'''Bill Basis''' determines how to calculate the amount of the fee.
Line 51: Line 51:
 
REPRT Report only
 
REPRT Report only
   
'''For Cust/Vend/Broker'''
+
'''For Cust/Vend/Broker'''
  +
 
 
==Vendor Debit==
 
==Vendor Debit==
   

Revision as of 14:41, 9 February 2016

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
AMTSOLD       % of Total amount sold     
FIXEDAMT      Fixed amount               
UNITPURCH     $ per unit purchased       
UNITSOLD      $ per unit sold     

Method determines how the vendor or rep is to be billed.

APCRD         A/P credit   
APCS          A/P car stock
APDED         A/P Deduction
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     
PO REC        On receipt of PO         
SALE          At time of sale          
SLS END       At end of sales period   
SPEC DT       On billing date specified

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           
APDED         A/P Deduction        
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, and CXBILL are called from EODUPD.