Jump to content

help me whit a invoice


Dani R

This topic is 5561 days old. Please don't post here. Open a new topic instead.

Recommended Posts

if i have in table 1 invoice number and in table 2 invoiceLine how can i billed a invoice repot what will show the oderlines by invoice number?

You make your report in table 2. Place the invoice number and other data from table 1 into a Sub-summary via relationship. Sort by invoice number.

Link to comment
Share on other sites

yes i what to see in the layout report that in the top i will see the order number and in the bottom i will see the orederlines

I think you want to see only 1 order on a page. Take a look at Report 2. The only difference between it and Report is that I went to layout mode, selected Part Setup from the layout menu and set the Sub-Summary part to page break before every occurrence.

mc_barter_rhl2.fp7.zip

Edited by Guest
Link to comment
Share on other sites

Here are step by step instructions:

Go to Layout Mode

Select New Layout from Layout Menu

Set Show Records from to Orders_line

Name Layout

Select Columnar List/report

Click Next

Click on Report with grouped data

Click on Include Subtotals

Click on Next

Select fields you want to include in the report from this table & Parent table

Click on Next

Set Report Categories to orderIDFK

Click on Next

Set order to orderIDFK

Click on Next

Click on Next

Select Standard theme

Choose Current Date for Top Right

Choose page Number for Bottom Right

Click on Next

Click on Create Script

Click on Next

Click on View in layout mode

Click on Finish

Make adjustments to layout.

Run the script to see the report.

Link to comment
Share on other sites

I made a new script and attached it to the button. It uses Go to related record step to limit the records in Orders_line to those related to the order.

You asked about using this layout in find mode. This is not a good layout for finds.

Link to comment
Share on other sites

This topic is 5561 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.