BULK DELETE CONTRACT PRICING 2

[johnny45]

During our Accpac Set up we imported customer specific pricing to the contract pricing of AP.

However, now if a customer has a cash discount the discount must be manually inserted on the order line....

In hindsight we should have set up INDIVIDUAL price lists for these customers rather than a contract price list for them.......

What is the best way to fix this ?

(export the contract pricing and re import as a customer specific price list ?....can I then delete the contract pricing using SQL )

 

[Jay Converse]

You're not making sense. First, A/P doesn't have contract pricing, I/C does. Second an Individual price list for each customer is in fact a contract price list. Unless you're talking about a list named, for example, "RETAIL", and you're assigning more than one to that list.

 

[ettienne]

Customer <> AP
Maybe this is not for Sage Accpac ERP?

 

[johnny45]

Sorry for the confusion...AP=Accpac

Forgive my lack of knowledge....

There are 2 places to price Items
1-I/C Item Pricing
2-I/C Contract Pricing

If an Item is on the Item Pricing and NOT on Contract Pricing the Item Pricing will show up on the sales order along with the associated discount level(A,B,C,D or E) AND the TERMS discount for that particular customer.

If an Item is NOT on the Item Pricing and IS on Contract Pricing the Contract Pricing will show up on the sales order with NO discounts....

We would like to set up pricing by CUSTOMER in a way that the TERMS discount get applied to the SALES ORDER along with the associated discount level(A,B,C,D or E)....

Q: is my understanding of the pricing correct?
Q: does my earlier post make more sence ?

 

[Jay Converse]

Yes, it makes perfect sense now that all your acronyms are straight. ;-)

And, that's exactly what you want.

 

[johnny45]

So that said and done can I BULK delete the cotract pricing after I Export and re import as a Item Pricing using SQL to the contract pricing table?
WHat table is it ?

 

[johnny45]

DELETE FROM ICCUPR
WHERE CUSTNO = my customer number

 

[johnny45]

Can I use the above SQL without interfearing with the accpac business logic ?

 

[Jay Converse]

In this case, yes.

 

[johnny45]

THANK YOU tuba2007