Price with Precision

Owned by Gaurav
Last updated: Jul 31, 2023
2 min read

PRICE LIST PRECISION 

OBJECTIVE: 

The objective of the document is to place the price list price precision control across the system so that fraction values in terms of amount can be controlled and differences would not come during the generation of the transaction document. 

SOLUTION DESIGN 

PRICE LIST 

The user can enter the price precision at the price list header and thereafter system validate the product prices according to defined price precision.  

Assuming if the value is entered at the Price Precision = 4 at the header of Price List Window, then the Product price will be up to 4 precision like 45.6667. If user try to enter the more fraction value then on save record,  system will validate and round off the value up to defined price precision on header. 

 Find below the print shot of the Price list and Product price tab: 

TRANSACTION WINDOW 

There are transaction window where the impact of this price precision will come in the system. System will bring the Price from Price list window based on Price List Precision and the Amount field to be rounded based on Precision defined on Currency window. 

Find below the list of the transaction window where you can see the functionality of this price precision: 

  1. Opportunity 

  2. Sales Quotation 

  3. Sales Order 

  4. AR Invoice 

  5. Blanket Sales Order 

  6. Requisition 

  7. Purchase Order 

  8. AP Invoice 

  9. Vendor RMA 

  10. Customer RMA 

  

PROCESS/FORMS 

There are going to some of the processes/forms where which used to generate the transaction given above automatically. Find below the list of the processes: 

  1. Create PO from Requisition 

  1. Create SO (Opportunity Window) 

  1. Create SQ (Opportunity Window) 

  1. Create PO from Sales Order Process in Menu 

  1. Create SO (Sales Quotation Window) 

  1. Generate Invoice process in Menu 

  1. Generate Invoice Manual form