Skip to main content

Steps to Set Up Purchase Requisition Parameters in MSD Axapta

Steps to Set Up Purchase Requisition Parameters

1. Click Accounts payable > Setup > Parameters.


2. Click the Purchase requisition tab to specify the parameters for purchase requisitions.

3. In the Purchase requisition catalog field, select which items to make available in purchase requisitions.

• Catalog - Applies items that have been filtered for use in purchase requisition

• All items - Applies all items

• Non stopped items - Applies items that are not blocked for purchase.


4. If you selected Catalog in the Purchase requisition catalog field, select the product catalog to apply to purchase requisitions in the Product group field.

5. In the Category node, select a category catalog to apply category items to purchase requisitions.

6. Select the Lock multiples, Lock max. order quantity, or Lock min. order quantity to prevent requisitioners from overwriting quantities in purchase requisitions that have been set up for the item. Item quantities are defined in Inventory management > Items Details > Setup > Default order settings (Purchase order) or Site specific order settings (Purchase order) if multisite functionality is enabled.

7. Select the Business justification check box to make it mandatory to enter a business justification before the purchase requisition can be submitted.

8. Select the Unit price check box to make sure that the unit price is always specified before the purchase requisition can be submitted.

9. Select the Vendor check box to make sure that the vendor is always specified before the purchase requisition can be submitted.

10. In the Auto create purchase order field, specify how purchase orders are created from approved purchase requisitions.a.

No: Purchase orders are always created manually

b. All: Purchase orders are always created automatically

c. General purchase: Only purchase orders of the type General purchase are created automatically

11. Select the Ledger account selection filter check box to apply a ledger account filter to purchase requisition lines and then click Add ledger account categories to add account categories to the filter.

Popular posts from this blog

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...

Table lists which can have large number of records in Ax 2012

If you are facing database or application performance issue then you can check these tables that may have large number of records. ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTBATCH ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCT ECORESPRODUCTTRANSLATION ECORESPRODUCT ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTDIMCOMBINATION ECORESRELEASESESSIONPRODUCT ECORESRELEASEPRODUCTLEGALENTITY INVENTSUMLOGTTS INVENTCOSTLISTPARM GENERALJOURNALACCOUNTENTRY GENERALJOURNALACCOUNTENTRYZAKAT_SA SMMTRANSLOG LEDGERENTRYJOURNALIZING DIMENSIONFOCUSBALANCE MARKUPTRANS INVENTTRANSPOSTING INVENTREPORTDIMHISTORY SALESPARMLINE SOURCEDOCUMENTLINE INVENTTRANS TRANSACTIONLOG INVENTTRANSORIGIN INVENTSETTLEMENT SALESPARMSUBTABLE SALESPARMTABLE SOURCEDOCUMENTHEADER SALESPARMUPDATE SQLSYNCINFO GENERALJOURNALENTRY SUBLEDGERVOUCHERGENERALJOURNALENTRY CUSTSETTLEMENT SMMACTIVITYPARENTLINKTABLE INVENTSUMDATETRANS LEDGERTRANSSTATEMENTTMP DIMENSIONFOCUSLE...

Code to get Invoice settlement data for customer in ax 2012

This is simple Code to get Invoice settlement amount data for customer payment in ax 2012. This data is after posting of data. select sum(SettleAmountCur) from custSettlement where custSettlement.TransRecId == custtrans.RecId If you want get settlement amount before posting than you can refer spectrans table.The table SpecTrans contains all the transactions marked for settlement for payment journal. while select spectrans join custtransopen join custtrans where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId && spectrans.SpecTableId == ledgerjournaltrans.TableId && spectrans.SpecRecId == ledgerjournaltrans.RecId && spectrans.RefCompany == custtranssopen.DataAreaId && spectrans.RefTableId == custtranssopen.TableId && spectrans.RefRecId == custtranssopen.RecId && custtransopen.RefRecId == custtrans.RecId && custtransopen.AccountNum == custtrans.AccountNum { info...