Setup Selling Price and Purchase Cost Priority Under Advanced Options

Modified on Mon, Mar 31 at 2:14 PM


Overview:

The Selling Price Priority and Purchase Cost Priority features in QNE AI Cloud Accounting allow
businesses to customize how prices are determined in sales and purchase transactions. These
settings help ensure pricing consistency based on predefined references such as fixed price, last
invoice price, last purchase order price, and more.


Scenario:

A business wants to automate its pricing strategy.

  • For sales, they want to prioritize Fixed Price but fall back on the last invoice price if no list price
    is available.

  • For purchases, they want to prioritize the last purchase invoice price to ensure they use the
    most recent supplier cost.

By configuring the Selling Price Priority and Purchase Cost Priority settings, they can ensure
accurate and automated pricing across transactions.


Solution:

Go to Accounts > Advanced Options.



Setting Up Selling Price Priority

  1. Click on the Sales tab.

  2. Click the Setup button for Selling Price Priority to adjust the order of price references.

  3. Arrange the following options in order of priority by dragging the first-column icon:

    • Fixed Price – Based on the List Price set in Stock Maintenance.

    • Last Sales Invoice – Uses the last invoice price for the customer.

    • Last Quotation – Uses the last quoted price for the customer.

    • Last Sales Order – Uses the last sales order price for the customer.

    • Last Delivery Order – Uses the last delivery order price for the customer.

  4. Toggle ON/OFF specific price sources under the Action column to enable or disable them.

  5. The priority setting will now apply automatically in sales transactions.


Setting Up Purchase Cost Priority

  1. Click on the Purchase tab.

  2. Click the Setup button for Purchase Cost Priority to adjust the order of cost references.

  3. Arrange the following options in order of priority by dragging the first-column icon:
    • Fixed Cost – Based on the Purchase Price in Stock Maintenance.

    • Last Purchase Invoice – Uses the last purchase invoice price from the supplier.

    • Last Purchase Requisition – Uses the last purchase requisition price from the supplier.

    • Last Purchase Order – Uses the last purchase order price from the supplier.

    • Last Goods Received Note – Uses the last GRN price from the supplier.

  4. Toggle ON/OFF specific cost sources under the Action column to enable or disable them.

  5. The priority setting will now apply automatically in purchase transactions.


Application:

Application #1: Selling Price Priority

A retail company sells a product to a repeat customer.

    Step 1: The system first checks for a Fixed Price from Stock Maintenance.

    Step 2: If no fixed price is set, it uses the price from the last Sales Invoice.

    Step 3: If no invoice exists, it checks the last Quotation given to the customer.

Result: The system automatically applies pricing based on the predefined priority settings, ensuring
accuracy and consistency.


Application #2: Purchase Cost Priority

A restaurant regularly buys ingredients from the same supplier.

    Step 1: The system checks the Last Purchase Invoice for the most recent price.

    Step 2: If no invoice is available, it refers to the last Purchase Order.

    Step 3: If no order exists, it checks the last Goods Received Note for pricing.

Result: The restaurant ensures accurate cost tracking based on recent supplier transactions.


By using Selling Price Priority and Purchase Cost Priority, businesses can automate pricing decisions
and maintain consistency across all transactions. 






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article