N
Nancy
When I enter data into my purchase order form, the form calculates the line
item total across the line, and then an order subtotal at the footer of the
form. I then manually enter the tax and it calculates the order total. My
report to shows my data and everything looks fine. I now have created an
order summary report. On the Order Summary Report it shows the following
Info:
Vendor
OrderID
Order Date
Shopping Method
Nomenclature
Part Number
Line Item Total
At the bottom of each Vendor entry there is a total for that vendor. On
several entries, the order summary shows double entries. I have the purchase
order transaction listed once with an order ID but when it shows on the order
summary, it shows the entry two times. In this particular case, there is no
line item total or subtotal as we did not keep that information at the time.
On another entry in the same order summary, for one purchase order from one
vendor we ordered two items. One item was priced at $5200.00 the second item
was priced at $3800.00. The line total, subtotal, and the order total all
calculated correctly on the purchase order and the report. When I open my
order summary is where I have a problem. On the order summary, the line item
total is correct but the order totals column now has $9000.00 for both
entries. When I look at my column for the order total for that vendor it now
has calculated the figure to $18000.00
I am using 2007 and used a template off the website as my bases for this
order summary. Everything else is working fine. Any ideas on why this is
happening?
On the order summary properties control source for the vendor order total I
have this entry:
=Sum([Order Totals])
Thanks
item total across the line, and then an order subtotal at the footer of the
form. I then manually enter the tax and it calculates the order total. My
report to shows my data and everything looks fine. I now have created an
order summary report. On the Order Summary Report it shows the following
Info:
Vendor
OrderID
Order Date
Shopping Method
Nomenclature
Part Number
Line Item Total
At the bottom of each Vendor entry there is a total for that vendor. On
several entries, the order summary shows double entries. I have the purchase
order transaction listed once with an order ID but when it shows on the order
summary, it shows the entry two times. In this particular case, there is no
line item total or subtotal as we did not keep that information at the time.
On another entry in the same order summary, for one purchase order from one
vendor we ordered two items. One item was priced at $5200.00 the second item
was priced at $3800.00. The line total, subtotal, and the order total all
calculated correctly on the purchase order and the report. When I open my
order summary is where I have a problem. On the order summary, the line item
total is correct but the order totals column now has $9000.00 for both
entries. When I look at my column for the order total for that vendor it now
has calculated the figure to $18000.00
I am using 2007 and used a template off the website as my bases for this
order summary. Everything else is working fine. Any ideas on why this is
happening?
On the order summary properties control source for the vendor order total I
have this entry:
=Sum([Order Totals])
Thanks