(703) 860-6945

Intacct FAQ: Understand, Set Up, and Modify Price Lists

Intacct FAQ: Understand, Set Up, and Modify Price Lists

Price Lists can be created to have the Item’s sales prices or purchasing costs to default in Purchasing and Order Entry transactions.  Price Lists can be assigned on the Transaction Definitions and the customer/vendor records.

Defining Price Lists in Intacct

But…which Price List does it look at when entering a transaction?

  • The system will look at the Initial Price List on the Transaction Definition.  If the Item is part of this Price List with the transaction date within the effective dates, it will use this Price List.
  • The system will look at the Special Price List on the Transaction Definition. If the item is part of this Price List with the transaction date within the effective dates, it will use this Price List and will ignore the Price listed in the Initial Price List.
  • The system will look at the Customer Price List on the Customer record. If the item is part of this Price List with the transaction date within the effective dates, it will use this Price List and will ignore the Initial Price List and Special Price List.
  • If the Price Lists are not set up in Transactions Definitions or Customer/vendor records, then the default price will be zero.

Overriding Price Lists to Allow for Special Pricing

HOWEVER, in the Price List setup, you have to set the “Fixed” flag to Y if you don’t want any of the prices to override in the order listed above.

To allow the override, you have to set up the Price List with a “Fixed” flag of N. For example, if the Fixed flag is Y on the Initial Price List, the system will stop and use the Initial Price List as the “FINAL” price to use for this item.

If you want the system to look at the Special Price List or the Customer/Vendor Price List, then set the Fixed flag to N.

Modifying the Price List to Allow Special Pricing

Special Price Lists for Customers and Vendors in Intacct

Also, what is the “Price list to update” on the Transaction Definition? If you assign a Price List in this field in the Transaction Definition, a price that is overridden by a user in the transaction entry will update the item price on that Price List.

Allowing User Price/Cost Overrides

To allow the user to override prices/costs, set up the Transaction Definition to allow the price/cost override:

Allowing Price/Cost Override Intacct

Setting Up Default Price Lists on Transaction Definitions

To set up a default Price List on the Transaction Definition, assign the Price List on the Transaction Definition General tab:

Assigning Price List on Transaction Definition Tab

Assigning Price Lists to Customers and Vendors

Price Lists can also be assigned to customers as long as the application is set up to allow customer or vendor price lists:

Under the Order Entry General Configuration tab:

Price Lists in Order Entry General Configuration

Under the Purchasing General Configuration tab:

Price Lists in Purchasing Configuration

Happy pricing!

Learn More: Intacct Tips and Tricks

Wipfli LLP/Brittenford Systems has amassed a library of helpful articles to help Intacct users better utilize their Intacct Investment. Head over to the “Tips and Tricks” Section and read the following for more:

Save

Save

Save

0 Comments

Leave a reply

Your email address will not be published. Required fields are marked *

*

Intacct User? Need More Advice? Search the Knowledge Base!

A great majority of these blogs are designed to answer the most frequently asked questions on the Wipfli/Brittenford Knowledge Base. If you have a question about any of the products we sell, service, or support, the Knowledge Base is the first place you should look.

We welcome you to learn more there, and if you have additional questions, to contact our support team using the button at the bottom right of this page.

Get Answers