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
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:
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 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:
Under the Purchasing General Configuration tab:
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:
- Intacct Topic of the Week – Revenue Management with Multiple Revenue Types
- Intacct Tutorial: Setting Up Restrictions in a Multi-Entity Environment
- Intacct Tutorial: GL Accounts in Multiple Entity Environments
- Intacct – Shared Document Storage
- Intacct Cloud Accounting: The Power of the Page Editor