Jump to content

balance on portals


gregorytan
 Share

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

Recommended Posts

HI

I had created 3 table call invoice, statement and credit. Here i need to create a monthly statement for my invoice.

In my statement we have date, invoice no, debit, Credit and Balance.

Date.................... Invoice No...........Debit.............Credit............. Balance

12/29/2010............0001................... 120....................................... 120

12/29/2010............0004....................400........................................520

12/29/2010............0006....................320........................................840

12/29/2010..........CN0001....................................120......................720

My problem here is how can we get the balance from portals, and is there anywhere that we can add in the Credit notes

in the same portals. Hope that someone here can help me for that.

Thanks

Link to comment
Share on other sites

HI

I had created 3 table call invoice, statement and credit. Here i need to create a monthly statement for my invoice.

In my statement we have date, invoice no, debit, Credit and Balance.

Date.................... Invoice No...........Debit.............Credit............. Balance

12/29/2010............0001................... 120....................................... 120

12/29/2010............0004....................400........................................520

12/29/2010............0006....................320........................................840

12/29/2010..........CN0001....................................120......................720

My problem here is how can we get the balance from portals, and is there anywhere that we can add in the Credit notes

in the same portals. Hope that someone here can help me for that.

Thanks

PROBLEM.fp7.zip

Link to comment
Share on other sites

1. There is no need for a Statements table to produce a monthly statement; OTOH, a Customers table would be very useful.

2. A portal cannot show records from more than one table. Either put invoices and credits in the same table, or change your statement's arrangement to something like:

Invoices:

Date        Invoice     Debit       

12/29/2010  0001        120         

12/29/2010  0004        400         

12/29/2010  0006        320         



Credits:

Date        Credit      Credit      

12/29/2010  CN0001      120



Balance:

720

Link to comment
Share on other sites

HI

Thanks, will rearrange the statement.

1. There is no need for a Statements table to produce a monthly statement; OTOH, a Customers table would be very useful.

2. A portal cannot show records from more than one table. Either put invoices and credits in the same table, or change your statement's arrangement to something like:

Invoices:

Date        Invoice     Debit       

12/29/2010  0001        120         

12/29/2010  0004        400         

12/29/2010  0006        320         



Credits:

Date        Credit      Credit      

12/29/2010  CN0001      120



Balance:

720

Link to comment
Share on other sites

This topic is 4421 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
 Share

×
×
  • Create New...

Important Information

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