Home > Margerp > Sale Analysis > How to view Brand wise Item Monthly Sale report in Automobile Setup of Marg Software?
In Marg software, the user can view Monthly sale report along with the Items Brand.
In order to view Brand wise Item Monthly Sale report, the user needs to follow the below mentioned steps:
Note: The user will press 'Spacebar' key or Plus'+' key to select a particular Brand or Press Asterisk '*' key to select All Brands.
An ‘Items/Month wise’ window will appear.
a. From-To: The user will feed the date range from which date till which date report needs to be view.
b. Operator Name: The user will select the operator name to view operator wise report.
c. 80Column/132 Column Paper: The user will set column on bill format as per the requirement.
d. Stock Less: The user will set option as following.
Yes: To view report with Stock Issue transactions detail.
No: To view report without Stock Issue transactions detail.
Only: To view report of only Stock Issue transactions detail.
e. Value in Rs./Thousands/Lakhs: The user will set option to view amount value in formats i.e. Rs. , thousand, Lakhs.
f. Amt=Rate*Qty,Net,R*Qt-Disc.:The user can define the amount calculation as per the requirement.
g. All/Selected Brand: The user will set 'S' to view report of Selected Brand otherwise keep the option as 'A' to view All Brands.
h. Terminal: If working in multi user environment so the user can mention the Terminal/System Name for which report needs to be generate.
i. Order from App/Non App: The user can include sale order from app and non app.
j. Top 10 in Qty/Value/All/Trans.: The user will set option to view top 10 quantity/value/all/transaction wise report.
k. Net/Sale/SR/BE/Rep/PD/Smp/Stf: The user will select the option on which bases report needs to view i.e. net sale, sale, sale return, brk/exp issue, replacement issue or store transfer wise.
l. Value in Decimal: The user will set option 'Yes' to view value in decimal.
m. Report in Qy/Cases/Box/Value/: The user will select option to view item unit i.e. quantity, cases, box, value.
n. Value-Y/Weight-W required beyond qty: The user will select option 'V' to view item value wise or 'W' to view item weight wise report.
o. Monthly/Quartly/1-12 days/31 days: The user will select option as per the requirement to view report of only selected days or month wise.
p. Last Year Comparison: The user will set option 'Y' to view report with comparison of the last year otherwise keep the option 'N'.
q. More Item Selections: The user will set option 'Yes' for more item selection otherwise keep the option as 'No'.
r. Selected Party: The user will set option 'Yes' to view report Particular Party wise otherwise keep the option as 'No'.
Click on 'View/Print' as per the requirement.
Suppose click on 'View'.
After following the above steps, the user can generate the report of Brand wise Item Monthly Sale report in Marg Software.
In this way, the user can generate Brand wise Item Monthly Sale report in Excel.
1. Go to Daily Reports > Sale Report > BRAND/Group/Category/HSN/SAC > Analysis with.
2. An 'Analysis With' window will appear.
3. Feed date range. In 'Report for' set 'Sale'.
4. Select other filter options as per the user requirement.
5. Now, click on View/Print/Excel as per the requirement.
6. A 'Select' window will appear. Press 'Enter' key on particular brand and press Asterisk '*' key for select all brands.