Hi guys
i need help in custom report
i have a small shoe industries
and i want to make a yearly report every of every customer includes all sale detail , debit . credit and balance. i am having difficulty in have item detail in report . we have item code (Gents , ladies ,Boys , kids) etc.
i want report like:
(Date ; Customer ; sale Reference ; item code ; item code ; item code ; total item ; debit ; credit ; total balance)
i would appreciate if anyone help.
Do you mean a list of all the sold items grouped in the same line? The way custom reports work don’t permit you to achieve the summary that you need. You cannot have opening balance, you cannot pivot tables, you cannot make calculations.
Maybe, it works for you, you better export a raw list and than do the transformation under excel with pivot tables connected to the export table.
i think i didnt explain that well.
I have many selling item under this code say
Under
Gents - 50 item
Ladies -48 item
Boys - 50 item
so in each sale invoice many item are sold from Gents , ladies , boys and so on.
Report like this
each line is for each invoice or receipt
So how did you set this up as inventory items in Manager? What I mean is did you create Gents, Ladies, etc. Inventory items?
Or list their group in a custom field?
Or to put the question another way, what identifies a shoe as a “Gents” shoe to the Manager software?