Tax details do not populate in report.

[rajudh]

Hi,
Can anyone help me ?
I have made a Tax Invoice.
Invoice form is a combination of Invoice details table, Invoice table and product table.
It has Tax calculation fields in footer which is derived from Invoice details table sub form like 5%Amt,
12%Amt, 18%Amt & 28%Amt.
This fields does not show in Report.


My question are -
1. How to populate Tax Calculation field in Report ?
2. How to make Invoice Form blank for another entry ?
3. How to limit Product record entry say 10 or 12 per Invoice ?
4. How to update stock ? i.e. purchase entry should increase stock and sale entry should decrease stock for that particular product.

5. How to make reports for -
a. Date wise Sale Report-
b. Date wise Purchase Report
c. Customer wise Sale Report - from date to date
d. Customer wise purchase Report - from date to date
e. How to search, Edit Invoices ?

file attached.

thank you

[June7]

Those are a lot of questions. Really should tackle one issue at a time. I will try to give you starting points on some.

1. Consider calcs like: =Sum(IIf([GST%]=5, [Amt], Null))

Looks like need to include Customer table in report query, link to Invoice table, instead of using DLookup. Domain aggregate expression can cause slow performance. Can do same for form but don't use INNER JOIN - be sure to lock controls so cannot edit customer info. Another technique is to include fields in combobox RowSource then textbox references combobox columns by index. Index begins with 0 so column 2 has index 1: =CustomerID.Column(1).

2. move to new record row

3. why? is it 10 or is it 12?

4. don't do this, calculate stock balance when needed, don't save it - review http://allenbrowne.com/AppInventory.html

5.
a. - d. start building reports that apply sorting and grouping rules and dynamic filter - when you have specific issue, post question
a. - e. review http://allenbrowne.com/ser-62.html

Why is customer in Product table?

Advise NOT to use spaces nor punctuation/special characters (underscore only exception) in naming convention for any objects. Better would be GSTPct or GST_Pct.

Cannot directly use Null in an equality expression. Nothing is ever equal to or not equal to Null - there is nothing to compare, not even Null=Null. Use Is Null or IsNull or Nz. Review http://allenbrowne.com/casu-12.html

[orange]

See this free data model from Barry Williams for ideas on database structure.
Did you "test" your database structure with some sample data before building in physical Access?See StumpTheModel.
June has given good advice.

[rajudh]

Thank you for your quick reply.


I want to clear that I am not expert in Access.



I am learning from Youtube, and tutorials from net.


You have solved my 1 & 2 question.


I want to print Invoice in A5 size paper. For that reason I am limiting the entries to 10.
so that it should not print on second page.


Just another thought -


I want to make Invoice form like professional look.


can I add a button for save and close ?


Another button for opening and editing previous Invoices ?



A little help would really be appreciated.

I will be grateful for your help

Thank you once again.

[June7]

Add buttons where - on report object? Buttons on report do not work in PrintPreview, only ReportView.

On form, add whatever buttons you want. This is basic Access functionality.

Build a report for printing invoice. Set layout for A5 size paper.

[Bullschmidt]

I have made a Tax Invoice.
Invoice form is a combination of Invoice details table, Invoice table and product table.
It has Tax calculation fields in footer which is derived from Invoice details table sub form like 5%Amt,
12%Amt, 18%Amt & 28%Amt.
This fields does not show in Report.
My question are -
1. How to populate Tax Calculation field in Report ?
2. How to make Invoice Form blank for another entry ?
...

Don't know if my free sample Invoices DB might give you some ideas...

http://www.bullschmidt.com/access