• Go to Reports > Purchase Analysis > Consolidated Purchase Book.

The user will select the options as per the requirement.

a. From: The user will feed the date from which the report needs to be viewed.

b. To: The user will feed the date till which the report needs to be viewed.

c. Operator name: The user will select the operator name to view the report of the selected operator.

d. Terminal: If working in a multi-user environment the user can mention the Terminal/System Name for which the report needs to be generated.

e. Order from App/Non App: The user will select whether to include sale order from App Order/Non App/Both.

f. Cash/Credit/Discount: Select the Type of Transactions for which the report needs to be viewed.

g. Less Return's: Select the option to less the type of returns for which the report needs to be viewed.

h. With Challan: Select 'Yes' to view the report with challan or select 'O' to only view the challan otherwise keep it as 'No'.

i. Club Cash Sales: The user will select the Cash Sales to be merged in the report that needs to be viewed.

j. + Stock Add: The user will set the option as follows.

Yes: To view the report with Stock receive transaction details.

No: To view the report without Stock receive transaction details.

Only: To view reports of only Stock receive transaction details.

k. Detailed/Summarised: The user will select the Type - Detailed/Summarised in which the report needs to be viewed.

l. Less Cr/Dr Note Value: The user will select the option to less the Credit/Debit Note as per the requirement.

m. Amt.=Rate*Qty, Net, R*Q-D/Anal.on Rate: The user will select the amount calculation in which the report needs to be viewed.

n. Index on Date/P/MR/A/R: The user will select the indexing method in which the report needs to be viewed.

o. Purc.Detail/Grand Total: The user will select the method in which the report needs to be viewed. 

p. Selected company: The user will set the option 'Yes' to view the report of a particular Company otherwise keep the option as 'No'.

q. More Item Selection: The user will set the option 'Yes' for more item selections otherwise keep the option as 'No'.

r. Selected Party: The user will select 'Y' to view the report for a particular party otherwise keep it as 'No'.

Click on 'Accept' button.

• Now press 'Alt+P' key.

• Now the user will click on 'View/Print/Excel' as per the requirement.
• Suppose click on 'View'.

• Now the user will select 'INDEX Wise Total/Only Last Total' as per the requirement.
• Suppose select 'Only Last Total'.

After following the above steps, the user can view Consolidated Purchase Book will get generated in Marg ERP Software.